JQL for deployment name and status

Question

Hello everybody,

for a JIRA automation I need a JQL query which shows me only issues which have been build for production and have the particular build number. So that is the query I am using:

deploymentName ~ 297 AND deploymentEnvironmentName ~ Production AND deploymentState ~ successful

But the issue here is, if the ticket had already a deploymentName 297 from the past (for example from a staging deployment) and then in the future has been deployed to production under a different number, this query will still find this issue.

So what I would need is something which checks both variables together in an AND. So find me issues which have been deployed to production with the PRODUCTION deployment name 297.

How can I achieve this?

Bill Sheboy · Answer

That must be the case.  Maybe check the REST API definitions to see if the Bitbucket stuff is available with another call.  However, if it didn't come back with the get call, I doubt it is available.

What happens when you export all fields from a JQL query? Can you see the field names then, are are they also from the Bitbucket feed and so not available?

unknown · Answer

I tried both but could not find anything in that regard neither the values nor the name "deployment". I guess since it does not exist in JIRA and JIRA is fetching those values from Bitbucket maybe?

Bill Sheboy · Answer

I would search for the text "deployment" as that seems to be prefix of those smart values.  If you do not see it, this may be one of those cases where the names in the JSON do not match the names available in JQL.  In that case, maybe search for the actual values and work backwards to identify any candidate attribute names.