- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-20-2014 01:36 AM
Hi All,
I am fetching values from a table into slush bucket. But now i want to fetch only some specific values so that some particular values can be shown to the users. I know the check but don't know how to apply it and where to apply it. Please suggest me on this.
Thanks in Advance!!
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-20-2014 01:40 AM
reference qualifier of the slushbucket.... write a script if the condition is complex ....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-20-2014 01:56 AM
Hi Atul,
Another option (if you have another requirements like "the users could undo the filter") could be :
And I use as well the following one to "select" automatically some records in the collection
http://www.servicenowguru.com/scripting/client-scripts-scripting/move-list-collector-options/
Regards,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-20-2014 04:10 AM
i think i jumped the gun here.. reference qual only works for reference variable ... i guess i am getting old ... for List collectors we usually do it in onload script ...
these links will help you
https://community.servicenow.com/thread/162826
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-20-2014 04:15 AM
function to reset the filter will look like this ...
function setCIFilter() {
var query = "somefilter";
cig_filter.reset();
cig_filter.setQuery(query);
ciacRequest(null);
}
here ci is my list collector variable name.. replace it accordingly.....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-01-2015 11:36 AM
Hi Kalai,
I have two list collectors on Catalog form and both are referencing same table lookup(Example). So I have created onchange catalog script. I am trying to add query for both fields. But in form i can see that query is effecting on one variable. In other variable i can see all records from the table. Please check the below script.
if(newValue == 'call_data') {
queueg_filter.reset();
queueg_filter.setQuery('u_field_name=Queue(s)');
queueacRequest(null);
siteg_filter.reset();
siteg_filter.setQuery('u_field_name=Site(s)');
siteacRequest(null);
}
here I can get the values for send variable and for 1st one i am getting all the records. (Example i keep the site's script in lower to queue, site is working fine and queue is not working. If i keept queue script lower to site, queue is working and sites is not working.) Please look into this.
Thanks a lost in advance.
Swamy.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-01-2015 11:19 PM
Should work theoretically .. Checked the console for errors?