Reference Qualifier based on another field Record producer

[Brian Lancaster]

I have a requirement to only show locations based on the affected users company.  How can I achieve this?  I have a location filed and an affected user filed.  Location is a reference to cmn_location and affected user is a reference to sys_user.

[allison_holt]

With the assumption that the location has the company tied to it, you can add the follow ref qual on the variable:

javascript:'u_companyCONTAINS' + current.variables.u_affected_user.company

where u_company is whatever field is the company field on your location table.

[Michael Ritchie · Accepted solution]

BTW, Location has a company reference out of the box so something similar should work:

javascript:'companyCONTAINS' + current.variables.u_affected_user.company

[Brian Lancaster]

wow I was over analyzing this in my head.  Much simpler that I thought it would be.