Incident

[Kumar2721]

Hello Team,

In the Incident table, the location field is correctly filtered based on the selected company using a reference qualifier. However, when running a report on the Incident table and selecting a location, it shows duplicate entries like two ‘South Africa’. I want the location to be displayed only in relation to its company. For example:

• Company: Airtel → Location: South Africa
• Company: Vodafone → Location: South Africa
  
  

Would you like me to also suggest possible solutions for this issue in ServiceNow, such as how to handle duplicate locations in reports?

[Ankur Bawiskar]

@Kumar2721 

in reporting the reference qualifier is not respected so the filtering won't work there.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Kumar2721]

In the report, I want only one location to appear instead of duplicates. Since reference qualifiers don’t work in reports, do I need to write a new script for this? What should be my next step?

[Ankur Bawiskar]

@Kumar2721 

what's your actual requirement?

[sangrulkaradvai]

In Reports, ServiceNow doesn’t automatically apply that reference qualifier — it just reads the display value of the reference field (e.g. “South Africa”).

ensure reports are filtered by company:

• Add a filter like:
  Company is Airtel
  Then choose “South Africa” → this ensures only one appears.