Reference qualifier applying on reports

[Dubz]

Hi All,

On my Problem form I have a simple reference qualifier operating on a field referencing the company table. When i'm running reports on the Problem table, if i want to add a condition based on this field the reference qualifier is ignored and i'm given all records from the companies table rather than the subset defined by the reference qualifier.

Is there a way to make the fields on reports take account of the reference qualifiers that have been set on them on the table?

[HarshTimes]

Hi David

You can write a before query business rule on the referenced table. This should work fine. Be careful while using the before query business rule.Make sure it is running only for your scenario

[Dubz]

Hi Harsh,

So i would need to write a rule saying, when the table is accessed through this specific field only show this information? This issue exists for all fields using reference qualifiers, it seems a bit long winded to replace some simple reference qualifiers with business rules covering every eventuality where a reference to a table is qualified. I was hoping there would be a simpler solution, it seems to me the fields on report should replicate the behaviour they are configured with on the form. If there's no simple way to rectify this perhaps i'll just submit it as a feature request.

[HarshTimes · Accepted solution]

Yes, this is the servicenow behavior. The reference qualifiers doesn't applies on the report. Actually this is a global behavior and it is not feasible to set the before query for all. If there is one or two case then it can be managed with script. I will not recommend to write script for your case.

Regards

Harsh

[ashwryadj]

Hi @HarshTimes ,

I have similar issue where reference qualifier is not working on Reports and List view, 
what should I return from the business rule when I write it for that field ?

Thank you