- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-18-2017 03:30 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-23-2017 03:50 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-23-2017 02:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-23-2017 02:31 AM
Hi Shishir,
Yes I am using the same reference qual in my list collector variable.
I am getting all the SOF instead of SOF associated to that customer.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-23-2017 02:38 AM
Also in your list collector field give the attribute ref_qual_elements=reference_type_variable_name.
Harish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-23-2017 02:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-23-2017 02:55 AM
Hi Shariq,
You are correct I am trying to do the similar thing but not sure how to modify the script you have specified.