Answers.Body: <p>Welcome to CiviCRM SE, Could you please tell why you want to add 'is_active' field to country table? Can't you just disable the countries from appearing in drop down(or include only countries that you need in your system) from CiviCRM &gt;&gt; Administer &gt;&gt; Localization &gt;&gt; Languages, Currency, Locations?</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-06T03:10:14.417Z
Answers.Text: oh... didn't know that there was such an option there, thanks a lot
Answers.UserDisplayName: Kurogami Dono
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-05T12:33:44.970Z
Answers.LastActivityDate: 2020-10-05T12:33:44.970Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I want to filter the option list of the &quot;country&quot; field on the address tab.. I found out that the country field is getting the list of country field in &quot;civicrm_country&quot; table and I want to add a new column &quot;is_active&quot; on the table for the filtering but I can't find the function that generates the list.. does someone know where I can find the function generating the option list so I can add the filter? thanks a lot</p>
  
Tags: <addresses><individual><fieldoptions>
Title: how can I filter the list for address > "country" field in "new individual"
ThreadText: # how can I filter the list for address > "country" field in "new individual"
  
  (Asked by: username_0 on 2020-10-05)
  
  I want to filter the option list of the "country" field on the address tab.. I found out that the country field is getting the list of country field in "civicrm\_country" table and I want to add a new column "is\_active" on the table for the filtering but I can't find the function that generates the list.. does someone know where I can find the function generating the option list so I can add the filter? thanks a lot
  
  **Tags:** addresses, individual, fieldoptions
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-10-05. Score: 1 | Accepted answer
  
  Welcome to CiviCRM SE, Could you please tell why you want to add 'is\_active' field to country table? Can't you just disable the countries from appearing in drop down(or include only countries that you need in your system) from CiviCRM >> Administer >> Localization >> Languages, Currency, Locations?
  
  > **Comments:**
  > **username_0**: oh... didn't know that there was such an option there, thanks a lot  
  
  ---
  
  