Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Use of application Item with conditional validation

AmelieMar 3 2011 — edited Apr 18 2012
Apex 3.2

On a form, I have two lists :
- Items TYPE contains A B C and D.
- Item MANAGEMENT contains NULL, 1, 2 and 3.

I want to validate that MANAGEMENT is not null only when the value in TYPE are A, B or C.

I am using the condition "Value of Item in Expression 1 Is Contained within Colon Delimited List in Expression 2"

I dont want to hard code these values (A B C) so I put them in an Application Item (I also need them somewhere else).

If I use my application Item in the condition, the validation is not performed (I dont see it listed in debug mode.). If I use the real values (A B C), its working.

Here's what I put in the Exp2 when using the application item :
F126_CONST_BUSINESS_CASE:F126_CONST_PROJ_NON_PLANIFIE:F126_CONST_PROJ_PLANIFIE

I also tried with the form v('F126_CONST_BUSINESS_CASE'): ...

Any Idea ?
Thanks in advance.
This post has been answered by Arie Geller on Mar 4 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 16 2012
Added on Mar 3 2011
4 comments
1,612 views