How to make a JQL query for issues with multiple components

jira jql
Antoine picture Antoine · Aug 30, 2011 · Viewed 8.6k times · Source

I'd like to query all issues in JIRA that are associated with more than 1 component. Is that feasible in JQL, and how?

Answer

hawk8 picture hawk8 · Jul 18, 2014

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.

Related questions

JIRA JQL searching by date - is there a way of getting Today() (Date) instead of Now() (DateTime)

I am trying to create some Issue Filters in JIRA based on CreateDate. The only date/time function I can find is Now() and searches relative to that, i.e. "-1d", "-4d" etc. The only problem with this …

Read More
JIRA: Searching for all issues with a given link type

Is there a way to query for all issues with a particular link type? For example, let there be a dependency link where an issue can "depends on" another issue. Is there a query to find all issues that depend …

Read More
How do I query Jira to search for all issues that have been resolved within a length of time from when it was created?

For example, let's say I need to find all issues that were resolved within 1 week's time. I need something like: resolved - created < '1w' Another example: Let's say I have 3 issues: 1) created 2 days ago, resolved 1 day ago. 2) created 5 …

Read More