Skip to Main Content

APEX

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Generating SELECT criteria from list menu

670835Nov 17 2008 — edited Nov 18 2008
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2008
Added on Nov 17 2008
8 comments
318 views