Want to display list collector based on company

[Ash41]

Hi Team, 

I have  2 variables requested for(reference) and services(list collector). I want to match user company from requested for with Services table we have field with list collector companies. If any service contains requested for user company, it should show under services(list collector). Trying with script include and reference qualifier. please suggest.

[Sandeep Rajput]

@Ash41 In your reference qualifier

javascript: 'company='+current.requested_for.company;

Here I have assumed that you have a company field on the Services table which you are referring on the list collector field.

[Ash41]

Actually we had this it works fine, but we have another condition as well to combine upon this. 

Service table we have company groups which contains companies as well we need to match that as well.

[Sandeep Rajput]

For that you will have to create a script include and based on the query return the sys_ids of the companies.

In the reference qualifier you can write.

javascript&colon; 'sys_idIN'+ new <name of your script include>.<method name in script include>();

[Ash41]

I need a script include for users company based services to popluate