Oracle Communities

Oracle Analytics and AI

Child Item

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!

Find more posts tagged with

Accepted answers

Chere-Oracle

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'?

All comments

Chere-Oracle

Please show a screenshot of the prompt's settings.

How are you filling in the prompt values, 111234 and 111234A?

RVohra

Appreciate if we can get more context - are you manually typing 111234;111234A and it is becoming 111234\;111234A?

Tony_OAS_Apex_User

Sorry for lack of explanation.

Yes. i am putting into the text box prompt and

111234;111234A and it is becoming 111234\;111234A

If I put one search item 111234, it works. ~

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/73547#Comment_73547

Hi @Tony_OAS_Apex_User,

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!

Tony_OAS_Apex_User

https://community.oracle.com/products/oracleanalytics/discussion/comment/73549#Comment_73549

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.

Chere-Oracle

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?

Tony_OAS_Apex_User

https://community.oracle.com/products/oracleanalytics/discussion/comment/73578#Comment_73578

Well, i have about more than 10k items so i rather put the option for user to enter some/ full string of data.

Chere-Oracle

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'?

Tony_OAS_Apex_User

https://community.oracle.com/products/oracleanalytics/discussion/comment/73632#Comment_73632

Thank you , I will try this.