It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage
Highlighted

Read information from DB

Hello,
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

1 comment

I'm afraid "without using plugins" almost rules out what you're trying to do.

You need to find or write some code that can grab information from your database and display it in Jira.  This is going to need a plugin, unless you write something from the outside which pokes data into Jira over the REST API. 

I would strongly recommend an app though.  A REST call can only update fields and Jira data, so you would need to work from custom fields you can add, and it would lag, as you'd be responding to events or polling to see if or when updates were needed.  An app could read the database (or a copy) as needed and do the display in more in-line ways.

Like Maro Hamamjyan likes this

Comment

Log in or Sign up to comment
TAGS

Community Events

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

Events near you