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,