C
cindy
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"
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"