"is one of" condition in report on nested field

[SamueleR]

Hi all, first post here; 

I am trying to set up a report on the cmdb_rel_ci table, and I would like to use "is one of" condition on the child.class field, but the condition is not present (see picture below). I read something about comas in the field, but I do not think I have any comas in the values there. Any idea on how I could enable this? I have the operator for the child.environment field, for example, so this is quite puzzling.

Thanks in advance for your help!

[Ankur Bawiskar]

@SamueleR 

not all fields support IS ONE OF operator

If it's not available then simply you can't use it.

Many customers are already moving from legacy reporting to platform analytics.

I will suggest to start using Platform Analytics.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[SamueleR]

Thanks Ankur. What's holding me back from jumping to PA is that I have to recreate there all my existing reports.

[Chetna_Aggarwal]

The issue is most likely because child.class is a dot-walked field based on the CMDB class hierarchy, and ServiceNow does not expose the “is one of” operator for this field in the standard condition builder.

The comma explanation is not relevant here. You don't need commas in the stored values to get the operator.

Recommended approach: use the IN operator through an encoded query or create a database view/reporting solution if you need to select multiple CI classes.

For example:

child.sys_class_nameINcmdb_ci_server,cmdb_ci_linux_server,cmdb_ci_win_server

[SamueleR]

Thanks Chetna. How to I use an encoded query on a dot walked field? I am familiar with using them starting from filters, but does not allow me to dot walk.