| Forms personalization: Restrict JE Category LOV [message #316521] |
Fri, 25 April 2008 08:51  |
roandgeo
Messages: 4
Registered: March 2008
|
Junior Member |
|
|
We are trying to restricted the values that an end user can select, in the Journal Category field, when they are manually entering a journal. We do not want to restrict them to only 1 value but a subset of the Category LOV. Can any anyone provide examples of ow to do this?
thanks
George
|
|
|
|
| Re: Forms personalization: Restrict JE Category LOV [message #317502 is a reply to message #316521] |
Thu, 01 May 2008 12:57  |
roandgeo
Messages: 4
Registered: March 2008
|
Junior Member |
|
|
Just for reference, here is the solution:
Just for everyones information, we were able to solve this issue in this manner:
Function Name: GLXJEENT_A
Form Name: GLXEENT
Level: Form
Condition
Trigger Event: WHEN-NEW-BLOCK INSTANCE
Trigger Object: Header
Condition: Null
Context: Site
Actions:
Seq: 1
Type: Builtin
Builtin Type: Create Record Group from Query
Argument: Select Je_Category_Name, User_Je_Category_Name, Description
From gl_je_categories
where user_je_category_name in ('a', 'b',...)
order by user_je_category_name
Group Name: XX Je Category (Can be any name)
Seq: 2
Type: Property
Object Type: LOV
Target Object: User_je_category_name
Property Name: Group Name
Value: XX Je Category (must match group name in seq 1)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
