Question

Search Syntax For Distinct or Unique Value

Version 10 Workflow How To

Updated December 13, 2022

asked on December 8, 2022

Is there a way to search for unique values within a folder for a specific metadata field? In this case it would be a contract number. Ideally I want to get results back with just the documents with unique values in the contract number field.

0 0

Replies

replied on December 8, 2022

Hey Dillan, you can do this using advanced search syntax if you know the values you don't want.

As an example, if I was looking in my "Test" folder for all documents that had a "Year" field, but only wanted to returns values that did not equal '2022', I would use the following syntax:

{LF:LOOKIN="FrankTestsLF11\TEST\Scanning Test"} - {[]:[Year]="2022"}

I could then do this with multiple values by grouping them up like:

{LF:LOOKIN="FrankTestsLF11\TEST\"} - ({[]:[Year]="2021"} | {[]:[Year]="2022"})

0 0

replied on December 13, 2022

There isn't a way to do this with a single search. I think you would need to query the contents of the folder and check for unique values in that list.

0 0

replied on December 13, 2022

In my use case, the documents are spread amongst many sub-folders. In theory, can I run the search, copy those documents into a singe folder, then remove any duplicate documents based on a certain field?

0 0

You are not allowed to follow up in this post.

Question

Question

Search Syntax For Distinct or Unique Value

Replies

Sign in to reply to this post.