"is one of" condition in report on nested field

SamueleR
Tera Contributor

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!

 

SamueleR_0-1786606883361.png

 

1 REPLY 1

Ankur Bawiskar
Tera Patron

@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! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader