Reference qualifier for list collector

[SNow35]

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.

[sarahyelton]

Hi Shariq,

I tried your code for a record producer I have where I want a reference field (select_cost_center) to filter a list collector (u_business_application).  select_cost_center is only a variable and not passing a value to the produced record.  u_business_application does; I'm not sure if this is the problem.

I want the filter to display "Bundled for Cost Centers" contains (value selected in select_cost_center variable).  The field name is u_bundled_for_cost_centers and is also a list field on the cmdb_ci_business_app table.  u_bundled_for_cost_centers and select_cost_center both reference the cmn_cost_center table.

Please have a look and let me know what I am doing wrong.

function onChange(control, oldValue, newValue, isLoading) {

    if (isLoading || newValue == '') {

          return;

    }

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

    var filterString = 'u_bundled_for_cost_centers='+g_form.getValue(‘select_cost_center’); // 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

    //Type appropriate comment here, and begin script below

}

[shrija10]

Hi Sharique,

I tried this code and its working in my case, but I need to hide the list collector if it is empty. If there is some value in list collector to show as per the condition then only list collector should be available on form or else it should be hidden on form. Can you plz help me with this.

I am using this code in one of my catalog item.

[Sharique Azim]

Hi Shrija,

Based upon which block (available/selected) would you like to consider the empty list conditon?

[shrija10]

Based on Available I would like to consider empty . If based on condition available side of list collector comes empty then list collector should not be visible on form and if available has some value to select then list collector should be visible on form.

[Sharique Azim]

Hi,()

I would just modify my existing logic provided earlier.

In the   client   script after my script ends

var str= filterString.indexOf('=');

if (filterString.substring(str+1,str+2)== ''){ //check if the value after = to sign is empty

g_form.setMandatory('list_collector_field_name',false); // if the field is mandatory for some reasons

g_form.setVisible('list_collector_field_name',false);

}

But this should had been another question