In this post I will attempt to explain how to dynamically assign a prompt table depending on a drop down value (see image below)
The table behind the grid is PORTAL_SECDYVW and as you can see from the image below, the PORTAL_AUTHNAME field has %EDITTABLE defined as a prompt table. The PORTAL_AUTHNAME is the "Name" column you see on the grid.
Now, we would want to assign table PSCLASSDEFN_SRC as prompt if the drop down value is Permission list and PSROLEDEFN_SRCH if the value is Role.
/*Record PeopleCode: PORTAL_SECDYVW.PORTAL_AUTHNAME.FieldChange*/ Evaluate PORTAL_SECDYVW.PORTAL_PERMTYPE2 When "P" DERIVED.EDITTABLE = "PSCLASSDEFN_SRC"; PORTAL_SECDYVW.DESCR = PSCLASSDEFN.CLASSDEFNDESC.Value; Break; When "R" DERIVED.EDITTABLE = "PSROLEDEFN_SRCH"; PORTAL_SECDYVW.DESCR = PSROLEDEFN.DESCR.Value; Break; When-Other End-Evaluate;
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Comments
Do remember to add the derived.edittable field on to the page. Otherwise you will get PeopleCode error.
Cheers
Nitin
Nice observation Nitin - Sorry forgot to mention that in my post. I actually have the derived.edittable field inside of the grid.
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Addition of Edittable field on to the levels can be done as per the Requirement.
Putting it on to level0 on the page will also work.
Nitin
Nice example.
Gud example...
Any help for Dynamic prompting .
My requirement like below:
user already enter the details of county and state and then while selecting the county value after state, the search page should be display the fallowing:
by example:
COUNTRY : USA
STATE : NJ
COUNTY Name [ edit box]
POSTAL CODE [ edit box]
[ Look uo ]
COUNTY NAME STATE POSTAL CODE
Please help me asap.
Thanks in advance
Can you make your requirement bit more clear. If you are asking about dynami prompting then it can be done using sqltext. I can help you more if you elaborate on your requirement.
regards,
JN
hi
will u please clearly explain me the ....
if i change the country field
the state filed need to be changed and
the two fields having promt tables...
how to do it.........
thanks in advance