Query appointment keywords via WebDAV?

  • From: Ralph Scheuer <ralph.scheuer@xxxxxxx>
  • To: exchangelist@xxxxxxxxxxxxx
  • Date: Thu, 23 Dec 2004 17:36:37 +0100

[Apology in advance: sorry for cross-posting this problem to various lists, but I'm urgently looking for some help]

Hello everybody,

I have been using the query below to get appointment data via WebDAV from
Exchange Server 2003. However, I have not been able to get the appointment
categories (keywords) that way. I have also tried
http://schemas.microsoft.com/exchange/keywords-utf8 instead. I can search
for specific values if I include this in my WHERE statement but I never get
the value of an appointment back. The rest of the data can be retrieved just
fine.

Is there any way to get these categories / keywords via WebDAV?

Thanks in advance for any hints.Your help is greatly appreciated.

Ralph Scheuer

<?xml version ="1.0"?><d:searchrequest xmlns:d="DAV:"><d:sql>SELECT
"urn:schemas:calendar:busystatus", "urn:schemas:calendar:location",
"http://schemas.microsoft.com/mapi/subject";,
"urn:schemas:httpmail:textdescription",
"urn:schemas:calendar:instancetype", "urn:schemas:calendar:dtstart",
"urn:schemas:calendar:dtend",
"urn:schemas-microsoft-com:office:office#Keywords" FROM SCOPE('shallow
traversal of "http://exchangeserver.xxx.com/exchange/xxx/Kalender";') WHERE
"urn:schemas:calendar:dtstart" &gt;= CAST("2004-11-25T00:00:00Z" as
'dateTime') AND "urn:schemas:calendar:dtend" &lt;=
CAST("2005-11-25T00:00:00Z" as 'dateTime') AND "DAV:ishidden" =
false</d:sql></d:searchrequest>



Other related posts:

  • » Query appointment keywords via WebDAV?
  1. Home
  2. exchangelist
  3. Archive
  4. 12-2004