Syntax

Smartsite SXML	Copy Code
string this.popularityweight(string statement)

Parameters

Name	Data Type	Description
statement	String	The (SQL) statement.

Return Value

Data Type	Description
String

Used in

Macro	Description
FacetedSearchQueryBuilder	Builds an SQL query for Faceted Search.

Remarks

More popular items (based on the number of page requests) can be given a higher search rank using this local instance viper. In the example query xml a logarithmic scale is being used to calculate a popularity weight factor, which is multiplied with the popularity-weight value as defined within the query xml.

The database logic calculating the weight factor must be provided to this viper as argument:

Smartsite SXML	Copy Code
this.popularityweight("LOG(ISNULL(pr.visits,1))/LOG(" + sys.eval(maxvisits(), smartlet.number()) + ")")

(assuming a LEFT JOIN on the table PageRequests have been added as well, using alias "pr"; also using the translation maxvisits() to determine the maximum number of visits using a 30 minute cache period.)

Example

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

The Faceted Search Query Builder macro (se:facetedsearchquerybuilder) contains a lot of local instance vipers. Usually, local instance vipers are used within the macro itself, e.g. formatting, but in this case the local instance vipers should only be used within a query xml definition.

This example shows a searchbase query element from a query xml definition in which some of the available local instance vipers are used. The example here is only applicable for a fulltext indexing scenario.

Smartsite SXML	Copy Code
<query><![CDATA[ SELECT [KEY] AS Nr, (RANK {sys.iif(this.isbasequery(), "+" + this.seopriority("c.seopriority") + "+" + this.contenttypeweight("c.contenttype_weight") + "+" + this.popularityweight("LOG(ISNULL(pr.visits,1))/LOG(" + sys.eval(maxvisits(), smartlet.number()) + ")"))}) * {this.fieldweight("dbo.fn_tsAgeInDays(c.moddate)", default="c."+this.fieldname()+"_weight")} AS SearchRank, {sys.iif(this.isbasequery() \|\| this.mode()!=SearchQuery, '1', 'NULL')} AS BaseSearch FROM CONTAINSTABLE({this.searchgroupviewname()}, {this.fieldname(default="(QueryData,CTSpecificBinary1)")}, ?:searchterm) JOIN {this.searchgroupviewname()} c WITH (NOEXPAND) ON [KEY]=c.Nr {sys.iif(this.isbasequery(), "LEFT JOIN PageRequests pr ON c.Nr=pr.Nr")} ]]> </query>

Smartsite SXML

Copy Code

<query><![CDATA[
    SELECT [KEY] AS Nr, (RANK {sys.iif(this.isbasequery(),
        "+" + this.seopriority("c.seopriority") +
        "+" + this.contenttypeweight("c.contenttype_weight") +
        "+" + this.popularityweight("LOG(ISNULL(pr.visits,1))/LOG(" + sys.eval(maxvisits(), smartlet.number()) + ")"))})
     * {this.fieldweight("dbo.fn_tsAgeInDays(c.moddate)", default="c."+this.fieldname()+"_weight")} AS SearchRank, 
     {sys.iif(this.isbasequery() || this.mode()!=SearchQuery, '1', 'NULL')} AS BaseSearch 
    FROM CONTAINSTABLE({this.searchgroupviewname()}, {this.fieldname(default="(QueryData,CTSpecificBinary1)")}, ?:searchterm)
    JOIN {this.searchgroupviewname()} c WITH (NOEXPAND) ON [KEY]=c.Nr
    {sys.iif(this.isbasequery(),
         "LEFT JOIN PageRequests pr ON c.Nr=pr.Nr")}
    ]]>
</query>

SXML

Macro
Macro Parameters
Macro Parameter Properties
Vipers
- Global Viper Methods
- Local Viper Methods
SXML Data Types
Examples
Tips & Tricks