kiran's space

If you are on Grid and want to change Background color or Cell or Row, you can use below code.

&ROW = &RS.GetRow(&A);

&ROW.Style = “PSGRIDCOLUMNHDR”;
&RS(&A).RECORDNAME.FIELDNAME.Style = “PSGRIDCOLUMNHDR”;

For identifying the Style Value, you might want to try below logic.

When adding fields to pages, we select a “style” for each new field. The style maps to a CSS class that is contained within a PeopleSoft stylesheet object. In most cases, we simply take the default value for the style and that gives us a consistent appearance on our pages. But sometimes we want to modify the visual appearance of a field.

To select a style, simply choose it from the dropdown list in the field properties. (There is a style for the field and one for the label.) Simple enough. But what do all the choices mean? Do you know what “PAFRAMELEVEL3WBO” is? Also, the style as it appears in App Designer is often just an approximation of what will appear in the browser. Do we need to use a trial-and-error approach to see what each style is?

Instead of that method, try displaying samples of all of the styles in the browser. 90% of them are duplicates or very specialized styles that are rarely used. But among the rest you might find good choices for your page design.

It’s pretty easy to do. Write some SQL that generates HTML:

   SELECT
   '
' || STYLECLASSNAME || '
'
   FROM PSSTYLECLASS
   WHERE STYLESHEETNAME = 'PTSTYLEDEF'

Insert an HTML Area on your page. Run the SQL and copy the results into the HTML Area (as a “constant” value instead of a field value). There is a limit to how much text you can put there, so you may need to restrict your selection in the WHERE clause of the SQL (in this example, I just picked one stylesheet). Save the page and navigate to it, and you should see something like this:

Pick the appropriate style and apply it to your field, then just delete the HTML Area and you should be all set. One thing to be aware of, though, is that most of the styles with backgrounds do not fill in more than the area taken by the text. You can see how this works by testing it. For the styles that do fill in larger areas, do a View Source in the browser and look for “width:100%”.

Usually conditional loops are used in any programming language.

Below is an example to control a message on RTF template based XML Publisher report using IF Loop.

Author is trying to display a message if there are no rows to be displayed on report.

Example:

<?xdoxslt:ifelse(number(@rownumber)!=0,’’,’There are no data’)?>

Enjoy for the day!

People Code to Update or Insert values to a record

&Rec = CreateRecord(Record.ABC_JOB);

&Rec.EMPLID.Value = “1”; /*Assign values to all Key fields*/
&result = &Rec.SelectByKey();
&Rec.STATUS.Value = “Active”;
If &result Then
&Rec.update();
Else
&Rec.Insert();
End-if;

There might be a requirement where we need to perform some action based on return value of Message Box.

For example: Save the component after user confirms by clicking Yes.

We can use below PeopleCode in Field Change Event.
&Answer = MessageBox(4, “”, 0, 0, “Please confirm if you want to Save”);
If &Answer = 6 Then
DoSave();
Else
End-If;

&Answer = 6 for response of “Yes”

&Answer = 7 for response of “No”