PC Review


Reply
Thread Tools Rate Thread

How to create the customized Outlook SQL DASL for selected days?

 
 
Bill Lin
Guest
Posts: n/a
 
      12th Feb 2010
Outlook 2007/2010 provided pre-defined view for tasks due by the selected
days. It seems the SQL DASL Filter dialog has the ability to do it, but I
don't know what's the property tag for selected days
I am using the filter below to get tasks due on today
%today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")%
When I changed the selected days on the calendar taskpad view, it won't get
the tasks due on the date I selected. Can't find any documents to use SQL
DASL filters except for Andre Delin's weblog: Doing more with Outlook filter
and SQL DASL syntax

Can you please help? Thanks

Bill
 
Reply With Quote
 
 
 
 
Ken Slovak - [MVP - Outlook]
Guest
Posts: n/a
 
      12th Feb 2010
The help on PropertyAccessor has a lot more about using DASL filters, but
doesn't cover everything. Usually to construct a DASL filter many of us go
to the customize dialog for views and in the filter section we create the
filter in the Advanced tab and then look at the SQL tab to get the
equivalent DASL terms.

The filter you refer to in your message is looking at the task DueDate
property for dates of today.

The SQL tab will show the DASL MAPI property tag for a property added in the
Advanced tab.

I also use a MAPI viewer to get DASL tags for any property, I use OutlookSpy
as my MAPI viewer (www.dimastr.com).

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Bill Lin" <Bill (E-Mail Removed)> wrote in message
news:B387ACF8-6114-4DF9-BC54-(E-Mail Removed)...
> Outlook 2007/2010 provided pre-defined view for tasks due by the selected
> days. It seems the SQL DASL Filter dialog has the ability to do it, but I
> don't know what's the property tag for selected days
> I am using the filter below to get tasks due on today.
> %today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")%
> When I changed the selected days on the calendar taskpad view, it won't
> get
> the tasks due on the date I selected. Can't find any documents to use SQL
> DASL filters except for Andre Delin's weblog: Doing more with Outlook
> filter
> and SQL DASL syntax
>
> Can you please help? Thanks
>
> Bill


 
Reply With Quote
 
Bill Lin
Guest
Posts: n/a
 
      16th Feb 2010
Thank you, Ken. Your information is helpful

Bill

"Ken Slovak - [MVP - Outlook]" wrote:

> The help on PropertyAccessor has a lot more about using DASL filters, but
> doesn't cover everything. Usually to construct a DASL filter many of us go
> to the customize dialog for views and in the filter section we create the
> filter in the Advanced tab and then look at the SQL tab to get the
> equivalent DASL terms.
>
> The filter you refer to in your message is looking at the task DueDate
> property for dates of today.
>
> The SQL tab will show the DASL MAPI property tag for a property added in the
> Advanced tab.
>
> I also use a MAPI viewer to get DASL tags for any property, I use OutlookSpy
> as my MAPI viewer (www.dimastr.com).
>
> --
> Ken Slovak
> [MVP - Outlook]
> http://www.slovaktech.com
> Author: Professional Programming Outlook 2007.
> Reminder Manager, Extended Reminders, Attachment Options.
> http://www.slovaktech.com/products.htm
>
>
> "Bill Lin" <Bill (E-Mail Removed)> wrote in message
> news:B387ACF8-6114-4DF9-BC54-(E-Mail Removed)...
> > Outlook 2007/2010 provided pre-defined view for tasks due by the selected
> > days. It seems the SQL DASL Filter dialog has the ability to do it, but I
> > don't know what's the property tag for selected days
> > I am using the filter below to get tasks due on today.
> > %today("http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81050040")%
> > When I changed the selected days on the calendar taskpad view, it won't
> > get
> > the tasks due on the date I selected. Can't find any documents to use SQL
> > DASL filters except for Andre Delin's weblog: Doing more with Outlook
> > filter
> > and SQL DASL syntax
> >
> > Can you please help? Thanks
> >
> > Bill

>
> .
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create customized OUTLOOK stationary? TheHat Microsoft Outlook Discussion 1 11th Nov 2009 06:22 PM
How do I create a customized e-mail in Outlook 2003? =?Utf-8?B?R2xlbg==?= Microsoft Outlook Discussion 1 26th Oct 2006 10:47 AM
Outlook 2003 & DASL Crash Microsoft C# .NET 1 17th May 2006 04:05 PM
How can you create a customized button in Outlook =?Utf-8?B?RWQgUw==?= Microsoft Outlook Discussion 0 9th Mar 2006 03:56 PM
Outlook calander - Track important days with different customized. =?Utf-8?B?TWFkaGF2LldH?= Microsoft Outlook Calendar 1 10th Mar 2005 07:24 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:41 AM.