JQL to return unique entries in custom field

I currently have a custom "Labels" field that users will enter in multiple file names called Impacted Files.

I then use a search filter to bring issues into a JIRA Macro in Confluence where I have all columns removed except Impacted Files.

This works in that the files are listed, but they are now showing multiple rows of the same file name.

What I would like to do is display a list of these entries, but have it only list an entry once. 

1. How can I do this with my current setup? 

2. How can I do this in a better manner, displaying a list these Impacted Files? 

 

Thank you in advance

2 answers

1 accepted

Andrew,

Thank you for your response and recommendations for the add-on. 

Even though it is a "workaround", I was able to add a JIRA Chart - Two Dimentional Filters with the Impacted Files as the YAxis (rows) and Sprint as the XAxis (the XAxis could be anything, this just produced the least amount of unneeded data), and I was able to have it list all files names just once, and put the count in the Sprint column. 

So while not handled through JQL, I was able to do so through the built in filter. 

 

 

1 vote

JIRA's JQL is expected to return a list of JIRA issues.   So removing all the other columns can be done in that view, but the reason you still see multiple repeated values here are directly due to the number of JIRA issues with that filename.   I don't think that there is a JQL query you can use with JIRA to just return unique values like this.  


I'd recommend taking a look at this related post:  JIRA JQL Help Values exist in one or more - Atlassian Community

They explore that this is a limitation of what JQL can do, but then there are some other users that recommend trying to use a plugin such as SQL for JIRA Driver


Perhaps with the use of this plugin you can create a SQL query that would allow you to do a 'distinct' clause in SQL so that the query could return just one result for each unique name.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Tuesday in Uncategorized

Friday fun: how many celebrates Midsummer holiday or is this a Swedish tradition only?

Any other country that celebrates Midsummer holiday (this friday 22 June)?  

46 views 3 1
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you