How to make a JQL query for issues with multiple components
I'd like to query all issues in 开发者_运维问答JIRA that are associated with more than 1 component. Is that feasible in JQL, and how?
I didn't find a solution that was feasible in JQL. I also don't believe I have the ability to write JQL functions so I didn't get to explore that route.
I needed to be able to get a list of my tickets with multiple components. I did this by exporting my tickets to excel and then added a column which checked the cell in the same row in the Components column:
=IF(ISNUMBER(SEARCH(",", P5)), "Multi Components", "Single Component")
This checks the cell for the partial text ","
. If it has the comma, Multi Components
is returned.
component in ("component 1", "component 2", "component 3") ORDER BY updated DESC
Above solution helped me :)
Something like this should work:
components in (mycomponent1, "my component 2")
More help available at the Syntax Help icon on the advanced searching page
You can use
component in ("Component A") and component in ("Component B")
精彩评论