Searching for Problems or Defects in multiple countries

[David_Hamlin]

Searching for Problems or Defects in multiple countries.

I need to query for all problems and defects in a set our countries (i.e. Russia, Estonia, Mongolia, etc.). 

Please share if you know how to write the query to include All Problems from a list of countries. 

[Hernan Halabi - Elite IT Consulting Group · Accepted solution]

Hello @David_Hamlin welcome to the community. It's a bit hard to guess the query without knowing the custom field type and name but assuming that your defects are all tracked as bugs and the custom field you are using for the country is named country and is a multiselect field. Query should be something like this

Issuetype = bug and county in (Russia, Estonia, Mongolia)

[Jack Brickey · Accepted solution]

Hi David, welcome to the Community. To be able to query by country you would need a custom field or other means of associating am issue with a country. Further you would likely want to require that the country be specified at creation or assignment. Do you have some field that specifies or would resolve to a specific country?

[David_Hamlin]

Thanks! I managed to figure it out ... (see below as sample)

AND Country ~ Singapore OR Country ~ Philippines AND Region = APAC a