Publié Thu, 08 Feb 2018 15:41:13 GMT par Seth Jaco Support Specialist

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.

 

Thanks,

https://www.docuware.com/sites/default/files/forums-images/CFDA054B.PNG

Publié Thu, 08 Feb 2018 15:44:58 GMT par Phil Robson DocuWare Corporation Senior Director Professional Services, Americas

The search term EMPTY() is placed in the field you wish to evaluate to blank
NOTEMPTY() does the reverse.

 

Phil Robson

Publié Thu, 08 Feb 2018 15:59:00 GMT par Seth Jaco Support Specialist

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

 

Thanks

Publié Thu, 08 Feb 2018 15:59:07 GMT par Joe Kaufman Bell Laboratories Inc Senior System Architect

Seth,

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.

https://www.docuware.com/forum/english-forums/docuware-questions-about-usage-and-configuration/search-multiple-metadata-one-metadata-field

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.

 

Thanks,

Joe Kaufman

 

Publié Thu, 08 Feb 2018 15:59:48 GMT par Seth Jaco Support Specialist

Understood, thank you Joe :)

Publié Thu, 08 Feb 2018 16:08:16 GMT par Phil Robson DocuWare Corporation Senior Director Professional Services, Americas

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"

 

Phil Robson

Publié Thu, 08 Feb 2018 16:17:18 GMT par Joe Kaufman Bell Laboratories Inc Senior System Architect

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.

Thanks,

JoeK

You must be signed in to post in this forum.