Dynamic Search Record PeopleSoft

Dynamic Search Record PeopleSoft

How to use peoplesoft dynamic view search record by peplecode.  You can use Dynamic View for prompt table.

Example Prompt table by dynamic view

1. Create Dynamic view contain field search key and other fields for show on search record
2. Set Prompt Table in record field properties  = Dynamic view

1. Use Rowinit Event peoplecode by condition your requirement

RECORD.EMPLID.SqlText = “select emplid from ps_person_name where empl_status = ‘A’ “;