create a script runner function that is manager of user and reports directly to manager.
Hello,
Where information about managers is stored?
@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
https://scriptrunner.adaptavist.com/5.0.4/jira/scripted-fields.html
You can query database like this
https://scriptrunner.adaptavist.com/latest/jira/recipes/misc/connecting-to-databases.html
@Thanos Batagiannis _Adaptavist_ could you please point me to a script that can help me with this issue? Please and thank you.
It looks like you're new here. Sign in or register to get started.
