We use Component as team value. SO a ticket assigned to component A belongs to Team A. Problem is sometimes people assign more than one component to a ticket and that ticket is basically not owned by anyone.
I need to know if a ticket has more than one component value.
How do I query "component is ONLY value-x". Or component has only one value in it?
Hi @Nari Man
As far as I know, using Scriptrunner JQL won't give you this query either - it has more powerful component searches but would still required the "not in" addition to remove those with more than just one component.
Suggested approach is to create a custom scripted field for count of components - that way you can search for the required component in issues with a component count of only 1.
I found details on this thread about creating the scripted field - and see this Confluence page from the creator of ScriptRunner - there is a discussion on the issue in the comments section, right at the top :)
Since we don't have an easier, direct solution - what I tried instead is to take an export (csv) with the component field being in the search result. And then use excel do the work! When we export it puts individual components in separate columns, so its a lot easier to figure out how many have only 1 or 2 or more.. pretty useful when the results of the query is of large number.
I would like to know why is not better solution to create custom jql function instead of creating custom scripted field for count of components?
I think the work will be nearly the same and you do not need new field and the function can be possible to use for any multivalue field?
But would someone give her an example for script runner?
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events