Monthly Archives: June 2018

How to Hide/Unhide one option in Radio button PeopleSoft

Posted on by

How to Hide/Unhide one option in Radio button PeopleSoft

How to Hide/Unhide one option in Radio button PeopleSoft by using javascript.

For example. If you have 2 radio button on the page in Peoplesoft contain value Y and N but you want to hide a radio button has value Y.

1.  Define Page Field Name of Radio Button Properties =  RDO_Y

Result Page on Browser

2. Define JavaScript in HTML Area on page in application designer.

<script language=’javascript’>
document.getElementById(‘win0divRDO_Y$0′).style.display=’none’;
</script>

Result page in the browser after using javascript to hide a radio button when value Y is checked

You can find ID: win0divRDO_Y$0 by using right-click and inspect the radio button after the PeopleCode runs.

Another way: you can use a group box of each field radio button and using PeopleCode for hide or unhide radio button for your requirement.

How to use Rich Text Format in PeopleSoft

Posted on by

How to use Rich Text Format in PeopleSoft

How to use Rich Text Format in PeopleSoft in application designer.

You can input detail of requirement in record field long PeopleSoft.

1. Enable Rich Text of long field in application designer.

2. Save Detail

3. Use Detail of 2 by select long filed in the database and define value.

If &Datalong is data that select from your database.

Example: Record.Long_filed = &Datalong;

 

How to use Meta HTML PeopleSoft

Posted on by

How to use Meta HTML PeopleSoft

How to use Meta HTML PeopleSoft by use HTML object. The HTML Object creates in 2 way.

1. Create HTML object in application designer.

 

You call HTML Object by use function PeopleCode is GetHTMLText().  

You call HTML Object and pass a value in code HTML by using this syntax and past this code of each requirement.

DERIVED_WRK.HTMLAREA =GetHTMLText(HTML.CONTRACTS_RENEW, “parameter1”, “parameter2”);

2. You can create HTML Object in the navigation of PeopleSoft at PeopleTools > Portal > Branding > Branding Object and upload your HTML object.

You call HTML Object by use function PeopleCode is GetHTMLText().  

You call HTML Object and pass a value in code HTML by using this syntax and past this code of each requirement.

DERIVED_WRK.HTMLAREA =GetHTMLText(HTML.CONTRACTS_RENEW, “parameter1”, “parameter2”);

How to Make a Private PeopleSoft Query to Public using Update SQL

Posted on by

How to Make a Private PeopleSoft Query to Public using Update SQL

How to Make a Private PeopleSoft Query to Public using Update SQL. You can update Oprid is blank of all record relation

UPDATE PSQRYBIND SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYBINDLANG SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYCRITERIA SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYDEFN SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYDEFNLANG SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYEXPR SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYFIELD SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYFIELDLANG SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYRECORD SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;
UPDATE PSQRYSELECT SET OPRID = ‘ ‘WHERE OPRID = ‘OLD_USER’ AND QRYNAME = ‘NEW_USER’;

More suggestion:
– You Create a PUBLIC ps query by clone of the PRIVATE ps query
– Rename ps query from PRIVATE or PUBLIC query
– Delete a query

 

Reference:https://hexaware.com/blogs/how-to-make-a-peoplesoft-private-query-public/

Messagebox Syntax in PeopleCode

Posted on by

Messagebox Syntax in PeopleCode

Messagebox Syntax in PeopleCode of PeopleSoft for popup message has many styles of each requirement.

MessageBox Syntax

MessageBox(style, title, message_set, message_num, default_txt [, paramlist])

where param list is an arbitrary-length list of parameters of undetermined (Any) data type to be substituted in the resulting text string, in the form:

param1 [, param2]. . .

Description

Use the MessageBox function to display a message box window. This function combines dialog-display ability with the text-selection functionality of MsgGet, MsgGetText, or MsgGetExplainText. The style parameter selects the buttons to be included. title determines the title of the message.

For Example :

MessageBox(1, “”, 0, 0, “Messagebox use value of style box = 1”, “”, “”);

More Example Click Here

Reference: https://docs.oracle.com/cd/E13292_01/pt849pbr0/eng/psbooks/tpcl/chapter.htm?File=tpcl/htm/tpcl02.htm

Peoplesoft Message Catalog Table

Posted on by

Peoplesoft Message Catalog Table

Navigation of Peoplesoft Message Catalog Table:  PeopleTools > Utilities > Administration > Message Catalog

  • By default language

Step 1. input Message Set Number, description and description short

Message Set Number store in a table: PSMSGSETDEFN

Using  SQL for select data by this syntax

Step 2. input Message Number and detail

Message Number store in a table: PSMSGCATDEFN

Using SQL for select Detail of message catalog and message number

 

  • By owner language

select message catalog and detail by PSMSGSETLANG

select detail in message number of message catalog by PSMSGCATLANG

You can using this message catalog in peoplesoft for store html, sql, dynamic sql, description,  bind variables and use data in page or scroll area or grid of each requirements by using select sql of catalog table or use function in peoplesoft such as msggettext or  msggetexplaintext in peoplecode language.

More learning at How to use MsgGet, MsgGetText and MsgGetExplainText by Peoplecode Function of Peoplesoft

How to Check Record is Changed in PeopleCode

Posted on by

How to Check Record is Changed in PeopleCode

How to Check Record is Changed in PeopleCode in scroll level 1 and level 2 and more level

For example check record is changed in level 1 by use peoplecode function IsChanged() in the event action of SavePreChange.

Example 1

Local Rowset &Level0_ROWSET, &LEVEL1_ROWSET;
&Level0_ROWSET = GetLevel0();
For &I = 1 To &Level0_ROWSET.ActiveRowCount

If RecordChanged(Record.CONTRACTS, CurrentRowNumber()) Then
rem WinMessage(“Changed row message from level one.”, 64);
CONTRACTS.LAST_EMPLID.Value = %OperatorId;
CONTRACTS.LAST_UPDATE_DTTM1.Value = %Datetime;
End-If;
End-For;

Example 2

or copy code at here

Local Rowset &Level0_ROWSET, &LEVEL1_ROWSET;

If %Page = Page.CONTRACTS Then

&Level0_ROWSET = GetLevel0();
For &A0 = 1 To &Level0_ROWSET.ActiveRowCount

/***************************/
/* Process Level 1 Records */
/*————————-*/
If &Level0_ROWSET(&A0).ChildCount > 0 Then
For &B1 = 1 To &Level0_ROWSET(&A0).ChildCount
&LEVEL1_ROWSET = &Level0_ROWSET(&A0).GetRowset(&B1);
For &A1 = 1 To &LEVEL1_ROWSET.ActiveRowCount
If &LEVEL1_ROWSET(&A1).GetRecord(1).IsChanged Then
rem WinMessage(“ischanged”, 0);
CONTRACTS.LAST_EMPLID.Value = %OperatorId;
CONTRACTS.LAST_UPDATE_DTTM1.Value = %Datetime;
End-If;
End-For;
End-For;
End-If;
End-For;
End-If;

More example of level 2 and level 3 from below reference: https://docs.oracle.com/cd/E80738_01/pt854pbh2/eng/pt/tpcd/concept_UnderstandingDataBufferClassesExamples-074aee.html#topofpage