Ran across this thread on LinkedIn and it references that ServiceNow has released "Is in hierarchy" operator to assist in reporting by organization structure. Has anyone seen this referenced or documented anywhere else?
This solves a major pain point in being able to quickly assemble reports based on a leader and their direct and/or indirect team - if it's legit. Just have not been able to find anything concrete on it yet in my instance.
Is there a module/update that needs to be applied?
Greetings @KevinL194086803. I was able to take advantage of this functionality in my Personal Developer Instance. I started on the User table [sys_user] and started building a query by using the Manager field. I'll include screenshots below.
Since I'm in my PDI environment, I don't have good table data to show different layers of management. Finally, I'll include some ServiceNow documentation I was able to find that provides examples of different queries that take advantage of this specific operator. Excellent question and I hope this information is helpful!
Building hierarchical queries
Greetings @KevinL194086803. I was able to take advantage of this functionality in my Personal Developer Instance. I started on the User table [sys_user] and started building a query by using the Manager field. I'll include screenshots below.
Since I'm in my PDI environment, I don't have good table data to show different layers of management. Finally, I'll include some ServiceNow documentation I was able to find that provides examples of different queries that take advantage of this specific operator. Excellent question and I hope this information is helpful!
Building hierarchical queries
Thanks for this! It confirms for me that this feature exists in list view, but it is not accessible in report / data visualization building (at least not easily identifiable). That's the gap for me at this stage, and I'll need to review some of that reference information to see if it's covered in there or not.
If anyone has seen how to leverage this within reporting/visualization and not just list views - appreciate the insights!
