Syntax

Smartsite SXML	Copy Code
boolean this.isbasequery()

Parameters

This Viper method does not expose any parameters.

Return Value

Data Type	Description
Boolean	trueif this instance is a base (search) query; otherwise,false.

Used in

Macro	Description
FacetedSearchQueryBuilder	Builds an SQL query for Faceted Search.

Remarks

Resolves to true when the base search query for a specific source is being assembled. Resolves to false when additional search queries (to apply specific weights on physical fields) are assembled, which will be appended to the base search query.

Should be used to restrict expensive weight calculations (such as popularityweight and contenttypeweight) to the base search query only, e.g.:

Smartsite SXML	Copy Code
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()) + ")"))

Smartsite SXML

Copy Code

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()) + ")"))

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