I am attempting to use Advanced syntax to create a search that looks for all documents in a particular folder area that have an empty/missing field. I know I could do a more broad search, view the results in the client and sort by that column to find the blanks. However, I am trying to plug this in to a Workflow so it can automatically fill them in with data it will get somewhere else.
My syntax looks something like this so far:
{LF:Name="*", Type="DB"} & {LF:LOOKIN="\RepositoryName\Test Folder\"} - {[]:[Case Number]="*"}
I thought that would get me all of the documents in that folder area without a Case Number, but that doesn't seem to work.
Using this example, what would the correct syntax be to find all of the documents that do NOT have a Case Number on them?
Also -- what I do not want to do is loop through every document in this folder with a conditional sequence that fills in the field if it is blank. There are hundreds of thousands of documents to loop through, so that would make this take too long. I need to keep my search result set smaller.