I think you all are starting to realize my dilemma.

There are 500,000 documents in a repository I am working on that do not have a template assigned to them. Before I can assign the template I want, they have certain required fields that need to be filled in. I cannot possibly fill in all of the required fields on all of the documents in one Workflow run for a couple of reasons:

• Search Repository can't handle more than 10,000 entries at one time.
• I know that some of the documents will not be able to have the Case Number inferred and filled in automatically, due to a variety of circumstances surrounding the logic I am using to fill them in.
• Each time I run "Search repository" I don't want it to find the entries that this Workflow has already filled in.
• Since there is no template on these documents, the Case Number field is also not on them. But it is on some already, so I can't just search for all Case Numbers and give it some bogus value, then go back and fill it in with something else.

This is why I would ideally be able to search for all of the documents in a given folder area, that do not have this field on them at all. Since the documents also don't have the template on them, there appears to be no way to run this search.

If the entry has no template assigned (or has been assigned a template that doesn't use that field) then using

[MySearchTerm] - {[]:[Case Number]="*"}

should work. Note that you can't add an independent field with a blank value.

What is the issue you're having with the above search term?

I just built a quick test for this and my workflow is able to find the correct document (the one with a blank field). I made the workflow very basic for testing:

LF Search: {[]:[Case Number]=""} & {LF:LOOKIN="AOPA\Sandbox"}

The next activity applies a stamp to the document returned in the search.

When I ran it, the stamp was applies to the document in which the "Case Number" field was blank.

Screenshots:

LF Client showing fields. Doc 2 has blank Case Number field:

Document after running test workflow that applied the stamp to the document returned in the search results (Doc 2):

Doc 1 (that has a case number) did not get a stamp applied.

So it seems to be working for me. Maybe try to simplify your search? I didn't specify a name of a document. I just searched the entire folder location.

Actually... looking back at your syntax, I think including {LF:Name="*" in your search might be the problem. You are essentially asking the search to return "all" documents with any name. So the Field search parameter is probably being ignored. Trying removing that parameter from your search.

Actually, this appears to give me all results *except* the ones that are empty, which is what I was trying to avoid.

Doing the reverse...

 {LF:Name="*", Type="DB"} & {LF:LOOKIN="\RepositoryName\Test Folder\"} & {[]:[Case Number]=""}

Doesn't show anything, because these documents do not have the field on them at all (no template assigned).

Any additional thoughts?

Did you try not having anything between the quotes in your field parameter?

When I use this syntax in my repository, I find all documents that the Application Number field is blank:

{[]:[AAF - Application Number]=""}

So your revised syntax should just be:

{LF:Name="*", Type="DB"} & {LF:LOOKIN="\RepositoryName\Test Folder\"} - {[]:[Case Number]=""}