| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#11
| |||
| |||
| Hello, the urn:schemas-microsoft-com ffice ffice#Keywords contains the keywordsfrom an office document. Should be empty for any emails... Best regards, Henning Krause "jeff" <jeff@discussions.microsoft.com> wrote in message news:A3D76FD2-A319-4CCD-B2F2-8EDBFF74613A@microsoft.com... > Thanks Henning, > > After I stop it for serveral days. > finally, I got it work. > I have changed query feature from > "http://schemas.microsoft.com/exchange/keywords-utf8" > to: > "urn:schemas-microsoft-com ffice ffice#Keywords"> > it works good, > > Can you explain the diff between those? > > Thanks > > "Henning Krause [MVP - Exchange]" wrote: > >> Hello, >> >> I have no problem getting the categories via a search operation. This is >> my >> search request: >> >> <?xml version="1.0" encoding="utf-8"?><searchrequest >> xmlns="DAV:"><sql>SELECT >> "http://schemas.microsoft.com/exchange/keywords-utf8" FROM SCOPE >> ('Shallow >> TRAVERSAL OF "http://w2k3server/public/contacts"') WHERE ("DAV:isfolder" >> = >> false) </sql></searchrequest> >> >> Best regards, >> Henning Krause >> >> "jeff" <jeff@discussions.microsoft.com> wrote in message >> news:810BB475-5CC2-41D3-BA4F-DFE3E19335AA@microsoft.com... >> > >> > Hello, >> > I have updated one of my record, and I can get it from PropFind, but I >> > still >> > can not get if from SearchQuery >> > >> > Here is my Update Query: >> > >> > String query ="<?xml version=\"1.0\" ?><a ropertyupdate>> > xmlns:a=\"DAV:\" " + >> > "xmlns:n0=\"http://schemas.microsoft.com/exchange\">" + >> > "<a:set>" + >> > " <a rop> " +>> > " <n0:keywords-utf8>Hot Contacts</n0:keywords-utf8>"+ >> > "</a rop>" +>> > " </a:set>" + >> > "</a ropertyupdate>";>> > >> > Here is my PropFind Query: >> > String query ="<?xml version=\"1.0\" ?><D ropfind xmlns =\"DAV:\">> > " + >> > "xmlns:f=\"urn:schemas:contacts:\" " + >> > "xmlns:a=\"http://schemas.microsoft.com/exchange/\">" + >> > "<D rop><D:getcontenttype/></D rop>" +>> > "<D rop><A:email1/></D rop>" +>> > "<D rop><B:keywords-utf8/></D rop>" +>> > "</D ropfind>";>> > >> > >> > "Henning Krause [MVP - Exchange]" wrote: >> > >> >> Hello, >> >> >> >> D:allprop will not return the categories, because they are not part of >> >> the >> >> default schema. >> >> >> >> Try to get them explicitly: >> >> >> >> <?xml version="1.0" ?><D ropfind xmlns ="DAV:"> <keywords-utf8>> >> xmlns="http://schemas.microsoft.com/exchange/" /></D ropfind>>> >> >> >> If they are not returned now, you should check whether the item >> >> actually >> >> has >> >> categories associated with it. >> >> >> >> Best regards, >> >> Henning Krause >> >> >> >> >> >> "jeff" <jeff@discussions.microsoft.com> wrote in message >> >> news:2E24BED2-A550-4124-8DA8-EC7038F0B8B5@microsoft.com... >> >> > >> >> > No, I can not get it. >> >> > >> >> > HERE IS QUERY: >> >> > <?xml version="1.0" ?><D ropfind xmlns ="DAV:">>> >> > <D:allprop/></D ropfind>>> >> > >> >> > ANY IDEA? >> >> > Thanks >> >> > >> >> > >> >> > "Henning Krause [MVP - Exchange]" wrote: >> >> > >> >> >> Hello, >> >> >> >> >> >> do you get the keywords-utf8 when you do a PROPFIND on the item >> >> >> http://pdmail.wallacewireless.com/pu...est%20/BB.eml? >> >> >> >> >> >> Best regards, >> >> >> Henning Krause >> >> >> >> >> >> "jeff" <jeff@discussions.microsoft.com> wrote in message >> >> >> news:B7992BDF-5911-41F0-A512-26BB76597FFC@microsoft.com... >> >> >> > >> >> >> > This is the Query: >> >> >> > <?xml version='1.0'?><g:searchrequest xmlns:g='DAV:' >> >> >> > xmlns:d="urn:schemas:contacts:" xmlns:e="urn:schemas:httpmail:" >> >> >> > xmlns:f="http://schemas.microsoft.com/mapi/proptag" >> >> >> > xmlns:m="http://schemas.microsoft.com/exchange"> >> >> >> > <g:sql>SELECT >> >> >> > "DAV:id", >> >> >> > "DAV:getlastmodified", >> >> >> > "DAV:creationdate", >> >> >> > "urn:schemas:contacts ",>> >> >> > "urn:schemas:contacts:cn", >> >> >> > "urn:schemas:contacts:sn", >> >> >> > "urn:schemas:contacts:givenName", >> >> >> > "urn:schemas:contacts:title", >> >> >> > "urn:schemas:contacts:telephoneNumber", >> >> >> > "http://schemas.microsoft.com/mapi/proptag/X3A1D001F", >> >> >> > "urn:schemas:contacts:mobile", >> >> >> > "urn:schemas:contacts:telephonenumber2", >> >> >> > "urn:schemas:contacts:facsimiletelephonenumber ", >> >> >> > "urn:schemas:contacts:homefax", >> >> >> > "urn:schemas:contacts:email1", >> >> >> > "urn:schemas:contacts:email2", >> >> >> > "urn:schemas:contacts:email3", >> >> >> > "urn:schemas:contacts:workaddress", >> >> >> > "urn:schemas:contacts:l", >> >> >> > "urn:schemas:contacts:st", >> >> >> > "urn:schemas:contacts ostalcode",>> >> >> > "urn:schemas:contacts:homepostaladdress", >> >> >> > "urn:schemas:contacts:homeCity", >> >> >> > "urn:schemas:contacts:homeState", >> >> >> > "urn:schemas:contacts:homePostalCode", >> >> >> > "urn:schemas:contacts:spousecn", >> >> >> > "http://schemas.microsoft.com/exchange/keywords-utf8" /* Category >> >> >> > */ >> >> >> > FROM SCOPE('SHALLOW TRAVERSALOF >> >> >> > "http://pdmail.wallacewireless.com/public/ >> >> >> > mContactTest /"') >> >> >> > WHERE "DAV:isfolder"=false and >> >> >> > "DAV:ishidden"=false and >> >> >> > "DAV:contentclass" = 'urn:content-classes erson'>> >> >> > ORDER BY >> >> >> > "urn:schemas:contacts:sn","urn:schemas:contacts:gi venName" >> >> >> > ASC >> >> >> > </g:sql></g:searchrequest> >> >> >> > >> >> >> > >> >> >> > Here is the answer: >> >> >> > >> >> >> > 07/03/21 14:40:01 >> >> >> > <<<<<<< from >> >> >> > erver --------------------------------------------------- >> >> >> > 07/03/21 14:40:01 HTTP/1.1 207 Multi-Status >> >> >> > 07/03/21 14:40:01 Date: Wed, 21 Mar 2007 19:40:32 GMT >> >> >> > Server: Microsoft-IIS/6.0 >> >> >> > X-Powered-By: ASP.NET >> >> >> > Content-Type: text/xml >> >> >> > Accept-Ranges: rows >> >> >> > MS-WebStorage: 6.5.7638 >> >> >> > Transfer-Encoding: chunked >> >> >> > >> >> >> > <a:multistatus >> >> >> > xmlns:b="urn:uuid:c2f41010-65b3-11d1-a29f-00aa00c14882/" >> >> >> > xmlns:c="xml:" >> >> >> > xmlns:e="http://schemas.microsoft.com/mapi/proptag/" >> >> >> > xmlns:f="http://schemas.microsoft.com/exchange/" >> >> >> > xmlns:d="urn:schemas:contacts:" >> >> >> > xmlns:a="DAV:"> >> >> >> > >> >> >> > 07/03/21 14:40:01 <a:response> >> >> >> > 07/03/21 14:40:01 <a:href> >> >> >> > 07/03/21 14:40:01 >> >> >> > http://pdmail.wallacewireless.com/pu...Test%20/BB.eml >> >> >> > 07/03/21 14:40:01 </a:href> >> >> >> > 07/03/21 14:40:01 <a ropstat>>> >> >> > 07/03/21 14:40:01 <a:status> >> >> >> > 07/03/21 14:40:01 HTTP/1.1 200 OK >> >> >> > 07/03/21 14:40:01 </a:status> >> >> >> > 07/03/21 14:40:01 <a rop>>> >> >> > 07/03/21 14:40:01 <a:id> >> >> >> > 07/03/21 14:40:01 AQEAAAAAAL/hAQAAAAAAxnwAAAAA >> >> >> > 07/03/21 14:40:01 </a:id> >> >> >> > 07/03/21 14:40:01 <a:getlastmodified >> >> >> > b:dt="dateTime.tz"> >> >> >> > 07/03/21 14:40:01 2007-03-21T16:53:46.250Z >> >> >> > 07/03/21 14:40:01 </a:getlastmodified> >> >> >> > 07/03/21 14:40:01 <a:creationdate b:dt="dateTime.tz"> >> >> >> > 07/03/21 14:40:01 2006-12-21T17:16:56.609Z >> >> >> > 07/03/21 14:40:01 </a:creationdate> >> >> >> > 07/03/21 14:40:01 <d >>> >> >> > 07/03/21 14:40:01 </d >>> >> >> > 07/03/21 14:40:01 <d:cn> >> >> >> > 07/03/21 14:40:01 B B >> >> >> > 07/03/21 14:40:01 </d:cn> >> >> >> > 07/03/21 14:40:01 <d:sn> >> >> >> > 07/03/21 14:40:01 B >> >> >> > 07/03/21 14:40:01 </d:sn> >> >> >> > 07/03/21 14:40:01 <d:givenName> >> >> >> > 07/03/21 14:40:01 B >> >> >> > 07/03/21 14:40:01 </d:givenName> >> >> >> > 07/03/21 14:40:01 <d:title> >> >> >> > 07/03/21 14:40:01 </d:title> >> >> >> > 07/03/21 14:40:01 <d:telephoneNumber> >> >> >> > 07/03/21 14:40:01 416-5556789 >> >> >> > 07/03/21 14:40:01 </d:telephoneNumber> >> >> >> > 07/03/21 14:40:01 <d:mobile> >> >> >> > 07/03/21 14:40:01 </d:mobile> >> >> >> > 07/03/21 14:40:01 <d:telephonenumber2> >> >> >> > 07/03/21 14:40:01 </d:telephonenumber2> >> >> >> > 07/03/21 14:40:01 <d:facsimiletelephonenumber> >> >> >> > 07/03/21 14:40:01 </d:facsimiletelephonenumber> >> >> >> > 07/03/21 14:40:01 <d:homefax> >> >> >> > 07/03/21 14:40:01 </d:homefax> >> >> >> > 07/03/21 14:40:01 <d:email1> >> >> >> > 07/03/21 14:40:01 "B@test.com" <B@test.com> >> >> >> > 07/03/21 14:40:01 </d:email1> >> >> >> > 07/03/21 14:40:01 <d:workaddress> >> >> >> > 07/03/21 14:40:01 business Street Business >> >> >> > City, >> >> >> > Business >> >> >> > State Business Postal >> >> >> > 07/03/21 14:40:01 Business Country >> >> >> > 07/03/21 14:40:01 </d:workaddress> >> >> >> > 07/03/21 14:40:01 <d:l> >> >> >> > 07/03/21 14:40:01 Business City >> >> >> > 07/03/21 14:40:01 </d:l> >> >> >> > 07/03/21 14:40:01 <d:st> >> >> >> > 07/03/21 14:40:01 Business State >> >> >> > 07/03/21 14:40:01 </d:st> >> >> >> > 07/03/21 14:40:01 <d ostalcode>>> >> >> > 07/03/21 14:40:01 Business Postal >> >> >> > 07/03/21 14:40:01 </d ostalcode>>> >> >> > 07/03/21 14:40:01 <d:homepostaladdress> >> >> >> > 07/03/21 14:40:01 home Street home City, home >> >> >> > state >> >> >> > Home >> >> >> > postal Home Country >> >> >> > 07/03/21 14:40:01 </d:homepostaladdress> >> >> >> > 07/03/21 14:40:01 <d:homeCity> >> >> >> > 07/03/21 14:40:01 home City >> >> >> > 07/03/21 14:40:01 </d:homeCity> >> >> >> > 07/03/21 14:40:01 <d:homeState> >> >> >> > 07/03/21 14:40:01 home state >> >> >> > 07/03/21 14:40:01 </d:homeState> >> >> >> > 07/03/21 14:40:01 <d:homePostalCode> >> >> >> > 07/03/21 14:40:01 Home postal >> >> >> > 07/03/21 14:40:01 </d:homePostalCode> >> >> >> > 07/03/21 14:40:01 <d:spousecn> >> >> >> > 07/03/21 14:40:01 </d:spousecn> >> >> >> > 07/03/21 14:40:01 </a rop>>> >> >> > 07/03/21 14:40:01 </a ropstat>>> >> >> > 07/03/21 14:40:01 <a ropstat>>> >> >> > 07/03/21 14:40:01 <a:status> >> >> >> > 07/03/21 14:40:01 HTTP/1.1 404 Resource Not Found >> >> >> > 07/03/21 14:40:01 </a:status> >> >> >> > 07/03/21 14:40:01 <a rop>>> >> >> > 07/03/21 14:40:01 <e:X3A1D001F> >> >> >> > 07/03/21 14:40:01 </e:X3A1D001F> >> >> >> > 07/03/21 14:40:01 <d:email2> >> >> >> > 07/03/21 14:40:01 </d:email2> >> >> >> > 07/03/21 14:40:01 <d:email3> >> >> >> > 07/03/21 14:40:01 </d:email3> >> >> >> > 07/03/21 14:40:01 <f:keywords-utf8> >> >> >> > 07/03/21 14:40:01 </f:keywords-utf8> >> >> >> > 07/03/21 14:40:01 </a rop>>> >> >> > 07/03/21 14:40:01 </a ropstat>>> >> >> > 07/03/21 14:40:01 </a:response> >> >> >> > 07/03/21 14:40:01 <a:response> >> >> >> > 07/03/21 14:40:01 <a:href> >> >> >> > 07/03/21 14:40:01 >> >> >> > http://pdmail.wallacewireless.com/pu...dnewRecord.eml >> >> >> > 07/03/21 14:40:01 </a:href> >> >> >> > 07/03/21 14:40:01 <a ropstat>>> >> >> > 07/03/21 14:40:01 <a:status> >> >> >> > 07/03/21 14:40:01 HTTP/1.1 200 OK >> >> >> > 07/03/21 14:40:01 </a:status> >> >> >> > 07/03/21 14:40:01 <a rop>>> >> >> > 07/03/21 14:40:01 <a:id> >> >> >> > 07/03/21 14:40:01 AQEAAAAAAL/hAQAAAAAAxn8AAAAA >> >> >> > 07/03/21 14:40:01 </a:id> >> >> >> > 07/03/21 14:40:01 <a:getlastmodified >> >> >> > b:dt="dateTime.tz"> >> >> >> > 07/03/21 14:40:01 2007-03-13T16:56:26.640Z >> >> >> > 07/03/21 14:40:01 </a:getlastmodified> >> >> >> > 07/03/21 14:40:01 <a:creationdate b:dt="dateTime.tz"> >> >> >> > 07/03/21 14:40:01 2007-03-13T16:56:26.640Z >> >> >> > 07/03/21 14:40:01 </a:creationdate> >> >> >> > 07/03/21 14:40:01 <d >>> >> >> > 07/03/21 14:40:01 </d >>> >> >> > 07/03/21 14:40:01 <d:cn> >> >> >> > 07/03/21 14:40:01 newRecord newRecord >> >> >> > 07/03/21 14:40:01 </d:cn> >> >> >> > 07/03/21 14:40:01 <d:sn> >> >> >> > 07/03/21 14:40:01 newRecord >> >> >> > 07/03/21 14:40:01 </d:sn> >> >> >> > 07/03/21 14:40:01 <d:givenName> >> >> >> > 07/03/21 14:40:01 newRecord >> >> >> > 07/03/21 14:40:01 </d:givenName> >> >> >> > 07/03/21 14:40:01 <d:title> >> >> >> > 07/03/21 14:40:01 </d:title> >> >> >> > 07/03/21 14:40:01 <d:telephoneNumber> >> >> >> > 07/03/21 14:40:01 </d:telephoneNumber> >> >> >> > 07/03/21 14:40:01 <d:mobile> >> >> >> > 07/03/21 14:40:01 </d:mobile> >> >> >> > 07/03/21 14:40:01 <d:telephonenumber2> >> >> >> > 07/03/21 14:40:01 </d:telephonenumber2> >> >> >> > 07/03/21 14:40:01 <d:facsimiletelephonenumber> >> >> >> > 07/03/21 14:40:01 </d:facsimiletelephonenumber> >> >> >> > 07/03/21 14:40:01 <d:homefax> >> >> >> > 07/03/21 14:40:01 </d:homefax> >> >> >> > 07/03/21 14:40:01 <d:email1> >> >> >> > 07/03/21 14:40:01 "newRecord@test.com" >> >> >> > <newRecord@test.com> >> >> >> > 07/03/21 14:40:01 </d:email1> >> >> >> > 07/03/21 14:40:01 <d:workaddress> |
![]() |
| Thread Tools | |
| Display Modes | |
In an effort to better serve ads to our visitors, cookies are used on objectmix.com. For more information, check out our Privacy Policy.