does UPPER(TABLENAME.Subject) LIKE (:Subject) work when you do it in SQL dev (nope it doesn't ...) you are missing basic SQL syntax
try UPPER(TABLENAME.Subject) LIKE UPPER('%' || :Subject || '%') <- contains search
try UPPER(trim(TABLENAME.Subject)) LIKE UPPER(:Subject || '%') <- begins-with search
try UPPER(trim(TABLENAME.Subject)) LIKE UPPER('%' || :Subject) <- ends-with search
Thank you for your help earlier this week.
I have another question ; In the BIP Data Model I have couple of parameters. let say Parameter A ,B and C. Parameter B and C is Date From and Date To.
I would like to enable/disable Parameter B and C, depending upon the LOV in parameter A. so that I can give the date range in parameter B and C.
How do I do that?
Please let me know. Thank you in advance.
There is an option in the parameters to refresh others based on the parameter ... have you tried that?
Yeah but it does not work. Do you have any sample?
If I select "All Closed" from dropdown I want to populate Dates field from SQL LOV. but if I select other than "All Closed" from dropdown , I want to disable the dates fields. I am doing this from Data Model from SQL generated, it is not analysis.
I appreciate your help.
Thank you in advance
why did you replace your original question with this new one? now people don't have a correct answer tied to the original question. This is a forum - searchable for help.
You need to make a new post for a new question.
You can't disable them as you describe ... you can however in your query choose to ignore the dates if a user picks some based on the Open/Closed
my mistake. I will do from next time.