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.

dynamic prompting in peoplesoft

5 replies [Last post]
nitin.kumarmv's picture
User offline. Last seen 10 years 51 weeks ago. Offline
Joined: 09/11/2008
Posts: 3

Hi,

I am trying out dynamic prompts....
have 2 fields Semester and Month....
My requirement-
if 1 is entered in the semester,then month to prompt to mon1_tbl,
if 2 is entered in the semester,then month to prompt to mon2_tbl,

have used %edittable in the record field properties for month field in the main table....
have created 2 views for the two prompts and used them in peoplecode, which has the if-else logic for table selection....

the error im getting....

---------------------------
GetField: Field 'DERIVED.EDITTABLE' not found in scroll level 0. (2,155) NIT_MON_COMP.GBL.NIT_MON_TBL.NIT_SEM.FieldChange PCPC:151 Statement:3

The specified field was not found in the indicated scroll level. This may occur with various PeopleCode built-in functions that specify a "scroll context" via a series of records and a field name.

Review the PeopleCode that is generating the message and the page definition and correct as appropriate.
---------------------------
OK
---------------------------

please help me in resolving this...
also came to kno that dynamic prompting can b done using SQLtext...
also tel me if u kno dis....

thanks in advance..
nitin

Lepa's picture
User offline. Last seen 48 weeks 1 hour ago. Offline
Joined: 06/23/2008
Posts: 591
Re: dynamic prompting in peoplesoft

Hi nitin.kumarmv and welcome to the site.

Regarding SQLtext, I'm assuming you've already looked at this post http://www.compshack.com/forum/peoplesoft/peoplesoft-technical/dynamic-v...

From your error, I would assume that your code is firing at the wrong PeopleCode event. At what event do you have your code at?

You can also work on your requirement in a different way. Instead of creating a semester table and month1, month2 ... for each semester, why not create semester table and then semester/month table?

For example, your semester_tbl will have two fields (semester, and semester description). Key field semester. Your semester_month table will have fields semester, month, and lets say desc. Key fields semester and month. Now, if you have a semester prompt field on the page where the prompt record is the semester_tbl and another month field with prompt table of semester_month you should get what you are looking for.

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

nitin.kumarmv's picture
User offline. Last seen 10 years 51 weeks ago. Offline
Joined: 09/11/2008
Posts: 3
Re: dynamic prompting in peoplesoft

Hi Lepa,

Thanks for the explaination.
I referred the same for SQLText...
My requirement is very simple.
------------------------------------
record | fields
----------------------------------
1. nit_month | sem
| month
-------------------------------------

2. montha | month
--------------------------------------
3. monthb | month
---------------------------------
a page contains 2 fields- sem and month...of nit_month record...
for value 1 in semester, the month field to be dynamically prompted to montha table....whch contains values jan, feb.....june.
for value 2 in semester field, the month field to be dynamically prompted to monthb table....whch contains values july to decembr.....

%edittable is the value in the record field properties of month field in nit_month record.

the peoplecode is written in the comp.record.rowinit(nit_month record) and comp.record.fieldchange(semester field).

also tried running by writing the same pplcode in the month fieldchange....
but not working....

Please let me know some ideas....

Nitin.

simrose's picture
User offline. Last seen 5 years 7 weeks ago. Offline
Joined: 08/01/2008
Posts: 33
Re: dynamic prompting in peoplesoft

Try to put the DERIVED.EDITTABLE(field where you have written the if-else code) on your page and make it invisible(page field property). I guess error is because of that it will work after that

Nitin's picture
User offline. Last seen 4 years 19 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: dynamic prompting in peoplesoft

Yes.. Simrose is correct.
You need to put Edittable field from Derived record on to page and error will go off.

Regards
Nitin

Ian C.'s picture
Ian C. (not verified)
Re: dynamic prompting in peoplesoft

You're right men!, I had the same problem and putting that derived field invisible on my page make it works. Thanks a lot!