You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Issue using Dynamic Views..

1 reply [Last post]
mrav1072's picture
User offline. Last seen 7 years 16 weeks ago. Offline
Joined: 10/13/2011
Posts: 1

Hi,

I created a dynamic view as a prompt table (no edit) on a record. I am using the below rowinit peoplecode below to populate the dynamic view but I am continually seeing no values found when I click on the field prompt I am trying to populate. Can someone see anything I missed?

Thanks in advance for your assistance..
- Maria

RowInit Peoplecode:

Local string &SQLSTRING;
Local SQL &sqltext;

Function set_institution_prompt();
&SQLSTRING = "SELECT DESCR FROM PS_EXT_ORG_SRCH_UM A where COUNTRY = ";
&SQLSTRING = &SQLSTRING | "'" | UM_ADM_GRAD_PRV.UM_ADM_GRAD_CNTRY1 | "'";
UM_ADM_GRAD_PRV.UM_ADM_GRAD_PRV1.SqlText = &SQLSTRING;

** This code didn't work so I commented it out and am using the code above now**
rem GetRecord().GetField(Field.UM_ADM_GRAD_PRV1).SqlText = &SQLSTRING;

End-Function;

set_institution_prompt();

Guest's picture
Guest (not verified)
Re: Issue using Dynamic Views..

I hope you are writing this peoplecode on UM_ADM_GRAD_PRV.UM_ADM_GRAD_PRV1.rowinit.
The field for which you mentioned dynamic view as prompt table, is a key field or what ?.
Just observe the key relationship between Main Record fields and prompt table fields.

Please go through the link 'peoplesofthrms.blogspot.com/2009/02/dynamic-views-as-prompt-tables.html' for better understanding Dynamic View concept.

And see below my finding on Dynamic View and if you had solved let us know the solution.

Prompt tables are enabled to dynamically filter the rows at runtime. Your prompt table must have composite keys. The higher-level key(s) would build criteria matching on your prompt table. The last Key in the record field order is the field that is being returned to the panel field.
Let's say you have a field FIELD1 with a prompt to VIEW1. VIEW1 contains the keys VFIELD1, AND VFIELD2 (in this order). VFIELD2 is the value returned to FIELD1 when you select a row in the prompt table. VFIELD1 is matched to the same-named field that exists on your panel.
By matching, I mean a dynamically created WHERE condition VIEW1.VFIELD1 = value of VFIELD1 in panel. At runtime, PeopleSoft performs SELECT fieldlist FROM VIEW1 WHERE VIEW1.VFIELD1 = value of VFIELD1 in panel.
VFIELD1 in the panel could be a field of a Derived/Work record then you could set it's value in PeopleCode. It should be on the same level or on a level higher than FIELD1's level.