Question

Need to remove a multi value field

Laserfiche Version 9 Administration

Updated August 22, 2014

asked on May 7, 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 7, 2013 • Show version history

Hi,

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.

2 0

Replies

replied on August 22, 2014

I ran a test (in my LF 9.1.1 demo repository) on the advice about finding entries with multiple values in multi-value fields. It worked perfectly.

Then I tried it on my customer's system and it failed to return any results - even after completely purging the recycle bin of all entries. (I was logged in as "Admin".)The admin console still insists that there is at least one multi-value entry.

I will upgrade the server and client apps to the latest version 9. But in the meantime, is there any other possible thing I could try?

0 0

You are not allowed to follow up in this post.

Question

Question

Need to remove a multi value field

Answer

Replies

Sign in to reply to this post.