How to pass "AllColumnValues" into direct db request using presentation variable?

2964744

Hi Guru,

How to pass "AllColumnValues" into direct db request using presentation variable?

i've tried below approach but still it's not unable to password "All Column values"

1. select * from Table_name where table_column in ('@{PV_Var1}{SINGAPORE}')

2. select * from Table_name where table_column in ('@{PV_Var1}['@']{COM}')

3. select * from Table_name where table_column in ('@{(!CATE||CATE.isAllColumnValues?NULL:CATE}[@]{PV_Var1})')

i have tried below url method (syntax not working)

https://bianandmoharikar.wordpress.com/obiee11g-direct-database-request-multiselect/

If you have any idea or fix. please help me on this. Thanks

Regards,

Deva