Dear All,
I quick question please -
In a BO query I have 2 prompts, Can I run the query with one prompt filled with value from the list and other prompt empty?
It doesn’t allow me to run the query until I fill the values.
Is there any way out or?
Best Reagrds.
Thanks Anjan,
I was trying to migrate a report from Oracle builder to BO, trying to map it exactly same. I guess I will make it more simpler with BO.
I will use the list of values option.
Thanks for your quick reply.
Best Regards.
When most people want to leave a prompt empty, they really mean don’t put a condition on this field. Is that what you mean? This is often referred to as an “optional” prompt, and this FAQ topic will give you some ideas on how to handle it. It still requires the prompt to be filled in, but it effectively gets ignored in the SQL if a certain value is entered.