Limit by parameters in BI Publisher

User_UMPYK · Mar 25, 2021 3:44PM

Organization Name

Dilytics

Hi,

We need limit by parameters in BI Publisher, and we have to get all the column values for the column if its not limited by any parameter.

This is an emergency fix as production is going on

Thanks

Hi,

We need limit by parameters in BI Publisher, and we have to get all the column values for the column if its not limited by any parameter.

This is an emergency fix as production is going on

Thanks

Original Idea Number: cee763df8c

Shyam Sundar Arunachalam · Mar 25, 2021 3:55PM

Hi Usha - whats the exact requirement? What would you like to achieve in the LOV?

Sahil Makhiza · Apr 13, 2021 4:16PM

Pretty much similar to that of making a parameter nonmandatory using the NVL function.

Use NVL in your list of value query and you should be good to go

Srinivas Pendyala-Oracle · Apr 14, 2021 4:00PM

Use full