Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Database view of sla tables shows incorrect results when group by 'has_breached' field - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Database view of sla tables shows incorrect results when group by 'has_breached' field
KB0864470

Database view of sla tables shows incorrect results when group by 'has_breached' field


836 Views Last updated : Apr 8, 2024 public Copy Permalink
KB Summary by Now Assist

Issue

Database view does not show proper results when group by "has_breached" field when using left join true for SLA table.

Release

All Releases

Cause

Steps to Reproduce : 

1. log in to the instance and take any database view which has task_sla table join.

2. For example, incident_sla is a join on the incident table and task_sla.

3. Set left join =true on task_sla for incident_sla Database view as shown below.

4. Now go to incident_sla.LIST and group by "Has Breached" field.

5. We will see 3 group by results showing "false" value twice.

Group by "Has Breached" field, it is divided into TRUE and FALSE based on if the record is SLA breached or not.

But the display grid shows three groups as two false and one true.

This is because if the left join is set to true, SLA Reference which is empty is also considered which is not the case when the left join is false.

Resolution

Change left join to false for task_sla table on incident_sla Database view back and the issue will be resolved.


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.