NVL2 BR Function Parameter - Example?

Thank you Sanjaya!

Hi Disna, 

Can I ask you which operator (IN, = or LIKE)  do you use in advanced filters with this standard and functional parametrs? 

Thank you  

Martin Gestinger

Hi Martin,

 According to Sanjaya and the referenced documentation, we do not need to use NVL2 function to satisfy my requirement to some extent. Only thing is we need to enter ‘ALL’ as the parameter value but not leave it as blank which I wanted.

I just created a standard parameter &CodeB (Single value) and used LIKE operator to use wildcards , but if not you can use just = operator in the filter.

But make sure this BR System parameter (Enables the All parameter value functionality)  should be set to TRUE as in the screen shot.
 

let me know if this is clear.

Disna.

Hi Disna, 

Thank you for your comment. Your approach looks nice and elegant. But I see now you are in APP 10 and I try to recreate something similar in IFS Cloud 21R1 and there is no window for BR System parameter where is ALL define and could be used in BR. But using % in functional parameter with NVL solve this as well. 

Thank you for your added details. 

Martin