Task List does not return documents

I have a DocuWare Form that has an amount field, this field is not required and writes to the database index decimal field.  I am trying to locate all the documents that do not have a value in the amount field, I have tried null, and get an error when opening the task list saying it cannot parse and I have tried 0.00 and do not get any documents returned.  Does anyone have an idea on how to configure the task list for zero amount field?

I just did a search and I had to enter 0 in both the start and end range fields to get a result. Try using Is Between and enter 0.00 in both boxes.

Phil Robson
Senior Director Support Americas

No luck, submitting a support ticket.  Thanks.

John, if your document is stored with the decimal field equal 0 (or 0.00) then you may seach for it by placing 0 in start range and another 0 in the end range of your decimal field in the search dialog.

BUT, if your field is stored without any value (NULL in database), you cannot search for it by using a search dialog. But  if you have Tasklist module, you can create a list and specify filter criteria as Decimal Field = "is empty" - this will show you only entries entered as NULL.. If you want your result also to include 0 amounts, use this filter criteria in your list definition: DecimalField = "Is (where claus)"=EMPTY() OR 0