Reports with Custom Field

Question

This question is in reference to Atlassian Documentation: Advanced searching

Hello there, I currently have a custom fselect all of the ield set so my costumers can choose their country from a list(Is there another way to do this? Currently Im doing some codes in the custom field description field).

These countries is added by code by appending all of the countries into the dropdown list that I've created in my Issue Collector.

But now I'd like to create reports for these countries, the amount of issue for each country. This would take me days if I would add all of the contries manually, so what I would like is some JQL that could select all of the disctinct values that has been provided in my custom country field.

Nic Brough -Adaptavist- · Answer

It's actually very hard to implement a generic country-picker to suit all your possible clients, as you rapidly run into country specific issues at a business level.  Do you just list all the sovereign states recognised by the UN?  Or do you mean actual countries?  What about principalities or protectorates?  I live and work in England, and the country is the UK on a broad level.  Some people can work fine with UK.  But if you're a lawyer, you need to be aware that Scotland's legal system has very significant differences to that of England Wales and Northern Ireland.  If you want to talk about money, you'll often need to select from Jersey, Guernsey, Isle of Mann, Gibraltar, and so-on.  I imagine many other "countries" have similar issues.  On top of that, what happens when you don't need all the countries?  Some people might only need the Commonwealth, or EU or Schengen area, or African countries.  And so-on.  It's easier to let people have a select list and they can put in their options.

Anyway, no, you can't easily report on text like that.  You'd need to run individual reports for each string you want to find (and what happens when someone makes a spelling mistake or uses a synonym?  A lot of people mix up Britain, the UK and often England, using them interchangably - we know what they usually mean, but the words are totally different)

Kim Andersson · Answer

Sounds like JIRA should have a countrypicker.

Well, let's say that I have a custom field that contains normal strings, can I somehow get a report on how many of each string there is on just that specific custom field?

Nic Brough -Adaptavist- · Answer

Yes, that's how a select list works.