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

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:eek:ffice:eek:ffice#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.
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top