Outlook 2007 SQL syntax to filter views of tasks and todo items

[hjfcfo]

I am trying to create a filtered view of todo items in Outlook 2007. In the
filter, I want to exclude completed to-do items, and include to-do items that
have the "Category: = "Business", and a user defined custom text field call
"Project" that contains the word "Financing". When I enter these filters, I
get no results which is not what I'd expect. Here is the syntax Outlook
generated for this:

("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/811c000b"
= 0 AND
"http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/Project"
LIKE '%Financing%' AND "urn:schemas-microsoft-comfficeffice#Keywords" =
'Business')

What is incorrect about the syntax that is causing the filter to have no
results at all?

Thnaks to anyone that has this knowledge.

 

[Ken Slovak - [MVP - Outlook]]

The DASL MAPI tags look OK to me for Completed = false plus the conditions
for categories and your UDF.

Is that UDF defined so that it's a field in the folder where you are
filtering? Perhaps also including a clause that tests for the UDF existing
might be helpful.