Issue Summary

As a Jira user, I would like to see improvements in the current JQL search options. There are some searches for development data searches that we can't perform with the currently available functions.

Expected Results

I would like to create additional development JQL functions to perform additional searches for development data, such as the examples below.

Example 01:

 I want to get the latest deploymentState for each environmenttype development, staging, production.

• Development – show latest deploymentState
• Staging – show latest deploymentState
• Production – show latest deploymentState

Example 02:

I want to get the last successful deployment of an environmenttype

• If the issue has environmentType - development as Successful, staging as Successful and production as failed, Then I want answer as Staging
• If the issue has environmentType - development as Successful, staging as Pending and production as failed, Then I want answer as development
• If the issue has environmentType - development as Successful, staging as Successful and production as successful, Then I want answer as production

Actual Results

We don't have a way to search for specific development data that would be useful in our daily base work.

Workaround

Currently, there is no known workaround for this behavior. A workaround will be added here when available