Hi All,
Is there a way to check for a duplicate value of a given field for all entries in the repository?
I would do a custom query on the repository (see screenshot)
You need to find out what the property ID of the field value you are interested in is (in the prop_val table in the repository database).
How about checking the count from a search against that field ?
Hi Dane.
I think that is not possible .
Why exactly do you need that info?
If the answers is want to know that info to delete the data duplicate of the meta-field
and also you know what entry is , you can use this ....
I attached a video with the steps, I hope it works for you or you can use a variant and add a search and a for each entry node.
Regards!!
Are you trying to find all documents where a given multi-value field has 2 or more duplicated values? Or, given a document and a field on that document, are you trying all documents with the same field value?
Given a document and a field on that document, I would like to find all documents with the same field value. For example, I would like to see if I have duplicated invoices in the repository by seeing if there are two documents with the same number in the invoice number field.
And are you looking for all values that are duplicates or trying to find if a particular value is duplicated ?
I would like to find all values that are duplicates
I would do a custom query on the repository (see screenshot)
You need to find out what the property ID of the field value you are interested in is (in the prop_val table in the repository database).
Hi Again Dane do you try to do a seach query on workflow to get that info?
I attached a video with the info.
After do the search you can do what you need with the entries.
You could just run a search.
Hi Dane,
I think you have two options:
If you have a document and you want to find if any other documents have the same invoice number, Miruna and David have shown that a search will do the trick.
If you want to find all duplicated invoice numbers in the repository, you can use the custom query.
Thank you all for your help. I believe the custom query will best suit my needs