• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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

H

hjfcfo

#1
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]

#2
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.

"hjfcfo" <hjfcfo> wrote in message

news:3BCE7FD3-8CBD-489A-9962-50210619B1AE@microsoft.com...
> 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.