Grids are used all the time in PeopleSoft, and to populate them with
dynamic data could be quite challenging. Use the "Select" function to
read data from the database tables or views into either a row or rowset
object.

The following example first flushes the hidden work
scroll, then selects into it based on a field on the page, or any
criteria that you add to the “where clause”.

&RS = GetLevel0()(1).GetRowset(Scroll.CHECKLIST_ITEM);
&RS.Flush();
&RS.Select(RECORD.CHECKLIST_ITEM, "where Checklist_CD = :1 and
EffDt = (Select Max(EffDt) from PS_CHECKLIST_ITEM Where CheckList_CD =
:2)", CHECKLIST_CD, CHECKLIST_CD);