I have created a dynamic view (to be used as a prompt) in our PeopleSoft Version 9 environment to pull back values based on what is getting returned from a business interlink. Since our Version 9 environment is not available yet, we need to apply something similar to our PeopleSoft Version 8 environment. When I tried to apply this same logic, it is saying that the SQLText is not a valid property of the field class. I was just wondering if there is something equivalent to this SQLText property in Version 8 or how I should go about doing something similar.

PeopleCode from Version 9:

Can you tell me the best practice for this scenario? We want to provide a menu item, that when the user chooses it, will provide job information. The user will enter various prompts such as selected business units, deptids, empl_status, and so on. The result should be similar to query results on the screen, with an option to download.

hi,
thank you for your example. Help me a lot, but my case is a little bit different.
I need to get the security row level base on the login user so I am using a dinamic view with the following code

SELECT rowsecclass
, oprid
FROM (
SELECT rowsecclass
, oprid
FROM SYSADM.psoprdefn )
WHERE %oprclause

With the RowsecClass I need to get the groups and display them in the LookPrompt so I am using a second dynamic view

SELECT group_id
FROM PS_TL_GRP_SECURITY
WHERE rowsecclass in (
SELECT rowsecclass
FROM p_row_sec_vw) <-- CALLING FIRST DINAMIC VIEW