- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-28-2015 03:53 AM
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-07-2015 02:20 AM
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';

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-28-2015 03:59 AM
HI Emma,
You may find the below thread helpful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-28-2015 04:03 AM
Hi, thanks for your reply. Could I use 'g_form.removeOption(<fieldName>, <choiceValue>);' in the reference qualifier to remove options?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-28-2015 04:07 AM
Hi Emma,
I agree with Julian. You can do the calculation at the script include which is called through reference qualifier and restrict the options.
To answer your first question, You can use removeoption at the server side i.e script include.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-28-2015 04:00 AM
Depending on what you are looking to filter and how easy that is to write.
Modify the reference qualifier, or if that is not feasible as you need to perform queries etc, or the qualifier is too long (and you do not want to increase the size) then I would look at calling a Script Include and let it do the calculation and return the modified reference qualifier