Guest
|
 Posted:
Wed Oct 26, 2005 12:51 am Post subject:
Unusual search results using search web service using MATCHE |
|
|
Hi,
Using SPS 2003 and the search service. The query uses a MATCHES
predicate to search against a custom html meta tag (string data type),
and when executed no results are found. However adding to the where
clause something like ' and "DAV:getcontentlength" > 0' causes the
search to find the expected results. The unusual thing is that all
content in the portal should have a size greater than zero, so this
part of the where clause doesn't really add any value, in fact it seems
to make the query take a lot longer. Futhermore, if the CONTAINS
predicate is used instead of the MATCHES predicate (w/o the
"DAV:getcontentlength") some results are received. Is there something
wrong with the MATCHES predicate?
Examples queries:
(0 results) select "DAV:href",
"urn:schemas.microsoft.com:fulltextqueryinfo:DESCRIPTION" from
MYINDEX..Scope() where
MATCHES("urn:schemas.microsoft.com:htmlinfo:metainfo:CUSTOMCOLUMN",'*anderson*')
(some results) select "DAV:href",
"urn:schemas.microsoft.com:fulltextqueryinfo:DESCRIPTION" from
MYINDEX..Scope() where
MATCHES("urn:schemas.microsoft.com:htmlinfo:metainfo:CUSTOMCOLUMN",'*anderson*')
and "DAV:getcontentlength" > 0
TIA |
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in