Duplicate entries for states in drop down - When querying on Constituent addresses

When creating a constituent query and filtering on Address\State, you might notice that some states have duplicate entries in the drop-down. This issue is caused by the state appearing as an entry in multiple countries. 
To correct this problem follow the steps below:

1) To find what other countries have the duplicate states as an entry, select each iteration of the state from the state drop down and display the country in the Results fields to display.
2) In order to delete the unwanted state entries, update the constituent records and select the correct entry for the states so that they the right country.
3) Go to Administration > Countries and States
4) Now that records no longer have the incorrect state entries, delete the duplicate state entries from the countries they are associated with.

Steps to Duplicate

1) Add a constituent query
2) Use the filter to include records where Addresses\States is equal to - and notice that some states have duplicate entries in the list.

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.