Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 40 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 18 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OAS analytics dashboard textbox passes multiple filter items with ; ending it up with \;
I am trying two filter items in the dashboard, but prompt filter shows 111234\;111234A
I need to get rid of \ to get the filter working properly. only ';' passes with '\' if I use ',' it shows as is. But for the OAS analytics needs ';' between two filter items. Any idea i can pass the multiple filter items?
Thanks!
Best Answer
-
Hi Tony_OAL_Apex_User,
Yes, but why did you make the text box prompt as a Presentation Variable? Why not create a normal column prompt for a prompted filter, changing the prompt's User Input setting to 'Text Field'?
2
Answers
-
Please show a screenshot of the prompt's settings.
How are you filling in the prompt values, 111234 and 111234A?
0 -
Appreciate if we can get more context - are you manually typing 111234;111234A and it is becoming 111234\;111234A?
0 -
Sorry for lack of explanation.
Yes. i am putting into the text box prompt and111234;111234A and it is becoming 111234\;111234A
If I put one search item 111234, it works. ~
0 -
Not able to replicate the issue here.
Quick Question: Where are you seeing this transformation? within prompt or report code?
Can you please check if there's any code behind the text box for prompt or the report filter? Also in case you are copying the data from any other areas and pasting in the prompt, please type it in to make sure there's no hidden character coming while copy pasting the data.
Thank you!
0 -
from Dashboard prompt, i put the prompt filter items to textbox that passes to Analysis so if I check the filter, it has '/' . something got added in the middle of transfer process.
I made the text box as Presentation Variable and I used operator's contains / is or equal to back and forth... and getting the same result.0 -
Hi Tony_OAS_Apex_User,
Why did you make the text box as Presentation Variable? I presume it is a column prompt, rather than a variable prompt. Will its column formula not work with a prompted filter's column formula?
1 -
Well, i have about more than 10k items so i rather put the option for user to enter some/ full string of data.
0 -
Thank you , I will try this.
1
