Notifications

125 views

Description

When using the Condition Builder to generate a List View query or a Report, if the Condition Builder contains two or more dot-walked fields that have empty values, the generated will be using an INNER JOIN and will return no records.
 
If one of these dot-walked fields is removed, which is querying 'IS NULL', then both SQL queries are left joins and will return the expected results.

Steps to Reproduce

 

1. Ensure you have three incidents that have no caller assigned.
2. Open a List View such as incident.list.
3. Click on the Filter icon to build your condition:
  1. Add the condition "Caller is (empty).", whereby the input value is blank.
  2. Add the condition for the dot-walked field "Caller.Gender is None".
  3. Add the condition for the dot-walked field "Caller.Location is (empty)", whereby the input value is blank.

4. Run the query and observe no records are returned.
5. Remove the last condition for the dot-walked field "Caller.Location is (empty)".
6. Run the query and observe the three incidents with no caller assigned (Step 1) are returned.

 

Workaround

This problem is targeted to be fixed in a future release. As a workaround avoid using two or more dot-walked fields that have empty values in the Condition Builder.


Related Problem: PRB1297534

Seen In

There is no data to report.

Intended Fix Version

Madrid

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-09-12 05:52:27
Published:2018-09-12