BIP Default Null to Select All Parameter

Question

Content

Is there a way to default the value in a LOV to null/blank when you have the option to "select all" in the LOV. Currently, the "All" is defaulted even when I change the order of the SQL statement in the LOV menu, the Parameter "Default Value" column (I know for Sysdate, the syntax is {$sysdate()$} so if there is anything like this) or the report parameter menu. I have not found a way to default null even when I union it in my SQL statement. If anyone knows of a way other than unselecting the "All" ability and moving each selection over in the search UI.

Thanks.

Code Snippet

select ' ' as segment1 from dual

union

select segment1 from gl_code_combinations

order by 1

FPonte · Answer

Hi Ari.

On the definition of your parameter in the report set the Option to ALL Values selection to pass NULL.

Is the default behavior once you select the MENU option for your parameter (see image)

No need to create the Union on the query.

Hope this helps.

Fernando