Hi there,

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.

Thanks in advance for any hints.

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