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

Status
Not open for further replies.
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.

"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.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
E Re:BCM failed to install in outlook 2007 due to SQL Server Express 20 BCM (Business Contact Manager) 1
D Outlook 2007 BCM SQL server problem BCM (Business Contact Manager) 1
S Outlook 2007 crash linked to gdiplus.dll Using Outlook 0
S Outlook 2007 - Automatic purge fail Using Outlook 0
J outlook 2007 doesn't let me choose which .pst to search Using Outlook 2
D Outlook 2007 vs. Outlook 2010 -- ToDo Bar Using Outlook 0
D Outlook 2007 on 365 Using Outlook.com accounts in Outlook 2
S Macro for other actions - Outlook 2007 Outlook VBA and Custom Forms 23
S Verwendung von Outlook 2007 Using Outlook 0
A Arthur needs help with 2007 Outlook e-mail Using Outlook.com accounts in Outlook 3
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
S outlook 2007 calendar search Using Outlook 6
B Migrate Outlook 2007 to Office 365 Using Outlook 3
X I have met my waterloo trying to resolve embedded graphics problem with outlook 2007 and now 2016 Using Outlook 1
R Outlook 2007 only loads some appointments Using Outlook 0
C Move Outlook 2007 to new PC with Outlook 365 Using Outlook 3
J Outlook 2007 Hide Messages Option not Available Using Outlook 2
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 4
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 0
B Server errors Outlook 2007 Using Outlook 1
S Reboot of frozen windows7 results in changed outlook 2007 settings Using Outlook 1
S Outlook 2007 printing wrong email address at top of page Using Outlook 8
M Configure outlook 2007 to accept digital signatures Using Outlook 2
D Outlook 2007 crashes when opening an email Using Outlook 2
R New chap saying hello and needing advice on Outlook 2007 thumbnails Using Outlook 3
icacream From Outlook 2007 to 2016 ! Using Outlook 9
vodkasoda Object could not be found Error in Outlook 2007 Outlook VBA and Custom Forms 5
S Outlook 2007: Address Cards allow entering text! Why? Using Outlook 3
S View Appointment in Text Wrap in Outlook 2007 Month Calendar View Using Outlook 0
L Outlook 2007 Separate the Send/Receive functions Using Outlook 2
M Outlook 2007 Contacts Glitch: Creating a new email Using Outlook 1
C Move from Outlook 2007 Enterprise (MOE) to Outlook Pro plus 2007 Using Outlook 1
J reinstalling Outlook 2007 asking for user name & password Using Outlook 14
P outlook addin unloaded in office 2007 Using Outlook 0
B Fonts in Outlook 2007 Using Outlook 4
R Add Exchange Account to existing POP3 Outlook 2007 Profile Using Outlook 0
C out of space in file group Outlook 2007 Using Outlook 2
A Moving archived contents in Outlook 2007 back into working folders Using Outlook 0
P Outlook 2007 Email Categorization using VBA Outlook VBA and Custom Forms 1
M Unable to Configure Gmail Account in Outlook 2007 Using Outlook 1
R Outlook 2007 or 2010 - Lock Down Functionality Outlook VBA and Custom Forms 3
S Outlook 2007, windows 10 Font size Using Outlook 1
Diane Poremsky Manually create a POP3 account in Outlook 2007 New Slipstick.com Articles 0
J Can Click to Drag Custom Form Field But Cannot Drop When Designing in Outlook 2007 Outlook VBA and Custom Forms 2
L Outlook 2007 Font Using Outlook 3
J Outlook 2007 connector and Windows 10 Using Outlook 3
R Outlook 2007 - Shared Accounts and Resources without Exchange Server Using Outlook 0
L Outlook 2007 - Macro Re Search Using Outlook 16
D Outlook (Office) 2007 & Windows 10 Pro Using Outlook 6
MattC Problem with Outlook 2007 & iCloud / duplicate tasks Using Outlook 1

Similar threads

Top