Related List Condtions on a Report is not producing expected results - Support and Troubleshooting

Related List Condtions on a Report is not producing expected results Issue Related List Condtions on a Report is not producing expected results multiple conditions and ORs across different joins, the join condition for Related List Queries (RLQUERY) was appended to the last join and these joins are producing incorrect results Release Vancouver patch3 Vancouver patch4 Cause RLQuery join conditions being appended to last join can produce incorrect result set Resolution The Related List Condition that is broken can be written as an equivalent Script Include and used as a custom report filter. Below is a general example, but this can be used for your particular report. Let’s assume the report is as follows:

Source Type: Table

Table: Incident

Related List Conditions: Greater than or Equal to 1, Change Task → Parent, Assignment group is Database OR Help Desk OR Hardware

Create a Script Include as follows:

Name: CustomReportingFilters

Client Callable: True

Active: True

Script:

The GlideRecord query in the script adds the related list conditions to a query on change_task. This Script include will return the same sys_id’s for the incident’s that match the related list query condition defined in the report.

Now, create a report as follows:

Source Type: Table

Table: Incident

Conditions: [sys_id] [is] [javascript:new CustomReportingFilters().getRecordsWithRelatedRecords()]

Run the report. This should return the expected Incident records.