I have a numeric filter of OBS unit. When we do not select any value in this filter, what is the value sent to the query? is it zero?
Not zero ; no value will be sent to the query (i.e. null)
So if the field in your query is a user-parameter then you can code for it ( nvl / isnull / @NVL@ / IS NULL), but if the field is just a returned column them it will just not be "used" in the query logic.
Hi Kajal.Rane - Did Dave_3.0's response help answer your question? If so please mark as Correct Answer. Thanks!
Retrieving data ...