Generating SELECT criteria from list menu
670835Nov 17 2008 — edited Nov 18 2008Hi All,
I have a list menu (multi select) component (:P9_KPIs) which contains a list of column names in a table. The user can then select one, or more, values in this list.
After clicking 'GO' I then need a graph to update to show data in the selected column(s). For example:
SELECT :P9_KPI from my_table where DATETIME > (sysdate - 20)
I have two questions:
1) Is this possible and if so, how do I do it,
2) How do I handle multiple selections in the table.
Many thanks,
Colin.