Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence Foundation
Business Intelligence Standard Edition One
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: May 21, 2013 8:50 AM by
Filtering of values from a specific field
May 21, 2013 6:46 AM
We have a requirement where a column called "Role" will have a both numberic and character values in it.
Ex: 01 , 02 , .99 , .98 , 101 , PRM , PRS , EOS , PMS etc.
Now the user doesnt want any of these numeric values to appear in prompts where user wants to select the values while running it in a dashboard.
How can i restrict numeric values appearing for the user , so that they can only be able to see these characters instead of numeric values?
Please help me on this as this is a bit critical requirement for us to deliver.
Thanks a lot for your time on this in advance.
This content has been marked as final.
Show 1 reply
Re: Filtering of values from a specific field
May 21, 2013 8:50 AM
in response to
Within the dashboard prompt, set the SQL statement to be something like the following...
SELECT *<your role column>* FROM *<your subject area>*
WHERE *<your role column>* BETWEEN 'A' and 'Z'