Notifications

72 views

Description

Using a related list condition "Equal to 0 / None" which also includes a dot walk condition returns the record count correctly but does not return any records in the list.

Steps to Reproduce

  • Create a list report
  • Add a related list query with a condition of equal to 0 or less than 1.
  • Ensure you add an extra condition which is dot walking to a field.
  • Run the report and the row count will display but no records.


Workaround

The report will work if you make the following changes

  • Change the related query to less than 2
  • Change the related query to less than or equal to 0
  • Change the report type to a bar.
  • Remove the dot walked conditions.

Related Problem: PRB1337440

Seen In

Madrid Patch 4
Madrid Patch 5
New York Patch 2
SR - IntegrationHub - F5 Integration v1.0.3
SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - GRC Workbench - New York 2019 Q3
SR - IRM - PA Premium Integration - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - IRM - SIG Assessment Legacy - Madrid 2019 Q1
SR - IRM - Vendor Risk Management - Madrid 2019 Q1
SR - ITOM - Discovery and Service Mapping - v1.0.35
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - VR - Qualys - New York 2019 Q3
SR - VR - Rapid7 - London 2019 Q2 v.6.2.1
SR - VR - Vulnerability Response - New York 2019 Q3
SR - VR - Vulnerability Response PA Content - Madrid 2019 Q2

Fixed In

Madrid Patch 10
New York Patch 6
Orlando

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-03-27 14:47:30
Published:2020-02-28