You are viewing limited content. For full access, please sign in.

Question

Question

Need to remove a multi value field

asked on May 8, 2013 Show version history
Good Morning -
 
We have a field that was marked multi value by accident, when it should have been single value.  Then, someone added a two values to at least one of the documents.
 
Now when we try to revert the field back to single value, it issues a warning.
 
What is the best way to identify which documents have more than one entry in a multi value field?  Once we edit the extra values, I assume I'll be able to set the field back to single value -
 
Thanks
0 0

Answer

APPROVED ANSWER
replied on May 30, 2013
You can find these entries by doing the following advanced search:
 
{[]:[Field](2)="*"}
 
Where Field is the name of the field you’re working with. This will return all entries that have at least two values in that multi-value field.
 
Note that this will not return entries that are in the recycle bin. You may want to purge those first before trying to change the field back to a single-value field, or you might get the error again.
 
I hope this helps. Let us know if you have any other questions.
4 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.