Thursday, 3 November 2016

Trigger Field Change from link created in HTML Area

1) Add HTML Area in Page e.g HTMLAREA
2) Identify Page Field for which Field change code should trigger on clicking link defined using HTML e.g. COMMENTS
3) Double Click Page Field and Got to Use tab and Check following properties
Invisible
Modifiable by JavaScript
Enable When Page is Display Only
Give Page Field Name in General Tab e.g. COMMENTS
4) Assign below Href to HTML Link to trigger field change Peoplecode
HREF="javascript:%SubmitScriptName(document.%FormName,'#ICSetField%Bind(:1).%Bind(:2).%Bind(:3)');"
While creating HTML Text pass bind values
%Bind(:1) Page Name
%Bind(:2) Page Field Name
%Bind(:3) Value of Field

Tuesday, 2 August 2016

Using Image in HTML for PeopleSoft

Image from PeopleSoft Database can be shown using %Image(Image Name). if HTML text is maintained using Message catalog then do following.

Message Catalog Text
--------------------------

<img src = "%1">

Assigning HTML text to Page field
------------------------------------------

Record.Field.value = MsgGetExplainText(Message Set Number, Message Number, "Default Text", "%Image(ImageName)");

Wednesday, 2 March 2016

PeopleSoft Access Related SQL's

Access to Component:

Select AUTH.CLASSID As PERMISSION_LIST
, MNUI.MENUNAME
, PNLG.PNLGRPNAME As COMPONENT
, AUTH.DISPLAYONLY
, AUTH.AUTHORIZEDACTIONS

From PSAUTHITEM AUTH
, PSPNLGROUP PNLG
, PSMENUITEM MNUI

Where PNLG.PNLGRPNAME = 'Component Name'
AND AUTH.PNLITEMNAME = PNLG.ITEMNAME
AND AUTH.MENUNAME = MNUI.MENUNAME
AND AUTH.BARNAME = MNUI.BARNAME
AND AUTH.BARITEMNAME = MNUI.ITEMNAME
AND PNLG.PNLGRPNAME = MNUI.PNLGRPNAME

PeopleSoft Toolbar Setup Migration

Tables need to be migrated are following

1) Toolbar Definition:

SELECT * FROM PS_EOTL_TB_DEFN WHERE EOTL_TOOLBAR_ID= 'Toolbar id';
SELECT * FROM PS_EOTL_TB_DISP WHERE EOTL_TOOLBAR_ID=  'Toolbar id';
SELECT * FROM PS_EOTL_TB_FFLD WHERE EOTL_TOOLBAR_ID= 'Toolbar id';
SELECT * FROM PS_EOTL_TB_BTNS WHERE EOTL_TOOLBAR_ID= 'Toolbar id';

2) Toolbar Button:

SELECT * FROM PS_EOTL_BTN_DEFN WHERE EOTL_TB_BTN_ID = 'Button Id';