This content has been marked as final. Show 3 replies
When you construct a select list, one of the examples right there -- below the field "Source: List of Values Query" -- is a "Dynamic List of Values":
In your case, I believe you'd want
IF :MY_ITEM='10' THEN RETURN 'SELECT ename, empno FROM emp WHERE depno = 10 ORDER BY 1'; ELSE RETURN 'SELECT ename, empno FROM emp WHERE depno = :my_item ORDER BY 1'; END IF;
IF (all by field are null) THEN
So I created a dynamic list of values and it does work, but it requires me to save the record and then when I go back in it populates the select list properly, but I guess I am not sure how to turn this into a dynamic action where the values of the select list change while they are on the page rather than having to save it.
My Dynamic select list is created with the following code:
Having trouble turning it into a dynamic action. Any assistance would be appreciated.
IF :P104_ENGINEERCLASSIFICATION IS NULL AND :P104_ENGINEERROOTCAUSE IS NULL AND :P104_ESCALATIONTIMETAKEN IS NULL THEN RETURN 'SELECT LOVNAME, LOVVALUE FROM ESCALATION_LOV WHERE Display = 1'; ELSE RETURN 'SELECT LOVNAME, LOVVALUE FROM ESCALATION_LOV';