Posted Tue, 13 Mar 2018 15:36:55 GMT by Steve Shriver Application Specialist

I want to create a Task list in a v6.12 DW cloud system that shows every document except those that contain the word 'Complete'. Examples are 'Engineering Complete', 'Billing Complete', 'Shipping Complete', etc. There is no "Does not contain" option so I am using the Is(where clause) option. I have tried "NOT *Complete* and NOT LIKE %Complete% , with and without quotes,to no avail.

Does anyone have the correct syntax handy?

All clues appreciated,

Posted Tue, 13 Mar 2018 16:58:53 GMT by Tim Ohm

I think check your quotes, NOT should be outside, otherwise it would be looking for NOT in in the index value.  NOT LIKE "*COMPLETE"   might do it...

Posted Tue, 13 Mar 2018 18:05:51 GMT by Steve Shriver Application Specialist

In MySQL Query Browser this works; WHERE STATUS LIKE '%complete'

In DW this does not; LIKE '%complete'

nor does this; LIKE "*complete"

or this; LIKE "complete"

or this; LIKE 'complete'

As always, any clues appreciated

Thanks

Posted Tue, 13 Mar 2018 19:23:28 GMT by Josef Zayats

Steve, I think that using whre (like clause) with the value set just as  NOT *Complete* 

No Quotes just NOT in all caps and to astericks around the word you want to exclude.

This should work

Posted Tue, 13 Mar 2018 19:43:59 GMT by Steve Shriver Application Specialist

Thanks Josef. You are, of course, correct. Thanks again.

Posted Tue, 13 Mar 2018 22:33:23 GMT by Phil Robson DocuWare Corporation Senior Director Professional Services, Americas

Everyone,
Search syntax in DocuWare has changed very little since the days of the Windows Client. Search help  has always been available in the Admin tool, and is available at help.docuware.com.
http://help.docuware.com/en/#b57855t51009n75755

 

Phil

 

You must be signed in to post in this forum.