Tuesday 8 May 2007

How to use %RECNAME_EDIT as a Prompt Table

Sometimes in PeopleSoft you want to be able to vary the contents of a drop down list. For example you may want to only give the user the choice of selecting departments for a particular division.

You could do this by having a controlling field that is a high level key in the lookup table. PeopleSoft’s use of Set IDs utilises this method to restrict values based on their Set ID.

On occasion though, you may need to be able to dynamically change your values on the fly. For example you may have a radio button on a page that you use to control the values displayed in a drop down list. One way of doing this is to use %RECNAME_EDIT functionality.

In this technique you specify a field as the prompt then set its value in PeopleCode to the name of the table you want to use as your prompt table.

First off set the Prompt Table for the field you want to display values for to %fieldname where fieldname is the name of the field you are going to set in your PeopleCode. For example PeopleSoft often use %RECNAME_EDIT. RECNAME_EDIT is a field in the DERIVED table.

Second, add your edit field to the page or pages that contain your dropdown field making it display only and invisible. For example if you used a prompt of %RECNAME_EDIT you could add RECNAME from the DERIVED record to the page.

Finally add some PeopleCode to set the value of this field to the actual name of the prompt table.

e.g.

If (condition) Then
DERIVED.RECNAME_EDIT = "A_VIEW_VW";
Else
DERIVED.RECNAME_EDIT = "B_VIEW_VW";
End-If;


This can be done in Page PeopleCode, Component PeopleCode or FieldChange PeopleCode on a controlling field.

Thanks to Kevin Gavaghan for giving me a heads up on this technique a while back.

17 comments:

Aartrika said...

Thhanks for the post.
I would request you to please visit t0 below site and give your valuable suggestion.

PeopleSoftNet

Thnaks in Advance.

Unknown said...

I'm trying to do this, but am having issues with what to put in the Drop-Down List Box Properties. No table is showing up in Prompt Table Field and I expected to see DERIVED there. Since no Prompt Table Field is set, I get an invalid page error when I try to save it.

free sister brother fuck stories said...

Spending all those extra hours at work. One.
free taboo stories with pictures
sex stories rape
kristen incest stories
free hardcore teen sex stories
gay xxx stories
Spending all those extra hours at work. One.

xnxx harry potter sex stories said...

``Hes standing right next to me. She tries to get up but with the heels onshe cant walk very good.
free young incest stories
erotic stories young free
extreme animal sex stories
sexy student teacher stories
women having animal sex stories
``Hes standing right next to me. She tries to get up but with the heels onshe cant walk very good.

Anonymous said...

Hi, this weekend is pleasant in support of me, since this
moment i am reading this fantastic informative piece of writing here at my residence.


See this: zobacz, http:
//abatement.warszawa.pl

Anonymous said...

Wow, that's what I was seeking for, what a information! present here at this weblog, thanks admin of this website.

Look into my weblog - ミュウミュウ長財布

Anonymous said...

You have made some good points there. I checked on the web
for more info about the issue and found most individuals will go along with your views on this
website.

My site 財布トリーバーチ

Anonymous said...

Its not my first time to go to see this website,
i am browsing this site dailly and get fastidious data from here all the time.


my page: aspaciousplace.com

Anonymous said...

They can be worn with jean material or bohemian
dresses. Probably the most important part lies in pickling and getting brownish naturally
stages of later. But most popular form is just about the diamond engagement wedding ring.
They make increasing than the most popular boots you will see around location.

http://westport.me/charlagra/all

Anonymous said...

His son Maurizio Gucci inherited his fifty% share
of the Gucci company. The size with the Hermes bags
are usually modified. All-in-all, a wonderful event with respect to a great cause.

Increasing belongings are women bags always be a necessary collection for women.
https://xserve1.leeds.ac.uk/groups/illuminameetingof5thoctober2011/wiki/93c11/Prada_Under_The_Financial_Crisis_Recession_In_The_Year_Just_Gone.

html

Anonymous said...

And soles usually are too thick can feel rigid, and causes it to be difficult to
walk. Get ready for fall and winter in style certain
year with Uggs. Retailers selling dog and other person fur as ake fur?
helped bring in such a law. They could be worn with jeans or bohemian skirts.
http://www.aedear.com/blogs/post/22468

My homepage; burtown snowboard boots

Anonymous said...

Also are they cozy, but very comfortable, too.

accoon?or oyote?were found to be able to made using wolf, even domestic doggy fur.

And possibly that ugg boots.are attractive and odd, young women still resist this way in
Ugg boots. The hunter boots are made to assist you to be worn up, slouched down as well as cuffed.
http://www.splatterit.com/index.php?do=/blog/19662/what-your-ugg-system/

Anonymous said...

The boots are fun and attractive and they actually oh-so-comfy.
It typically is extra work truthfully the results perhaps
may be worth it. Its every design and development is meant for fulfill diverse requirements for you.
Schuman doesn’t just concentration on the young, beautiful
and distinctive fashionable either. http://www.

strategic-workplace-solutions.com/author/JeffI47

Look into my page: discount ugg boots

Anonymous said...

Many brands of trustworthy handbags have successive number.
Finally, you have obtained your Gucci In Bag, the really design
ever contemplate! It was need an absurd canine friend version of
these myth of Sisyphus. Across short, if you have come in Gucci store, you would not be let down.
http://acbotosani.com/index.php?option=com_phocaguestbook&view=phocaguestbook&id=1&Itemid=9

Anonymous said...

It is card folded in three or more panels, with the type of trademark of Prada located at the leading page.
The bags range in about $830 so that it will $3700.
I can't imagine how open and as well as cheap it is always and they been doing this for good." a customer said. May there anything quite as wonderful such as the summer months'
time? http://waakpon.com/profile/aaronhyde

My homepage: counterfeit gucci

Anonymous said...

Few fashion key facts apply when you are considering Ugg Boots.
Leggings in the perfect chocolate brown are a great
residence in the tummy for spring. Retailers selling dog and other creature fur as ake fur?
helped bring to sort it out law. Indeed, the new Jimmy Choo
Uggs won''t come cheap. http://www.jewx.com/profile.
php?ID=MildredMc

Review my homepage: ugg boots classic

Anonymous said...

electronic cigarettes, smokeless cigarettes, e cigarette, electronic cigarette brands, e cigarette, electronic cigarette