Limit by parameters in BI Publisher

User_UMPYK

Organization Name

Dilytics

Description

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

Use Case and Business Need

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

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

Sahil Makhiza

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

Use full