Syntax

Smartsite SXML	Copy Code
string this.searchcondition(string sourceName)

Parameters

Name	Data Type	Description
sourceName	String	Name of the source.

Return Value

Data Type	Description
String	String containing the (native) search condition.

Used in

Macro	Description
FacetedSearchQueryBuilder	Builds an SQL query for Faceted Search.

Remarks

The this.searchcondition(sourcename) viper should also be used within the definition of a native query. Based on the fieldnames listed within the wherefields element, this viper will return the appropriate WHERE statement for the search query, e.g.:

SQL	Copy Code
(c.Field1 LIKE ?:searchterm1 OR c.Field2 LIKE ?:searchterm1) AND (c.Field1 LIKE ?:searchterm2 OR c.Field2 LIKE ?:searchterm2)

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

Example

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

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 uses native queries (LIKE statements instead of CONTAINSTABLE, which is used within fulltext indexing scenarios).

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>

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>

SXML

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