Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sql Syntax Query missing managed metadata in select

0 views
Skip to first unread message

cindy

unread,
Nov 29, 2009, 12:21:01 PM11/29/09
to
I am using a custom search page to query WSS 3.0 and Search Server Express
2008.
I have a scope defined in sql syntax query below
I have 2 managed metadata properties in the select statement
One of the managed metadata is used in the where clause

The query accepts a value for ProductXRVL in where clause and filters
correctly
But the select statement only returns LibraryDocType

Both ProductXRVL and LibraryDocType are set up to be used in scopes
LibraryDocType is a single string text value
ProductXRVL is mapped to a site column that is a choice (checkbox).

The sql syntax does not error it just does not return the value in the
ProductXRVL I know there is a value and the the value is being filtered on
but not returned

"select Filename, LibraryDocType, ProductXRVL from scope() WHERE
\"scope\"='XR VL Library' AND CONTAINS (ProductXRVL,'Infinix-i') ORDER By
RANK DESC"


--
cindy

0 new messages