Database Custom Fields
Good afternoon. First of all can I say that I'm really enjoying using YouTrack, as are the business.
We have a couple of external database "hooks" that I need to create which I imagine will have to utilise the REST API. Firstly, we have a small database held centrally for all of our company projects/programs which is used by various parts of the business. I'd like to have a custom field in youtrack with the values derived from the database. The field would not be project specific, so would be global to the system. How would this be achieved?
Secondly, and in a similar vein, JIRA used to have a plugin called "database custom fields" which would allow field values to be derived from external databases based on what was selected in another field. For example I might have a dropdown field with an asset ID which upon selection of a value ran a DB query to return the details of that asset to another field. How would this be acheived?
Look forward to your response.
Please sign in to leave a comment.
Hi Stephen, thank you for reaching out, and thank you for your kind words.
Now to your questions:
1. You can certainly manage custom fields in YouTrack with the REST API. For example, here is the method to create a new custom field globally, here's how to add a value to an enum field. You're probably going to need some external script that would push the new values to YouTrack when they become available in the external database.
2. You can build automation using workflows and the API of your database. You can trigger a workflow rule on an event in YouTrack (for example, on changing a certain field value) and then call the external API and set a value in an issue in YouTrack based on the API call output.
I hope this helps, do let me know if you have any further questions, I'll be happy to answer.
Superb, thanks for that. I will have a go at this next week and feedback the solutions I come up with!