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
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.