We have a client that has migrated to DocuWare and asked if we could make a query that was similar to the on in their Fortis setup. The problem is the query in Fortis is set to look for documents that have a field left blank. Is there a way to do this in DocuWare? I tried setting it to predefined entry and leaving that box blank but it would not allow me to do that. I have a screen shot attached to show what the query did in Fortis.
The search term EMPTY() is placed in the field you wish to evaluate to blankNOTEMPTY() does the reverse.
That fixed that one perfectly thank you. Second question, is there a way to have the second filed be either blank or "not mine" you can see this in the screenshot I attached.
EDIT: Joe answered this question, thank you both for the help
Do not forget that those keywords need to be uppercased, and for EMPTY() and NONEMPTY() the parentheses are required, too.
See this other forum thread for a discussion on some of the finer points of searching.
I wrote a really nice document on it for our folks, but I cannot upload non-image files here, otherwise I would share it with you. You can do some pretty great stuff with wildcards and built-in search keywords.
Understood, thank you Joe :)
You may need to build a Result List specifically where you can use the query builder to build quite complex queries similar to what you see in Fortis.But try entering this in to the field:
EMPTY() OR "Not mine"
Seth, you are welcome.
If I have found you on LinkedIn (Kentucky?), let me know and I will drop you a line tehr about getting you my more in-depth search document.