Restrict LOV to return values to specific table

[Former Member]

Hello,

I have a requirement in universe where I have to restrict the LOVs to certain tables.

I have a field "Contact" from contact_table" in the universe. This field I am using in webi report prompt and it shows so many list of values.

There is a field "Contact_ID" in another table "Sample"table in the universe. How do I restrict the contact object to return lovs in relation with possible values of Contact_ID in Sample Table?

Thanks,

Nisha

[Former Member]

Hi Nisha,

Does contact_table has Contact_id column? If yes, then simply join this table with Sample table using contact_id.

Then you will get contacts which have matching contact_ids only.

Regards,

Yuvraj

[Former Member]

In universe designer -In object properties option , GO to LOV - you have the Edit option there , you can change the LOV condition

Hope this helps.