cancel
Showing results for 
Search instead for 
Did you mean: 

BO Universe Design Layer (UDT) Prompt

0 Kudos

Hi All,

I have a requirement on division (character) filed to have a prompt select * for all the divisions or individual values.

Here are the steps i followed:

1. Created a prompt with below info.

@Select(class\Division) IN @Prompt('1.Enter * for all Divisions','A','class\Division,Multi,free) OR

('*' IN @Prompt('1.Enter * for all Divisions:','A',class\Division',Multi,free))

2. I created a LOV list to add *

Tools --> Edit Lov list --> Division --> Edit values --> SQL --> i have added UNION '*' from DUAL Order by 1

Selected the checkbox to generate SQL before execution

3. Exported the universe after save

Issue:

I am getting the Division prompt 2 times when i run the report for execution (these Universe prompts are not OPTIONAL).

Is there any issue with my approach? Or i missed any steps?

Please let me know.

Thanks

Vinay

denis_konovalov
Active Contributor
0 Kudos

fixed your tags to match your issue description.

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Can i make this prompt as Optional , as i am using UDT

0 Kudos

Thank you Daniele, the other procedure to accept * for all values is correct approach. I will fix this from my end.

daniele_tiles2
Active Participant
0 Kudos

You are welcome, please mark the question as answered :).

Best regards


Daniele

daniele_tiles2
Active Participant
0 Kudos

The text of the prompt isn't exactly the same: in one you've got ":", in the other you don't.

HTH

Daniele

mgrackin
Contributor

Yes, Daniele spotted the issue. The Prompt Text has to be EXACTLY THE SAME in both @PROMPTS.