|
|
|
date: Thu, 26 Jan 2006 08:41:05 -0800,
group: microsoft.public.exchange2000.development
back
Re: Is it possible to full text index keywords and searach them?
Martin--
I did some looking into this and it appears that MSSearch is already
indexing the urn:schemas-microsoft-com:office:office:Keywords property.
Therefore, the problem apears to lie in specifing the DAV SEARCH request
correctly so that the Exchange Store passes along the appropriate Search
request to MSSearch.
When I send the following Search request, I do see the Microsoft Search
"Succeeded Queries" perfmon counter increment. However, the "Results"
counter does not. What this tells me is that the Exchange Store does
believe that MSSearch is in fact indexing this property and therefore
handing the Search request off to MSSearch. However, MSSearch does not
return any results and that is why the DAV SEARCH request does not return
any results.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<searchrequest xmlns="DAV:">
<sql>SELECT "DAV:href" FROM Scope('SHALLOW TRAVERSAL OF ""') WHERE
CONTAINS ("urn:schemas-microsoft-com:office:office:Keywords",
'"Fubarlicious"')</sql>
</searchrequest>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
I will keep looking into this.
--Chris
================================================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only.
================================================================================
<nitramsen@nospam.nospam> wrote in message
news:9352F20E-542B-4247-9A67-1A658DAE924C@microsoft.com...
> Hi Chris,
>
> Yes, I ran a full population and I tried deleting the previous index and
> made a new one I check the "This index is currently available for
> searching
> by clients". I deleted the index and restarted to server and made a new
> one
> all without any result.
>
> Here is a regedit export of my settings:
> Windows Registry Editor Version 5.00
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ExchangeParameters]
> "SchemaTextFilePathName"="C:\\FullTextIndex\\fulltextprops.txt"
>
> And the file C:\\FullTextIndex\\fulltextprops.txt looks like this:
> http://schemas.microsoft.com/exchange/keywords-utf8
> urn:schemas-microsoft-com:office:office#Keywords
> urn:schemas:mailheader:keywords
> http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/Keywords
>
> I have also tried with only one property in the fulltextprops.txt file.
>
>
>
> Thanks & brgds
> Martin
>
>
> "Chris Ahlers [MSFT]" wrote:
>
>> Just to make sure, did you run a Full Population after adding the
>> additional
>> indexed properties?
>>
>> --Chris
>>
>> ================================================================================
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of any included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm.
>> Please do not send e-mail directly to this alias. This alias is for
>> newsgroup purposes only.
>> ================================================================================
>>
>> <nitramsen@nospam.nospam> wrote in message
>> news:7DC30F19-159C-49EA-9C64-E64FFDE95FBF@microsoft.com...
>> >I have tried to add the the following properties to the Indexer as
>> >described in
>> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/_exch2k_customizing_full-text_indexing.asp
>> >
>> > http://schemas.microsoft.com/exchange/keywords-utf8
>> > urn:schemas-microsoft-com:office:office#Keywords
>> > urn:schemas:mailheader:keywords
>> > http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/Keywords
>> >
>> > And I used to following Query to try to search the indexed property:
>> >
>> > "<?xml version=\"1.0\"?><D:searchrequest xmlns:D = \"DAV:\" >"
>> > + "<D:sql>SELECT
>> > \"DAV:displayname\",\"urn:schemas-microsoft-com:office:office#Keywords\",
>> > \"http://schemas.microsoft.com/exchange/permanenturl\" FROM \"" +
>> > Folder +
>> > "\""
>> > + "WHERE \"DAV:ishidden\" = false AND
>> > \"DAV:isfolder\" = false and
>> > FREETEXT(\"http://schemas.microsoft.com/exchange/keywords-utf8\",'VSL')
>> > "
>> > + "</D:sql></D:searchrequest>"
>> >
>> > I have tried different combinations of FREETEXT/CONTAINS and property
>> > names
>> > but I always get 0 results(There should be 1000+) and sometimes
>> > depending
>> > on
>> > the property name Bad request when I use Contains.
>> >
>> > Did anyone ever manage to index the keyword property and search it?
>> >
>> > I have checked eventlogs and the GatherLogs and there is no problems to
>> > be
>> > found anywhere.
>> >
>> > Is it possible to check that the property as been index?
>> >
>> > If anyone has any idea I would be pleased to heard it.
>> >
>> > BRGDS
>> > Martin
>> >
>>
>>
>>
date: Fri, 3 Feb 2006 09:42:30 -0800
author: Chris Ahlers [MSFT]
Re: Is it possible to full text index keywords and searach them?
Hi Chris,
Thanks for your reply.
I am not sure that this is a problem with the Webdav query because when I do
an advanced query using the categories on tab "more chooses" directly from
outlook it also returns 0 hits.(The same happens if I use advanced with
criteria for keywords).
I have tried to do the same query from Outlook on a replica on a different
server that is index but does not have any custom indexing. And here I get
hits but it takes a long time(45 seconds or more for checking about 20000 msg
and returns 100) so it does probably not use the index.
Thanks
Martin
"Chris Ahlers [MSFT]" wrote:
> Martin--
>
> I did some looking into this and it appears that MSSearch is already
> indexing the urn:schemas-microsoft-com:office:office:Keywords property.
> Therefore, the problem apears to lie in specifing the DAV SEARCH request
> correctly so that the Exchange Store passes along the appropriate Search
> request to MSSearch.
>
> When I send the following Search request, I do see the Microsoft Search
> "Succeeded Queries" perfmon counter increment. However, the "Results"
> counter does not. What this tells me is that the Exchange Store does
> believe that MSSearch is in fact indexing this property and therefore
> handing the Search request off to MSSearch. However, MSSearch does not
> return any results and that is why the DAV SEARCH request does not return
> any results.
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> <searchrequest xmlns="DAV:">
> <sql>SELECT "DAV:href" FROM Scope('SHALLOW TRAVERSAL OF ""') WHERE
> CONTAINS ("urn:schemas-microsoft-com:office:office:Keywords",
> '"Fubarlicious"')</sql>
> </searchrequest>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> I will keep looking into this.
>
> --Chris
>
> ================================================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of any included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm.
> Please do not send e-mail directly to this alias. This alias is for
> newsgroup purposes only.
> ================================================================================
>
> <nitramsen@nospam.nospam> wrote in message
> news:9352F20E-542B-4247-9A67-1A658DAE924C@microsoft.com...
> > Hi Chris,
> >
> > Yes, I ran a full population and I tried deleting the previous index and
> > made a new one I check the "This index is currently available for
> > searching
> > by clients". I deleted the index and restarted to server and made a new
> > one
> > all without any result.
> >
> > Here is a regedit export of my settings:
> > Windows Registry Editor Version 5.00
> >
> > [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ExchangeParameters]
> > "SchemaTextFilePathName"="C:\\FullTextIndex\\fulltextprops.txt"
> >
> > And the file C:\\FullTextIndex\\fulltextprops.txt looks like this:
> > http://schemas.microsoft.com/exchange/keywords-utf8
> > urn:schemas-microsoft-com:office:office#Keywords
> > urn:schemas:mailheader:keywords
> > http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/Keywords
> >
> > I have also tried with only one property in the fulltextprops.txt file.
> >
> >
> >
> > Thanks & brgds
> > Martin
> >
> >
> > "Chris Ahlers [MSFT]" wrote:
> >
> >> Just to make sure, did you run a Full Population after adding the
> >> additional
> >> indexed properties?
> >>
> >> --Chris
> >>
> >> ================================================================================
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> Use of any included script samples are subject to the terms specified at
> >> http://www.microsoft.com/info/cpyright.htm.
> >> Please do not send e-mail directly to this alias. This alias is for
> >> newsgroup purposes only.
> >> ================================================================================
> >>
> >> <nitramsen@nospam.nospam> wrote in message
> >> news:7DC30F19-159C-49EA-9C64-E64FFDE95FBF@microsoft.com...
> >> >I have tried to add the the following properties to the Indexer as
> >> >described in
> >> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/_exch2k_customizing_full-text_indexing.asp
> >> >
> >> > http://schemas.microsoft.com/exchange/keywords-utf8
> >> > urn:schemas-microsoft-com:office:office#Keywords
> >> > urn:schemas:mailheader:keywords
> >> > http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/Keywords
> >> >
> >> > And I used to following Query to try to search the indexed property:
> >> >
> >> > "<?xml version=\"1.0\"?><D:searchrequest xmlns:D = \"DAV:\" >"
> >> > + "<D:sql>SELECT
> >> > \"DAV:displayname\",\"urn:schemas-microsoft-com:office:office#Keywords\",
> >> > \"http://schemas.microsoft.com/exchange/permanenturl\" FROM \"" +
> >> > Folder +
> >> > "\""
> >> > + "WHERE \"DAV:ishidden\" = false AND
> >> > \"DAV:isfolder\" = false and
> >> > FREETEXT(\"http://schemas.microsoft.com/exchange/keywords-utf8\",'VSL')
> >> > "
> >> > + "</D:sql></D:searchrequest>"
> >> >
> >> > I have tried different combinations of FREETEXT/CONTAINS and property
> >> > names
> >> > but I always get 0 results(There should be 1000+) and sometimes
> >> > depending
> >> > on
> >> > the property name Bad request when I use Contains.
> >> >
> >> > Did anyone ever manage to index the keyword property and search it?
> >> >
> >> > I have checked eventlogs and the GatherLogs and there is no problems to
> >> > be
> >> > found anywhere.
> >> >
> >> > Is it possible to check that the property as been index?
> >> >
> >> > If anyone has any idea I would be pleased to heard it.
> >> >
> >> > BRGDS
> >> > Martin
> >> >
> >>
> >>
> >>
>
>
>
date: Tue, 7 Feb 2006 06:27:27 -0800
author: am am
Re: Is it possible to full text index keywords and searach them?
Martin--
OK, the "Categories" field in Outlook maps to the "Keywords" property. If
you set Categories on a Contact or message, then it is stored in the
Keywords property. However, if you set the "Keywords" field on an Office
document, then that property also gets stored in the Keywords property.
Therefore, there was some unintended overloading of the word "Keyword" going
on and that messed me up.
So here is what appears to be happening:
* You have the custom properties setup to index the "Keywords" property
(Categories Field)
* When you execute the search, the Exchange Store asks MSSearch if it
has the necessary property indexed. If so, then the Store hands off the
query and returns the results from MSSearch.
* However, MSSearch is not actually indexing the property and that is
why 0 hits are being returned. This explains why you see hits when querying
another server that does not have the custom indexed properties setup. In
this scenario, MSSearch is not claiming to have indexed the necessary
property and therefore the Exchange Store executes the query, slowly.
Here are the two properties that if they are specified as custom Indexing
properties, will cause the above scenario to happen:
1.)
http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/Keywords
2.) http://schemas.microsoft.com/exchange/keywords
If I execute the following search, I will get back the appropriate hits.
Note that a LIKES query tells DAV to execute a Store Search and not a
Full-Text Indexing search regardless if the Full-Text Index is enabled for
searching.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SEARCH /myexbox/user1/Inbox/ HTTP/1.1
Host: myexbox
Content-Type: text/xml
Content-Length: 196
<searchrequest xmlns="DAV:">
<sql>SELECT "DAV:href" FROM Scope('SHALLOW TRAVERSAL OF ""') WHERE
("http://schemas.microsoft.com/exchange/keywords" LIKE
'%Fubarlicious%')</sql>
</searchrequest>
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
So what makes this property so special? Well, it is a multi-value property.
I am not 100% positive that MSSearch can index Multi-Value properties. I
will be checking the MSSearch guys, but I wouldn't hold your breath.
--Chris
================================================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only.
================================================================================
<nitramsen@nospam.nospam> wrote in message
news:8EE55227-7112-49A0-819C-2D19B88ECBDF@microsoft.com...
> Hi Chris,
>
> Thanks for your reply.
>
> I am not sure that this is a problem with the Webdav query because when I
> do
> an advanced query using the categories on tab "more chooses" directly from
> outlook it also returns 0 hits.(The same happens if I use advanced with
> criteria for keywords).
>
> I have tried to do the same query from Outlook on a replica on a different
> server that is index but does not have any custom indexing. And here I get
> hits but it takes a long time(45 seconds or more for checking about 20000
> msg
> and returns 100) so it does probably not use the index.
>
> Thanks
> Martin
>
>
> "Chris Ahlers [MSFT]" wrote:
>
>> Martin--
>>
>> I did some looking into this and it appears that MSSearch is already
>> indexing the urn:schemas-microsoft-com:office:office:Keywords property.
>> Therefore, the problem apears to lie in specifing the DAV SEARCH request
>> correctly so that the Exchange Store passes along the appropriate Search
>> request to MSSearch.
>>
>> When I send the following Search request, I do see the Microsoft Search
>> "Succeeded Queries" perfmon counter increment. However, the "Results"
>> counter does not. What this tells me is that the Exchange Store does
>> believe that MSSearch is in fact indexing this property and therefore
>> handing the Search request off to MSSearch. However, MSSearch does not
>> return any results and that is why the DAV SEARCH request does not return
>> any results.
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>> <searchrequest xmlns="DAV:">
>> <sql>SELECT "DAV:href" FROM Scope('SHALLOW TRAVERSAL OF ""') WHERE
>> CONTAINS ("urn:schemas-microsoft-com:office:office:Keywords",
>> '"Fubarlicious"')</sql>
>> </searchrequest>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>> I will keep looking into this.
>>
>> --Chris
>>
>> ================================================================================
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of any included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm.
>> Please do not send e-mail directly to this alias. This alias is for
>> newsgroup purposes only.
>> ================================================================================
>>
>> <nitramsen@nospam.nospam> wrote in message
>> news:9352F20E-542B-4247-9A67-1A658DAE924C@microsoft.com...
>> > Hi Chris,
>> >
>> > Yes, I ran a full population and I tried deleting the previous index
>> > and
>> > made a new one I check the "This index is currently available for
>> > searching
>> > by clients". I deleted the index and restarted to server and made a new
>> > one
>> > all without any result.
>> >
>> > Here is a regedit export of my settings:
>> > Windows Registry Editor Version 5.00
>> >
>> > [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\ExchangeParameters]
>> > "SchemaTextFilePathName"="C:\\FullTextIndex\\fulltextprops.txt"
>> >
>> > And the file C:\\FullTextIndex\\fulltextprops.txt looks like this:
>> > http://schemas.microsoft.com/exchange/keywords-utf8
>> > urn:schemas-microsoft-com:office:office#Keywords
>> > urn:schemas:mailheader:keywords
>> > http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/Keywords
>> >
>> > I have also tried with only one property in the fulltextprops.txt file.
>> >
>> >
>> >
>> > Thanks & brgds
>> > Martin
>> >
>> >
>> > "Chris Ahlers [MSFT]" wrote:
>> >
>> >> Just to make sure, did you run a Full Population after adding the
>> >> additional
>> >> indexed properties?
>> >>
>> >> --Chris
>> >>
>> >> ================================================================================
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >> Use of any included script samples are subject to the terms specified
>> >> at
>> >> http://www.microsoft.com/info/cpyright.htm.
>> >> Please do not send e-mail directly to this alias. This alias is for
>> >> newsgroup purposes only.
>> >> ================================================================================
>> >>
>> >> <nitramsen@nospam.nospam> wrote in message
>> >> news:7DC30F19-159C-49EA-9C64-E64FFDE95FBF@microsoft.com...
>> >> >I have tried to add the the following properties to the Indexer as
>> >> >described in
>> >> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/_exch2k_customizing_full-text_indexing.asp
>> >> >
>> >> > http://schemas.microsoft.com/exchange/keywords-utf8
>> >> > urn:schemas-microsoft-com:office:office#Keywords
>> >> > urn:schemas:mailheader:keywords
>> >> > http://schemas.microsoft.com/mapi/string/{00020329-0000-0000-C000-000000000046}/Keywords
>> >> >
>> >> > And I used to following Query to try to search the indexed property:
>> >> >
>> >> > "<?xml version=\"1.0\"?><D:searchrequest xmlns:D = \"DAV:\" >"
>> >> > + "<D:sql>SELECT
>> >> > \"DAV:displayname\",\"urn:schemas-microsoft-com:office:office#Keywords\",
>> >> > \"http://schemas.microsoft.com/exchange/permanenturl\" FROM \"" +
>> >> > Folder +
>> >> > "\""
>> >> > + "WHERE \"DAV:ishidden\" = false AND
>> >> > \"DAV:isfolder\" = false and
>> >> > FREETEXT(\"http://schemas.microsoft.com/exchange/keywords-utf8\",'VSL')
>> >> > "
>> >> > + "</D:sql></D:searchrequest>"
>> >> >
>> >> > I have tried different combinations of FREETEXT/CONTAINS and
>> >> > property
>> >> > names
>> >> > but I always get 0 results(There should be 1000+) and sometimes
>> >> > depending
>> >> > on
>> >> > the property name Bad request when I use Contains.
>> >> >
>> >> > Did anyone ever manage to index the keyword property and search it?
>> >> >
>> >> > I have checked eventlogs and the GatherLogs and there is no problems
>> >> > to
>> >> > be
>> >> > found anywhere.
>> >> >
>> >> > Is it possible to check that the property as been index?
>> >> >
>> >> > If anyone has any idea I would be pleased to heard it.
>> >> >
>> >> > BRGDS
>> >> > Martin
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>
date: Thu, 2 Mar 2006 13:34:08 -0800
author: Chris Ahlers [MSFT]
|
|
