What is rowset in PeopleSoft?

In an Application Engine program, a rowset object is the equivalent of a record object that contains one row and a single record, that is, the State Record. PeopleSoft suggests using the Record object instead of a rowset object to obtain access to the State Record.

How do I sort rowset in PeopleCode?

Assuming the rowset has already been defined in the code, the ‘Sort’ method will then sort the rowset based on each of the fields specified. Each sort field must be entered in a pair combination: (1) the name of the field and (2) whether the sort is in ascending (‘A’) or descending (‘D’) order.

How do I delete rowset row in PeopleCode?

DeleteRow(&nRowNum); Here &nRowNum is the variable which will hold the index of the row to be deleted. If &nRowNum = 2, then the above statement will delete the second row of the rowset.

How do you populate data into grid in PeopleSoft?

PSoftSearch – PeopleSoft Blog The grid is placed on level 1 of a secondary page and is populated using Peoplecode written in the Activate event of the secondary page. We use the SQL object &VCHRS_GRD_SQL to fetch some Voucher IDs and Vendor IDs from the database and populate the grid with these values.

How are records processed in a rowset in PeopleCode?

PeopleCode | Loop through and process a series of records in a rowset. A common programming requirement asks that you loop through a list of records in a rowset. For current purposes, the rowset could be a grid or a scroll area on a page, or it could be data that you’ve loaded directly into memory for further processing.

Which is the function of rows, Rowsets in PeopleSoft?

Therefore to use these items you need to populate them using built-in methods like .fill () on a rowset, or .selectByKey () on a record. The advantage of using rowsets over SQL is that it makes the CRUD easier. There are built-in methods for selecting, updating, inserting and deleting.

How to create a standalone rowset in Barefoot PeopleSoft?

Below is a simple block of code to carry out this requirement for a standalone rowset. This code consists of three parts: (a) declare variables, (b) define the standalone rowset, and (c) loop through each record in the rowset.

How to use Rowsets in an application engine?

Application Engines do not have component buffer data as they are not running within the context of a component. Therefore to use these items you need to populate them using built-in methods like .fill () on a rowset, or .selectByKey () on a record. The advantage of using rowsets over SQL is that it makes the CRUD easier.