Need to show options which is restricted by query BR

[Kunal33]

Hi Team,

We have  a record producer where we have reference variable named ABC reference to CMDB site table(custom table). There is a before Query BR written on it which  hide records whose organisation is XYZ. 

I need to to show that record whose organisation is XYZ to only that record producer. 

Can anyone guide me is this possible ?

[AnveshKumar M]

@Kunal33 You can try this approach, create a Select Box field and populate the choices from client script. In the client script you can try using GlideAjax to a script include which returns the choice values. The script include calls the Scripted REST API which queries the table and returns the site values, because we differentiate the session if it is through REST API.

This is just an Idea, need to try whether it works or not.

[Kunal33]

Oks will try that

[AnveshKumar M]

@Kunal33 Let me know if it worked.