The this.rankingstatement(sourcename) viper should be used within the definition of the (search) query for a source which has been configured to use native queries (that is, LIKE statements).

Based on the fieldnames listed within the wherefields element (required element for native queries!), the this.rankingstatement(sourcename) viper returns a statement which calculates the number of occurrence for each search term within each specified (physical) field, using the Faceted Search database function fn_tsCountWord(), e.g.:

SQL	Copy Code
(dbo.fn_tsCountWord(?:searchterm1,c.Field1)*3 + dbo.fn_tsCountWord(?:searchterm1,c.Field2)*3 + dbo.fn_tsCountWord(?:searchterm2,c.Field1)*1 + dbo.fn_tsCountWord(?:searchterm2,c.Field2)*1)

The sourcename attribute must match with the name attribute of the enclosing source element.

Notice that the function fn_tsCountWord() is a custom function added to the database when installing Faceted Search. When you implement a Faceted Search environment to a database other then the Smartsite database itself and you want to use the this.rankingstatement() implementation, you need this function to that database manually.

Faceted Search Query Xml - SearchBase Query Element Example (Native)

Smartsite SXML	Copy Code
<query><![CDATA[ SELECT c.Nr, ({this.rankingstatement("content")})*100 as SearchRank, 1 AS BaseSearch FROM {this.searchgroupviewname()} c WITH (NOEXPAND) WHERE {this.searchcondition("content")} ]]> </query>