Related List Conditions in Reports - Where are the options for the dropdown configured per table?

[Ryan Whittaker]

Hi all,

This one has been bugging me for quite a while, I'd be very grateful if anyone can help.

In reports, we have the option to apply some logic to related records (see screenshot). This works just fine and I know how to use this for the related lists that are available in the dropdown. What I don't know is what determines which related lists appear in the dropdown.

For example, we have a particular table where the records have metric instances aligned as a related list. When we try to report from that table, the metric instances related list does not appear as an option in the related list conditions drop down in reports. Why not? It's a related list on the table we're trying to report from, so why isn't it an option in the related list conditions dropdown? Is there a particular setting I'm missing that needs to be configured to allow the related list to appear here?

[Anurag Tripathi]

Hi,

It will show you all the tables that have a 1:1 relationship present to the current table.

You can read about different type of relationships here.

Relationships in ServiceNow Explained - ServiceNow Community

For the second part, this is just a report on the parent table and this available filter is to add additional condition, for eg you want to see change requests with open tasks(this means you still want to see change request only and not the tasks)

Once you open a record then you should see the related list(if it is configured to show up on the form), you can configure related lists on a form but no one needs all of them.