CODEWITHSUNDEEP
oracle-apexoracle-apex-5.1
Coding Duchess
Coding Duchess

Reputation: 6919

Oracle APEX - set select list selected value based on page item

I have a select list on a page and its source set to a sql query:

SELECT t.name d,t.id   r
FROM   Table1 t
WHERE  t.status = 'New'
AND( t.id = TO_NUMBER(:P3_MY_ID)
OR :P3_MY_ID IS NULL)
ORDER BY 1

And I see mt P3_MY_ID set in session but the value in my select list is not selected. Can anyone help?

The value of P3_MY_ID is getting set in pre-render before regions

Upvotes: 1

Views: 8696

Answers (2)

mohamad subhi bouchi
mohamad subhi bouchi

Reputation: 190

to set the value of a select list you need to create a dynamic action set the event to when change>selection type page item> your item P3_MY_ID. set the true action to set value> set type sql statment> your query> affected element> type item> your select list

Upvotes: 1

Littlefoot
Littlefoot

Reputation: 143103

List of Values properties group contains the Cascading LOV Parent Item(s) - put P3_MY_ID in there.

Also, make sure that query you wrote actually returns something (using the P3_MY_ID value you use in Apex) when executed in SQL*Plus, SQL Developer, TOAD or whichever tool you use.

Upvotes: 2

Related Questions