@Alexey Matveev Its stored in Oracle database thats HR database fyi.
As a JIRA user I need ScriptRunner functions that will return direct reports and managers of a user based on information from our HR database so I can use them in scripts and JQL.
a function returning manager of an user exists and returns the same person as Oracle database.
a function returning direct reports of an user exists and returns the same list as Oracle Database.
I would not do it as a JQL functin. The performance will be very low. You should do it as a scripted field. Then you can choose on the scripted field in JQL function. You can read more here about scripted field
You can query database like this
@Thanos Batagiannis [Adaptavist] I would need your suggestion on how to write the script or a code snippet or template for user picker (for example user1) and return the result for user1's immediate manager (example: user2). As i started following the link I can find all other sorts of very useful info but not relevant to my query. Thank you.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs