We have a system, based on SQL DB, where we have all the necessary data about our users. I need to get all the users whose manager is the Reporter (the person who created the ticket). I have the managers list, I have the users filtered by manager, or can get them in SQL, but I need you to advice me to reach my goal (without using plugins). How to start? Should I just create an exe, which will read information from DB and put it under schedule, or I can install any soft, that will let me to connect Jira with DB?
Also in case i get the users I need how should I show the users in Jira Service desk? Should I use any API, that will allow to update the particular filed in particular thicket? Please let me know about the right direction to move on!
Thanks in advance
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events