Skip to Content

BO Universe Design Layer (UDT) Prompt

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on May 14 at 01:00 PM

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

    HTH

    Daniele

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 14 at 01:11 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 14 at 02:33 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.