Update the JQL query/get values to JQL from Custom Field Values

[Vinay Dasari]

Hi All,

I am thinking is there any way to update the JQL query based on the custom field values.

for example: I have custom field "Teams" which is single select drop down field and it has options as "Developers" "Testers". 

so for now we had manually entered JQL - Project="Test" AND Issuetype = "EPIC" AND Teams in "Developers, Testers" and will get the issues.

but the requirement is in upcoming days, we might add few other values like "Operations" etc to Teams custom field associated to multiple projects. Instead of updating manual in JQL can Teams fields values be extracted/updated in JQL query automatically when ever new values found in Teams Custom Field?

[Ashley Hudson · Accepted solution]

Heya @Vinay Dasari

It sounds like you are editing the JQL via the JQL search but if you want to edit the JQL without having to re-write the whole JQL, then select the basic search on the left and you can easily change the custom field values for your JQL there! You can refer to the documentation which shows the difference between the JQL search and the basic search! 

(https://support.atlassian.com/jira-work-management/docs/perform-a-basic-search/)

Kind Regards,

Ashley Hudson

[Vinay Dasari]

Thanks for the quick response :) @Ashley Hudson

we use basic as well but the actual requirement is can we automate the updating/editing of JQL query based on any new custom field values

[Ashley Hudson]

Heya @Vinay Dasari

I'm personally unsure if that automation exists native within Jira? As far as I'm aware there is no way to automate the JQL based on custom field values? My advise would be to create separate queues for each use cases and go from there! Perhaps this could be done with script runner but I'm unsure if this could be the solution. 

Sorry I couldn't help you further but hopefully creating queues can work for you!

Kind Regards,

Ashley Hudson

[Vinay Dasari]

Okay.. I appreciate - Thanks @Ashley Hudson