Caller field reference qualifier dependent on Company OR MyCompany

[ralphalberti]

I have a simple reference qualifier setup for the Caller field which is dependent on the Company field. Works fine.

My issue is that I need the reference qualifier to allow Users from the value in the Company field OR my own Company which is called Novitex.

Can I create this OR using the Condition Builder or do I need javascript? I'm not really a coder but can usually get by with some examples.

The Dependent field is Company.

[ralphalberti]

I'm almost there... I think I need one variation on that addOrCondition to complete the script.

Would there be a way I could limit Users from MyCompany by adding an And condition to the qc variable?

For example, I don't want to return all 9,000 Users from my company. I only want to return those Users who work in a certain area called MPS. How would I include Users if MPS is True?

Sorry to be such a pain.

[Michael Fry1]

No worries, but you might have to adjust as I'm not sure what the field name is for 'Area" on the User table. Basically you need to add something like this after line 5 or 6:

comp.addQuery('u_area, 'MPS');   - where u_area is the name of the field, and MPS is the area.

[ralphalberti]

What if it was a true/false field? Would I add something like;

comp.addQuery('u_mps', 'TRUE');

[Michael Fry1]

Yes - but like this:

comp.addQuery('u_mps', true);