J
Jinbo
Hi All,
I am totally lost at this moment. I have been struggling to retrieve
"Category" from contact item from an Exchange public folder via webDAV for
days. Following is my query:
<a:searchrequest xmlns:a="DAV:">
<a:sql>
SELECT "a:href"
,"urn:schemas:contacts
" as organization
,"urn:schemas:contacts:fileas" as fileAs
,"urn:schemas:contacts:cn" as cn
,"urn:schemas:contacts:telephoneNumber" as phone
,"urn:schemas:contacts:mobile" as cell
, "urn:schemas-microsoft-comfficeffice#keywords" as category
FROM SCOPE('SHALLOW TRAVERSAL OF "$exchange_server/"')
WHERE "DAV:ishidden"=false AND "DAV:isfolder"=false
ORDER BY "urn:schemas:contacts:cn" ASC
</a:sql>
</a:searchrequest>
When I break down the xml for each item. they all look like below, with no
category info.
stdClass Object
(
[A_HREF] => Array
(
[0] => stdClass Object
(
[_text] =>
http://matrix/public/PM Contacts/Rona-Innes-155022051.EML
)
)
[A_PROPSTAT] => Array
(
[0] => stdClass Object
(
[A_STATUS] => Array
(
[0] => stdClass Object
(
[_text] => HTTP/1.1 200 OK
)
)
[A_PROP] => Array
(
[0] => stdClass Object
(
[ORGANIZATION] => Array
(
[0] => stdClass Object
(
[_text] => Rona-Innes
)
)
[FILEAS] => Array
(
[0] => stdClass Object
(
[_text] => Rona-Innes
)
)
[PHONE] => Array
(
[0] => stdClass Object
(
[_text] => (613) 741-6331
)
)
)
)
)
[1] => stdClass Object
(
[A_STATUS] => Array
(
[0] => stdClass Object
(
[_text] => HTTP/1.1 404 Resource Not Found
)
)
[A_PROP] => Array
(
[0] => stdClass Object
(
[D_HREF] => Array
(
[0] =>
)
[CN] => Array
(
[0] =>
)
[CELL] => Array
(
[0] =>
)
[CATEGORY] => Array
(
[0] =>
)
)
)
)
)
)
However when I run this query:
<aropfind xmlns:a="DAV:">
<a:allprop/>
</aropfind>
I can see everything about one contact including category. What have I
overlooked?
Thank in advance!
Benson
P.S. Environ: Windows Server 2003 with Exchange 2003 and IIS.
I am totally lost at this moment. I have been struggling to retrieve
"Category" from contact item from an Exchange public folder via webDAV for
days. Following is my query:
<a:searchrequest xmlns:a="DAV:">
<a:sql>
SELECT "a:href"
,"urn:schemas:contacts
" as organization,"urn:schemas:contacts:fileas" as fileAs
,"urn:schemas:contacts:cn" as cn
,"urn:schemas:contacts:telephoneNumber" as phone
,"urn:schemas:contacts:mobile" as cell
, "urn:schemas-microsoft-com
fficeffice#keywords" as categoryFROM SCOPE('SHALLOW TRAVERSAL OF "$exchange_server/"')
WHERE "DAV:ishidden"=false AND "DAV:isfolder"=false
ORDER BY "urn:schemas:contacts:cn" ASC
</a:sql>
</a:searchrequest>
When I break down the xml for each item. they all look like below, with no
category info.
stdClass Object
(
[A_HREF] => Array
(
[0] => stdClass Object
(
[_text] =>
http://matrix/public/PM Contacts/Rona-Innes-155022051.EML
)
)
[A_PROPSTAT] => Array
(
[0] => stdClass Object
(
[A_STATUS] => Array
(
[0] => stdClass Object
(
[_text] => HTTP/1.1 200 OK
)
)
[A_PROP] => Array
(
[0] => stdClass Object
(
[ORGANIZATION] => Array
(
[0] => stdClass Object
(
[_text] => Rona-Innes
)
)
[FILEAS] => Array
(
[0] => stdClass Object
(
[_text] => Rona-Innes
)
)
[PHONE] => Array
(
[0] => stdClass Object
(
[_text] => (613) 741-6331
)
)
)
)
)
[1] => stdClass Object
(
[A_STATUS] => Array
(
[0] => stdClass Object
(
[_text] => HTTP/1.1 404 Resource Not Found
)
)
[A_PROP] => Array
(
[0] => stdClass Object
(
[D_HREF] => Array
(
[0] =>
)
[CN] => Array
(
[0] =>
)
[CELL] => Array
(
[0] =>
)
[CATEGORY] => Array
(
[0] =>
)
)
)
)
)
)
However when I run this query:
<a
ropfind xmlns:a="DAV:"><a:allprop/>
</a
ropfind>I can see everything about one contact including category. What have I
overlooked?
Thank in advance!
Benson
P.S. Environ: Windows Server 2003 with Exchange 2003 and IIS.