What are search Keys in a record? How is it different from alternate search keys?

The property search keys of a record comes into picture when you are in the search page of a component or in a prompt dialogue page where you uses the record.

When you load a component, you can see some fields coming up to search for a value. These fields are the fields which are marked as the search keys for your search record. If you do not have any search key for your component, then you will be directly taken into the component.

Your alternate search keys are non mandatory search keys for your component. Think of using it if you want your user to search the component based on some additional fields. In your component properties, you can mention whether you want to display the alternative search keys by default. Normally the alternative search keys are displayed only if the end user clicks on advanced search option.

How will you implement level 4 while designing a page?

With the delivered PeopleTools design it is not possible to implement a level 4. You can only have upto level 3. The allowed levels are
1. Level 0
2. Level 1
3. Level 2
4. Level 3

But often there will be business scenario where you need to show a child level data corresponding for a level 3. In such scenarios you can use other alternative workarounds to display Level 4 data. One of the most popular workaround is to create a secondary page and provide a push button or hyperlink which will open the secondary page modally. The secondary page have data or grids with no auto select option. Now you can pass the keys of your level 3 data with the help of a work record. Now based on the values in the work record, you can fill the data in the secondary page on the PageActivate event.

If your level 4 has many nested childs or complicated logics, you can think of a new component and can open that component modally.

Yet this is just one of the workaround, you can have your own methods to display level 4 data. But one thing is sure, you need to manually handle level 4 data, PeopleTools will not provide any data handling method/property/functions for supporting level 4.

How do you login in correction mode in the Component Interface?

      Get History Items and Edit History items property to should be set to true.

      Get History Items alone: - Update display all - modes will be used.

What are properties?

     The Fields in the level 0 in the component are the properties of the component.              

                                                                                                                        

Standard properties                                User-Defined properties

Createkeyinfocollection                               Developer can further control the exposed Getkeyinfocollection field properties.          

Findkeyinfocollection

Property Info collection

GetHistoryItems (Update/Display mode or

                            Correction mode)

EditHistory Items

InteractiveMode

What is method? What are the different types of method?

 Methods: - A method is an object that performs a very specific function on a component interface at run-time.

Standard methods and user-defined methods.

Standard methods: - Automatically generated upon the creation of a new component Interface in Application.

Apart from the Standard methods there are Standard methods available for the use with any collection.

User-Defined methods: - User-defined methods are those that you can create to meet the requirements of an individual component interface.

How do you provide security for the component interface?

Open the Permission list

On the Component Interface tab, Add row and select the newly created Component Interface.

Edit the permissions to give permission for the standard methods

Get, Create, Save, cancel, find. 

what is the difference between exit(0),exit(1) when we are using this functions in AE

      Exit (1) causes immediate termination of a PeopleCode program. Use this parameter to rollback database changes.

      Exit (0) caused immediate termination of a Peoplecode Program but don’t make rollback in the database.

what is the difference between the %SELECT and %SELECTINIT meta sql functions.

%select : if any values have not selected then previous value will be there

%selectinit : if any values have not selected then previous value will reinitiate to null

What is the maximum limitation on temporary table instances in AE.

99

What are different types Do Select?

1)      Select/Fetch

2)      Reselect

3)      Restart able

Select/Fetch: -

 Opens the cursor only at the first time and retrieve rows one at loop.

 Commits inside the step (commits in the Called Section) are ignored if AE is Restart enabled.

Reselect: -

It opens the cursor and closes the cursor on each iteration of the loop.

It will reselect the same row of data.   

Logic in Actions of the step should be such that it will be changing the status of the rows in the table the do select is selecting.

Commits are not ignored and will be committed in a reselect loop when the restart is enabled.

Restart able: - similar to select/Fetch but it WILL COMMIT inside the loop thus allowing the checkpoint to the PS_AERUNCONTROL table.