title: Refresh Apex 5.0 chart results with different dynamic actions on same SQL query
body: <p>I have created a bar chart on APEX 5.0 where my query looks like below:</p>
  
  <pre><code>select col1 as label,col2 as value  from table1 where :P3_NEW_1 = col3;
  </code></pre>
  
  <p>here: <code>P3_NEW_1</code> the page item I have created of type "Select List".</p>
  
  <p>The list of values in "Select List" page item are pre-populated in the dropdown using the "Shared component" type I have created and so far this worked fine and I am able to display the results of above query by passing the value through the page item select list.</p>
  
  <p>Now I need to add 2 data pickers on the same Apex page such that I should now be able to filter the results using date picker through dynamic action.
  I know that using an additional button I can create a dynamic action but my problem is how do I modify the above query such that following should happen.</p>
  
  <ul>
  <li><p>During the page load, once I select a particular value from the "Select List", it should display records based on the value selected from dropdown </p></li>
  <li><p>This I already achieved using above sql query for the bar chart.</p></li>
  <li><p>Once  the bar char is displayed, I should next be able to filter and display the results using date ranges through date pickers.</p></li>
  </ul>
  
  <p>Here my problem is my bar chart query is same but I need to now pass the start_date and end_date to the same above sql query which  but I am not sure how to achieve this. If I add a button for dynamic action I need to select the report region which is the "bar chart" region and here my query needs modification.</p>
  
  <p>Once the bar chart display the results, at the next step how do I filter the results by having the date filters with dynamic action  on the same region where bar chart was displayed. How to achieve this?</p>