title: How to write the query for interactive grid based on the select list in Oracle Apex
body: <p>I have a drop down select list (<code>P2_ROLE</code>). I want to generate the interactive grid based on the value that I select from the drop down. </p>
  
  <p>I am trying to do that but the query is not returning any result in the grid. However, if I query it in the database, it returns me the result. </p>
  
  <p>It looks like that it is not substituting the value from the dropdown into the IG query. But If I hard code the value, it gives me the results.</p>
  
  <p><a href="https://i.stack.imgur.com/CbwhA.png" rel="nofollow noreferrer">dropdown_IG issue</a></p>
  
  <p>I also tried returning the value selected from the dropdown in the item : <code>P2_SELECT_LIST_VALUE</code> and then using it in the query. But it also doesn't work.</p>
  
  <p>The query that I have used for my Interactive grid is : </p>
  
  <pre><code>  Select USER_NAME
    From WF_USER_ROLES
    Where ROLE_NAME = :P2_SELECT_LIST_VALUE ;  --using the value from new item
  </code></pre>
  
  <p>or</p>
  
  <pre><code>  Select USER_NAME
    From WF_USER_ROLES
    Where ROLE_NAME = :P2_ROLE;  -- using the value directly from Dropdown
  </code></pre>
  
  <p>After selecting the value in the dropdown, I am refreshing the IG region using dynamic action on change select list. But that also doesn't help. How can I do that ?</p>