Hi,
I have never used the Shuttle item before and I'm trying to read up on it but the information I'm getting is scattered and not step-by-step as I'm looking for as a beginner.
What I want to do:
- Populate the Shuttle list with a SQL query (done, I know how to do this)
- Once the user makes the selections and clicks a "Go" button, I want a chart on the same page to be generated with the condition of only rows containing those values selected in the Shuttle item (I don't know how to do this).
How do I write the WHERE clause to include the values chosen in the Shuttle item (let's call it P34_SHUTTLE)? From what I understand in Oracle's help documents, the selections are stored in a colon-separated string but I don't know how to break them up as individual condition values in the WHERE clause.
Thank you!
Keegan