You create a Microsoft Office SharePoint Server 2007 Search Center site. The site has a custom tab that restricts users to a Business Data Connector for a Product tracking system.
You need to restrict the data displayed to items from the custom columns named ProductName, ProductNumber, and ProductColor.
What should you do?
A.
Create a scope rule named contentclass in the Products scope for each required column that limits the results to the required items.
B.
Replace the contents of the Selected Columns field in the Search Core Results Web Part with the following XML fragment.
<root xmlns:xsi =”http: //www.w3.org/2001/XMLSchema-instance”>
< SelectColumns >
<Column Name=” ProductName “/>
<Column Name=” ProductNumber “/>
<Column Name=” ProductColor “/>
</ SelectColumns >
</root>
C.
Edit the XSLT style sheet that renders the Search Core results Web Part and add the following XML fragment.
<p class=” srch -Metadata”>
< xsl:call -template name=” DisplayString “>
< xsl:with-param name=” str ” select=” ProductName ” />
< xsl:with-param name=” str ” select=” ProductNumber ” />
< xsl:with-param name=” str ” select=” ProductColor ” />
<
</ xsl:call -template>
</p>
D.
Implement the following SQL query in the field named Fixed Keyword Query in the Search Core results Web Part properties.
SELECT ProductName , ProductNumber , ProductColor FROM scope() WHERE “scope” = ‘Products’