Peoplesoft Dynamic View - With Bind Parameters


How to pass custom Bind parameters in the dynamic sql statements used as prompt table.
Dynamic views and Bind parameters.

When Dynamic is created in the View SQL we can usually place the standard system variables
%Operator ID as Bind parameter. If you want to change view sql like where clause condition or add custom bind values without changing the select fields you can do the following.

Create dynamic record with default view sql statement in it assign it a the prompt table for the field.
In the rowlnit poeplecode event of the RECORD.FIELD add the following peoplecode.

RECORD.FIELD.SqlText = “Select A,B,C From table where A = ” || &Variable ;
When the prompt table look up is performed the latest SQL assigned above will be used.

 

0 comments: