ServiceNow reports with related list conditions

[rahulyamgar]

Hello Friends, 

I am trying to create a report to show the Hardware Models only for particular CIs (based on some CI Query). For this I am querying the Hardware Model table and then under the related list conditions using related list putting conditions against the CI. Generated report does not honor the conditions it only honors the greater than equal to condition.

In short, it retrieved all the records satisfying greater than equal to condition only not the query against the related list fields.

Anyone has any idea? Am i missing anything here?

Thanks,
Rahul

[Guido Bernuetz]

can't see an issue. all works well in my test.

Pls provide screenshots of your example to repeat your try exactly.

[rahulyamgar]

Thanks @Guido Bernuetz for your quick response. 

Query returned results to me but those results are incorrect. E.g. per below screenshot, in my system i have 53 models with model categories as Computer and none of the computer record with 'is Secure' field as 'true' all are false. But still query returns the results as 53.

Could you please validate your query as well by filtering based on the fields such as Operating System, etc.

Thanks,
Rahul

[Guido Bernuetz]

Under "Related List Condition" you find "Grater than or equal to 1". this can be clicked and changed.

Your condition means: query models which have 1 or more related computer where "is-secure is true.

Your list show only the class "Computer".
Do you have other Model Categories which contains "Computer" in category name and related to other CI classes?

Hint: change the report layout to list to see the detailed category records