Can I pass ID of the table instaed of value in dashboard prompts?
613142Apr 20 2009 — edited Apr 20 2009HI,
Say, I have a table QUESTION which contains 2 columns: ID, DESCRIPTION.
sample data:
ID DESCRIPTION
--------------------------------
1 TEST
2 TEST1
3 TEST11
4 TEST
Herer the DESCRIPTION is stored in the order they appear in a portal application
Please note that the value of ID 1 & 4 are lexically same
I now make DESCRIPTION column sorted on ID column in LOGICAL layer and use DESCRIPTION in my dashboard prompt, it will list :
TEST
TEST1
TEST11
TEST
but once I select any of the TEST value the results will be shown against both the TEST value, what I want is that if I choose the first TEST value I get the reults against it and when I choose the fourth TEST value I get the results against it only.
IS this feasible ? Can we pass ID instead of DESCRIPTION as filter ?
Any other ideas are welcome.
thanks
Rishabh