Search This Blog

Thursday, January 21, 2010

peoplecode rowset

In PeopleSoft, the coding is done in peoplecode using peoplecode editor. Peoplecode is an object oriented language. Just like C++, Java, there is a concept of classes in peoplecode.
Data types can be divided into 2 types based on their nature.
1. Conventional data types like number ,date, string.
2. Object data types which are instantiated from Peopletools classes.
There are classes which are already defined and can be used right away in the code. If you want to create your own classes, it can be done with the help of Application classes.
Of the different classes availabe in peoplecode, following are the data buffer access types
1. Field class
2. Record class
3. Row class
4. Rowset class
The relationship between these 4 classes can be better understood as follows.
Field -is a subset of--> Record -is a subset of--> Row -is a subset of--> Rowset

Thus rowset object can be defined as data structure used to describe the hierarchial data.
Rowset Example: A component scroll area.
Using normal rowset object, we refer the data from the current acitve data structure in the component buffer.
Meaning, if a particular page , say Employee Personal Details page is opened, the current active data structure will be the Employee Personal Details component. Using the method getrowset(scroll.PRIMARY_RECORD_OF_THAT_SCROLL) will give us the entire structure of the particular scrolllevel.
Now using the notation row.record.field.value , we can use the data in that scroll.

standalone rowset:
Standalone rowsets are not associated with a component or page. Use them to work on data that is not associated with a component or page buffer. In earlier releases, this was done using derived work records.
Rowsets created using CreateRowset are not automatically tied to the database. This means if you insert or delete rows, the rows will not be inserted or deleted in the database when you save the page.
Note: All notations used are from 8.49 peopletools version.