Posted Thu, 08 Feb 2018 15:41:13 GMT by 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

Posted Thu, 08 Feb 2018 15:44:58 GMT by 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

Posted Thu, 08 Feb 2018 15:59:00 GMT by 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

Posted Thu, 08 Feb 2018 15:59:07 GMT by Joe Kaufman Bell Laboratories Inc Application Development Manager

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

 

Posted Thu, 08 Feb 2018 15:59:48 GMT by Seth Jaco Support Specialist

Understood, thank you Joe :)

Posted Thu, 08 Feb 2018 16:08:16 GMT by 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

Posted Thu, 08 Feb 2018 16:17:18 GMT by Joe Kaufman Bell Laboratories Inc Application Development Manager

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.