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

  • Thread starter hjfcfo
  • Start date Views 2,462
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.
 
Top