Reference qualifier for list collector

SNow35 · ‎05-18-2017

Hi All,

I have two variables in my record producer:

1. Customer(this is a reference field)

2.SOF(this is list collector)

I need to create a filter on the "SOF " field on the record producer form so that it only shows SOF records that are associated with the same Company that the record is for. So if the "Customer" field on the record producer form is set to "XYZ", then only SOF records where the "Company" field on the SOF record EQUALS "XYZ" should be displayed for the user to choose from.

Please let me know how I can achieve this.

Regards,

Shugufta.

Sharique Azim · ‎05-23-2017

Hi Shagufta,

Please use the updated code :

""

I advice to use an onChange client script which would set the filters to you. The list collector has to refer the right table for records. I had a catalog item where i have used this code,

I would request you to implement something similar(this is a catalog client script):

var collectorName = 'list_collector_field_name'; // the list collector field on the record producer

var filterString = 'group='+g_form.getValue(' field_name '); // from where the filter is dependent on the record producer

//Hide the list collector until we've set the filter

if(typeof(window[collectorName + 'g_filter']) == 'undefined'){

setTimeout(setCollectorFilter, 100); //Test if the g_filter property is defined on our list collector.

//If it hasn't rendered yet, wait 100ms and try again.

return;

}

window[collectorName + 'g_filter'].reset(); // this resets

window[collectorName + 'g_filter'].setQuery(filterString); //sets the filter

window[collectorName + 'acRequest'](null); //runs the filter automatically

once its populated it can fetched later in RITM and TASKs.

""

The default values of the list collector should not have no_filter , and as the client script does the task script include and calling script include can be excluded too.

Do reach back if you get struck.

Regards,

Shariq

View solution in original post

SNow35 · ‎05-23-2017

Hi Shishir,

I tried your script but it did not help. My requirement is to load the list collector after filling the reference field.

Harish KM · ‎05-23-2017

To refresh the list collector reference qual. You need to use a attribute

example: ref_qual_elements=reference_type_variable_name.

Then pass the reference qualifier

Regards
Harish

SNow35 · ‎05-23-2017

Hi Harish,

So the reference field is customer and list collector is SOF when the customer is selected the associated SOF should get populated in available slush bucket

Shishir Srivast · ‎05-23-2017

in this case also, Model List (List collector) filed values will get updated as per the value select in Model (Reference filed will be loaded) field, Please do not try my script as it is, you may need to do some modification per your requirement but logic will be same.

SNow35 · ‎05-23-2017

Hi Shishir,

I made the below modifications to the script include:

var GetListValue = Class.create();

GetListValue.prototype = {

initialize: function() {

},

getList : function()

{

var ids = [];

var gr = new GlideRecord('u_sales_order_form'); //this is my list collector reference table

gr.addQuery('u_customer', current.company.u_customer); //this is reference variable

gr.query();

while(gr.next())

{

ids.push(gr.sys_id.toString());

}

return 'sys_idIN' + ids;

},

type: 'GetListValue'

};