Use PR_SEARCH_KEY in WebDav   

Hi everyone, I have another question. I've looked all over the
internet and I can't find the answer to this, everyone says you have
to use PR_SEARCH_KEY, but no one says how. I've found a few referencs
to these huge long strings to the value, but when I use any of them, I
don't get anything back in the xml results.

If someone could give me a SEARCH example query I would really
appreciate it.
(or correct me if I'm wrong that that one is the only globally unique
id available)

Thanks!

date: Tue, 11 Mar 2008 12:58:21 -0700 (PDT)   author:   John Galt

Re: Use PR_SEARCH_KEY in WebDav   

Hi,

see http://support.microsoft.com/kb/320749 for infos.

Especially the hint to use a where clause like this:

...WHERE "http://schemas.microsoft.com/exchange/mapi/proptag/x0ff60102" = 
CAST("AQEAAAAAAnm6AQAAAAACgK0AAAAA" AS 'bin.base64')

The article uses PR_INSTANCE_KEY, but you can do a similar search with the 
PR_SEARCH_KEY property.

Kind regards,
Henning Krause

"John Galt"  wrote in message 
news:f266ba5d-b8e2-41c9-9a2d-4697c84d95ed@e10g2000prf.googlegroups.com...
> Hi everyone, I have another question. I've looked all over the
> internet and I can't find the answer to this, everyone says you have
> to use PR_SEARCH_KEY, but no one says how. I've found a few referencs
> to these huge long strings to the value, but when I use any of them, I
> don't get anything back in the xml results.
>
> If someone could give me a SEARCH example query I would really
> appreciate it.
> (or correct me if I'm wrong that that one is the only globally unique
> id available)
>
> Thanks!

date: Tue, 11 Mar 2008 23:00:27 +0100   author:   Henning Krause [MVP - Exchange]

Re: Use PR_SEARCH_KEY in WebDav   

On Mar 11, 6:00 pm, "Henning Krause [MVP - Exchange]"
 wrote:
> Hi,
>
> seehttp://support.microsoft.com/kb/320749for infos.
>
> Especially the hint to use a where clause like this:
>
> ...WHERE "http://schemas.microsoft.com/exchange/mapi/proptag/x0ff60102" =
> CAST("AQEAAAAAAnm6AQAAAAACgK0AAAAA" AS 'bin.base64')
>
> The article uses PR_INSTANCE_KEY, but you can do a similar search with the> PR_SEARCH_KEY property.

Thanks for the info, i looked at that article, but I still couldn't
figure out how to return the PR_SEARCH_KEY in my query. Yes, I will
need to search based on a where, but I also need to store it in my
database and none of the samples I could find would result in anything
being returned. (or even an error like SQL would give if the field
doesn't exist)

How does one reference it in the query?

Thanks!

date: Wed, 12 Mar 2008 06:15:13 -0700 (PDT)   author:   John Galt

Re: Use PR_SEARCH_KEY in WebDav   

Hi,

in your search, request property 
http://schemas.microsoft.com/mapi/proptag/x300b0102 like in this query:

SEARCH /public/folder1/ HTTP/1.1
Content-Type: text/xml
Content-Length: XXX
...

<?xml version="1.0"?>
<D:searchrequest xmlns:D = "DAV:" >
   <D:sql>
SELECT "DAV:displayname", 
"http://schemas.microsoft.com/mapi/proptag/x300b0102"  FROM 
"http://myserver/vroot/folder1/"
WHERE "DAV:ishidden" = false AND "DAV:isfolder" = false
   </D:sql>
</D:searchrequest>

This will return the searchkey as base64 encoded string.

You can then search for this key as shown in the link I posted the last 
time.

Kind regards,
Henning Krause


"John Galt"  wrote in message 
news:9d42e132-c115-4bc4-a747-68e6cb820f6c@u69g2000hse.googlegroups.com...
On Mar 11, 6:00 pm, "Henning Krause [MVP - Exchange]"
 wrote:
> Hi,
>
> seehttp://support.microsoft.com/kb/320749for infos.
>
> Especially the hint to use a where clause like this:
>
> ...WHERE "http://schemas.microsoft.com/exchange/mapi/proptag/x0ff60102" =
> CAST("AQEAAAAAAnm6AQAAAAACgK0AAAAA" AS 'bin.base64')
>
> The article uses PR_INSTANCE_KEY, but you can do a similar search with the
> PR_SEARCH_KEY property.

Thanks for the info, i looked at that article, but I still couldn't
figure out how to return the PR_SEARCH_KEY in my query. Yes, I will
need to search based on a where, but I also need to store it in my
database and none of the samples I could find would result in anything
being returned. (or even an error like SQL would give if the field
doesn't exist)

How does one reference it in the query?

Thanks!

date: Wed, 12 Mar 2008 18:09:30 +0100   author:   Henning Krause [MVP - Exchange]