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 @Lisboa. 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
