Forum

  • If you are new to these Forums, please take a moment to register using the fields above.

Announcement

Announcement Module
Collapse
No announcement yet.

Outlook View SQL (AND/OR)

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Outlook View SQL (AND/OR)

    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

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

    Comment


    • #3
      sorted, thanks, Charlie

      Comment


      • #4
        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

        Comment


        • #5
          Originally posted by RevCharlie
          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
          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

          Comment


          • #6
            That did the trick, thanks Brian.
            Charlie

            Comment


            • #7
              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

              Comment

              Working...
              X