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

  • Thread starter Thread starter hjfcfo
  • Start date Start date
H

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-com:office:office#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.
 
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.
 
Back
Top