Answers.Body: <p>I believe you would need to find the country_id for Italy in civicrm_country, and then use that? The country name will not be stored in any other table.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-11-05T22:22:08.717Z
Answers.Text: i have marked this down since the original post basically says "i tried this on demo and it works fine" - and I retested and yes you can select ≠ and select the country from the dropdown.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-06T14:52:01.800Z
Answers.LastActivityDate: 2016-09-06T14:52:01.800Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>I have  a problem with Search Builder on my CiviCRM.
  I just wanted to check how many contacts i have in my db outside of Italy.
  It should be a simple search: </p>
  
  <ol>
  <li>Record Type = Contacts</li>
  <li>Field type = Country</li>
  <li>Operator = ≠</li>
  <li>Value = Italy</li>
  </ol>
  
  <p>I get this error: "Sorry but we are not able to provide this at the moment.
  DB Error: no such field". If i try with another field type, e.g. city, it works.</p>
  
  <p>I've tried the same search in CiviCRM Beta website, it works.</p>
  
  <p>Is there someone who can help me figuring out what could be the problem here?</p>
  
  <p>Thank you very much
  Alessandro</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-11-05T22:24:53.073Z
Comments.Text: taking it as given that you do have records that have Italy, and ones that have a country other than Italy. The search will not return results with Null or Empty in country field.
Comments.UserDisplayName: petednz - fuzion
Tags: <search-builder>
Title: Search Builder Issue
ThreadText: # Search Builder Issue
  
  (Asked by: username_0 on 2016-09-06)
  
  I have a problem with Search Builder on my CiviCRM.
  I just wanted to check how many contacts i have in my db outside of Italy.
  It should be a simple search:
  
  1. Record Type = Contacts
  2. Field type = Country
  3. Operator = ≠
  4. Value = Italy
  
  I get this error: "Sorry but we are not able to provide this at the moment.
  DB Error: no such field". If i try with another field type, e.g. city, it works.
  
  I've tried the same search in CiviCRM Beta website, it works.
  
  Is there someone who can help me figuring out what could be the problem here?
  
  Thank you very much
  Alessandro
  
  **Tags:** search-builder
  
  > **Comments:**
  > **username_1**: taking it as given that you do have records that have Italy, and ones that have a country other than Italy. The search will not return results with Null or Empty in country field.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-09-06. Score: -1
  
  I believe you would need to find the country\_id for Italy in civicrm\_country, and then use that? The country name will not be stored in any other table.
  
  > **Comments:**
  > **username_1**: i have marked this down since the original post basically says "i tried this on demo and it works fine" - and I retested and yes you can select ≠ and select the country from the dropdown.  
  
  ---
  
  