"is one of" condition in report on nested field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
32m ago
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! 🙏
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader