User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
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.
Passing values from level0 to level1 using dynamic view
Mon, 12/14/2009 - 8:25am
can anybody explain that. how to pass values from level0 prompt to level 1 Grid using dynamic view in a page
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| how to create application status in peoplesoft campus solutions 8.9 version | PeopleSoft Functional | 05/17/2012 - 4:09am |
| horizantal text in charts | PeopleSoft Technical | 05/10/2012 - 4:57am |
| no current buffer context error | PeopleSoft Technical | 05/10/2012 - 1:19am |
| Integration Broker : Operating Instance/Pub Contracts/Sub Contracts | PeopleSoft Technical | 04/24/2012 - 11:05am |
Can u be alittle more specific about ypur requirement?
Yes you easily can. You are not very clear but still what i got from the information supplied the prompt is the dynamic view. If i am right, then u can create the dynamic view based on your prompt field(fieldlev0) and give it as the prompt of the field(fieldlev0). And then write
fieldlev0.sqltext=expandsqlbinds("ur sql fr prompt req with binds :1, :2,...",value1,value2...);
whereever required.(ie. fieldchange, prebuild...)
and then (if req on fieldchange of fieldlev0) u can write
&row= getlevel0()(1).getrowset(scroll.level1record)(1);
&row.level1record.field1.value=fieldlev0.value;
&row.level1record.field2.value=getfield(level0record.fieldlev0).getrelated(level1record.field2);
thn u can use sqlexec to fill in other values. Hope that was of some use.
getfield(level0record.fieldlev0).getrelated(level1record.field2);
level0record.fieldlev0 : can be from record as u need.
Post new comment