|
|
|
date: Tue, 8 Nov 2005 08:22:11 -0800,
group: microsoft.public.exchange2000.development
back
Re: Compare with DAV:getlastmodified Field
Hi,Thanks for your reply.
Bad lucky, I have not got it wokred for me.
I use webdav:here is my query:
"<?xml version='1.0'?><g:searchrequest xmlns:g='DAV:'>"
+ "<g:sql>SELECT \"DAV:displayname\",\"DAV:getlastmodified\""
+ "FROM SCOPE('SHALLOW TRAVERSAL OF \"http://server/public/Contact/"
+ "\"') WHERE \"DAV:isfolder\"=false and "
+ "\"DAV:getlastmodified\" > CAST(\'2005-11-08T19:20:00Z\' as
\'dateTime.tz\'))"
I have found a example:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/e2k3/e2k3/_exch2k_searching_calendar_folders_webdav.asp
>>AND "urn:schemas:calendar:dtstart" > '2003/06/01 00:00:00'
but, when I change the datetime, it does not work for me.
it sounds does not do comparsion.it search any time record for me.
not specified time record
Thanks a lot
"Henning Krause [MVP - Exchange]" wrote:
> Hello,
>
> you should use something like
>
> WHERE ("DAV:getlastmodified" > CAST("2005-11-02T12:12:12Z+02:00" as
> 'dateTime.tz'))
> Where the +02:00 is the timezone offset. If your date-time field is already
> UTC, you can just skip ist: 2005-11-02T12:12:12Z
>
> Greetings,
> Henning Krause
> MVP - Exchange
> http://www.infinitec.de
>
>
> "jeff" wrote in message
> news:F00A6C40-47BF-4DA6-8C9A-92B78173086C@microsoft.com...
> > Hi,
> >
> > If I want to search a item on public folder.
> >
> > May I use compare condition with "dateTime.tz" field.
> >
> > for example:
> >
> > "<a:creationdate> " > "2005-11-02 12:12:12"
> >
> > I have tried it, response said it is bad request.
> >
> > I want to confirm this.if Can,How to do it?
> >
> > Thanks in advanced
>
>
>
date: Wed, 9 Nov 2005 08:16:06 -0800
author: jeff
Re: Compare with DAV:getlastmodified Field
Sample works pretty good.Sorry
"jeff" wrote:
> Hi,Thanks for your reply.
> Bad lucky, I have not got it wokred for me.
>
> I use webdav:here is my query:
>
> "<?xml version='1.0'?><g:searchrequest xmlns:g='DAV:'>"
> + "<g:sql>SELECT \"DAV:displayname\",\"DAV:getlastmodified\""
> + "FROM SCOPE('SHALLOW TRAVERSAL OF \"http://server/public/Contact/"
> + "\"') WHERE \"DAV:isfolder\"=false and "
> + "\"DAV:getlastmodified\" > CAST(\'2005-11-08T19:20:00Z\' as
> \'dateTime.tz\'))"
>
> I have found a example:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/e2k3/e2k3/_exch2k_searching_calendar_folders_webdav.asp
>
> >>AND "urn:schemas:calendar:dtstart" > '2003/06/01 00:00:00'
>
> but, when I change the datetime, it does not work for me.
> it sounds does not do comparsion.it search any time record for me.
> not specified time record
>
> Thanks a lot
>
>
>
>
> "Henning Krause [MVP - Exchange]" wrote:
>
> > Hello,
> >
> > you should use something like
> >
> > WHERE ("DAV:getlastmodified" > CAST("2005-11-02T12:12:12Z+02:00" as
> > 'dateTime.tz'))
> > Where the +02:00 is the timezone offset. If your date-time field is already
> > UTC, you can just skip ist: 2005-11-02T12:12:12Z
> >
> > Greetings,
> > Henning Krause
> > MVP - Exchange
> > http://www.infinitec.de
> >
> >
> > "jeff" wrote in message
> > news:F00A6C40-47BF-4DA6-8C9A-92B78173086C@microsoft.com...
> > > Hi,
> > >
> > > If I want to search a item on public folder.
> > >
> > > May I use compare condition with "dateTime.tz" field.
> > >
> > > for example:
> > >
> > > "<a:creationdate> " > "2005-11-02 12:12:12"
> > >
> > > I have tried it, response said it is bad request.
> > >
> > > I want to confirm this.if Can,How to do it?
> > >
> > > Thanks in advanced
> >
> >
> >
date: Wed, 9 Nov 2005 16:33:54 -0800
author: jeff
|
|
