If I understand correctly, you want a page item that is a select list and an interactive report that depends
on the value of the select list.
Create a page item of type select list with submit (P5000_INDID)
select ind||' - '||industry display_value, indid return_value
Then create a interactive report with a where clause containing
where indid = :P5000_INDID
workspace : LUADEMO
username : demo
password : demo
the idea :
- if you select a city, P2_CITY value change and the Output should be refresh to display only people in
the selected city .
and then if it s working
i would like to replace the action on the pencil, to do the same, depending on the city of the row where i click the pencil.
if it s working with the click on the pencil, would it be possible to trigger it just when the row get the focus
and if you have still energy to answer me
i put this on the footer
alert('region ID: ' + '#REGION_STATIC_ID#');
alert('region ID: ' + $('#apexir_REGION_ID').attr("value"));
and i don't understand why the #REGION_STATIC_ID# substitution is not working .
ok , i finally found everything i needed,
you can test it on :
the content of the Output region is now the result of an application process, depending on one parameter.
and you can also see that i can now select a row , and show it by changing the color of the row , then update the output.
and when a row is selected, it reset the selection on the selectList with avoiding the triggering of the event on the select list .