Lookup select box variables - remove items from list

[ebaileyybs]

Hi,

I have created a lookup select box variable and I need to remove some of the options from the list. How do I remove certain options from a lookup select box variable?

Thanks in anticipation!

[ebaileyybs]

Hi thanks for your reply. What script would I need to use in the ref qual to remove certain options?

[poyntzj]

Not really an easy one to reply to.

It depends on what you need to remove and why

I have some where the qualifier is too short so the SI returns a LONG value to return information and others that return very specific.

so for a CI on a change we have an SI that simply returns the long reference qualifier to return the relevant CI options

For assigned to, it takes into consideration who you are, the assignment group, are you a manager, co manager, assigner or member and based on that, returns a reference qualifier that will return a list of users who you can assign to (may even be blank)

First you need to work out what you would need to remove, why and how you would do it.

You can pass any information from the form, or about the user to the SI and make it work for you via queries and code

[ebaileyybs · Accepted solution]

I used the below method to remove the options from the 'Lookup Select Box' variable.

Reference Qual: name=hr_case^element=u_sub_category^value!=0^ORvalue=NULL^value!=1^ORvalue=NULL

I copied the reference qualifier from the list view of the choices, using 'copy query';