Exchange Server

Ralph Scheuer · Guest

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.

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" >= CAST("2004-11-25T00:00:00Z" as
'dateTime') AND "urn:schemas:calendar:dtend" <=
CAST("2005-11-25T00:00:00Z" as 'dateTime') AND "DAV:ishidden" =
false</d:sql></d:searchrequest>

Tom Rizzo [MSFT] · Guest

You need to CAST it as a multi-valued string in your query which it doesn't
look like you're doing.

Tom

--
Looking for a good book on programming Exchange, Outlook, ADSI and
SharePoint? Check out http://www.microsoft.com/MSPress/books/5517.asp

"Ralph Scheuer" <ralphscheuer@mac.com> wrote in message
news:BDF0AF74.E20%ralphscheuer@mac.com...

	Exchange Server Forum Index -> Development	All times are GMT
Page 1 of 1