Outlook View SQL (AND/OR)

R

RevCharlie

Guest
Hi, I'm a newbie, been using GTD for about 3 months and found it very helpful so thank you!
The problem is I have over 250 tasks at any one time, so I need to prioritise them. I do this by using the priority switch in outlook. Each week as part of my weekly review I mark as HIGH those tasks that I really need to do next week.
Now I need a view that will let me see, completed = no, AND (either, Due Date is in the next 7 days OR priority = High)
This will give me an easy stap shot of the top 20 or so tasks I've identified as got to get done this week.

Can any one help me with the SQL?

Cheers,
Rev. Charlie Ingram
London
 
B

bdavidson

Registered
This should do it:

Code: 
("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/811c000b" = 0 AND ( %next7days("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")% OR "urn:schemas:httpmail:importance" = 2))

Brian
 
R

RevCharlie

Guest
I've just noticed that I had a couple of overdue tasks in the list, using the above SQL they have disapeared. I guess they are not due in the next 7 days. Is it easy to add a line so that I can see the overdue tasks as well.

Thanks for your help,

Charlie
 
B

bdavidson

Registered
RevCharlie said:
I've just noticed that I had a couple of overdue tasks in the list, using the above SQL they have disapeared. I guess they are not due in the next 7 days. Is it easy to add a line so that I can see the overdue tasks as well.

Thanks for your help,

Charlie
Click to expand...

I think this will do the trick:

Code: 
("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/811c000b" = 0 AND (( %next7days("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")% OR "http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040" <= 'today' ) OR "urn:schemas:httpmail:importance" = 2))

It will match any task that:

1. is not complete

AND

Either:
a. Due in the next seven days
b. Due on or before today (i.e. overdue)
c. high priority

Brian
 
B

Boydal

Registered
Outlook sql filter

I am trying to use outlook to filter through emails that have the same body layout, but with different info filled out.

Here is what the body of the email looks like.

To:
Office ID #:
Client name:
Best day and time to contact:
Reason for client call:
Agent ID:

Is there a way to use the advaced sql outlook filter to check to see if there are any characters after : to make sure the info was filled out?

I have "urn:schemas:httpmail:textdescription" LIKE '%Office ID #:%' which is the basic filter to see if the message contains "Office ID #:, but I want it to check to see if there is any text after the :

Any assistance would be appreciated

Thanks,

boydal
 
You must log in or register to reply here.
Top