Need to restrict few sites to select

[Kunal33]

We have a record producer named Access request where we have a variable named Find site which refer to u_cmdb_ci_site table. We need to restrict ABC MSSA responsibility that user not able to select site where responsibility is  ABC MSSA.

This filter we only need to user whose company is ABC

[Ankur Bawiskar]

@Kunal33 

you can use reference qualifier and restrict the data from that table

[Kunal33]

javascript:gs.getUser().isMemberOf('Cellnex_Project_Management')?'subcategory=Site^u_status!=Nominal^u_status!=In Acquisition^u_status!=Disposed^u_responsibility=Arqiva PMA'';

I tried with this but still i am able to see ABC MSSA sites

[Tai Vu]

Hi @Kunal33 

You're missing an else in your "Ternary operator". Let's try below adjustment.

gs.getUser().isMemberOf('Cellnex_Project_Management') ? 'subcategory=Site^u_status!=Nominal^u_status!=In Acquisition^u_status!=Disposed^u_responsibility=Arqiva PMA' : '';

[Kunal33]

Tried with this but still i am able to select ABC MSSA SITE

I have created a script include and called that script include in the variable. i think thats work