Doubt with a JQL query to colour cards

Question

Hi,

I'm playing with the board in order to improve the visibility and I have two questions building the JQL queries:

First

((type = "Feature") OR (type = "Task") OR (type ="Sub-task")) AND status in ("In Development", "In Review", "Ready for Acceptance", "Acceptance") AND NOT status changed AFTER "-1d"

If you see the first part I'm including the type feature, task and subtask. But the first one is wrong. I just want to include the type feature that does not have any subtask created. This is because sometimes we directly work in the feature card instead of in the subtask if the card doesn't have subtasks created.

Second

status = "Ready for Deployment"

I want to include in this query above, just the cards that have all the pull requests merged. Is it possible ? We are using Bitbucket and is already integrated.

Thanks in advance.

David Manso · Answer

@Vamsi Kandala thanks, pretty useful.

Do u have solution for the first topic?

Vamsi Kandala · Answer

Hi @David Manso

Welcome to the Atlassian community!

Please refer to this documentation about JQL query to include the development fields:

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-development-fields-reference-973491363.html

Hope this helps.

Thanks,
Vamsi