Prepares an SXMLDatatable object, based on the input parameters, which should be used as input for the FacetedSearchQueryBuilder macro.

Syntax

Smartsite SXML	Copy Code
<se:facetedsearchprepareinputdata> <se:parameters> <se:parameter name="configurationxml"> </se:parameter> </se:parameters> </se:facetedsearchprepareinputdata>

Parameters

Name	Data Type	Properties	Description
ConditionType	Enum	-	Determines the type of search condition to generate (fulltext or LIKE statement(s)). Enum values: FullText Search condition for fulltext searches. Native Search condition for non-fulltext searches (LIKE statements). ThesaurusRelation Search condition for a thesaurus relation.
ConfigurationXml	XML	IsRequired	Sets the configuration XML.
Connection	String	Trim	Sets the connection used for the Sql query.
ExactTerms	Boolean	-	Sets a value indicating whether to use exact terms or that a wild-card should be appended to each search term.
ExpandWithFormsOf	Boolean	-	Sets a value indicating whether to expand the search term(s) with FORMSOF() statements. Only applicable when ConditionType equals FullText.
Fulltextoverideset	Boolean	-	Sets the fulltext.
Operation	Enum	-	Sets the combine operation. Enum values: OneOrMoreTerms One or more terms must match (OR operation). AllTerms All terms must match (AND operation). ExactPhrase The specified terms must match as a phrase (search terms will be enclosed in double quotation marks). Auto Advanced option which switches automatically to AND or OR when the search terms includes (one of) these operators.
SearchBaseName	String	-	Sets the name of the search base.
SearchGroup	String	-	Sets the search group.
SearchProfile	String	-	Sets the search profile.
SearchTerms	String	-	Sets the search terms.
SearchWithin	String	-	Sets the search within condition.
Sources	Collection	-	Sets the sources.

Shared Parameters

Name	Data Type	Properties	Description
Access	String	-	Friendly name of the minimum access type level required by the site visitor to execute this macro.
AccessDenied	String	RawData	Sets the value that is returned when the site visitor has insufficient access.
AIM	Enum	-	Sets the AIM scanning mode of the macro. Enum values: NotSet Not set. Off No AIM scanning. External Output XML scanning. Internal Internal scanning, implemented by AIM-aware macros. Autonomous Relations are to be linked to the current source item, instead of the rendered page. SoftLink Should generate soft links (in combination with External flag). InternalAutonomous Internal scanning, combined with the Autonomous setting. ExternalAutonomous External scanning, combined with the Autonomous setting. ExternalAutonomousSoftLink External scanning, combined with the Autonomous and softLink settings. ExternalSoftLink External scanning, combined with the Softlink setting.
Condition	String	MustBeAttribute ExpressionSyntax XmlDecode	Sets the Viper expression to evaluate before actually executing the macro. If the expression returns false, the execution of the module and its child modules is skipped.
Default	String	RawData	Sets the default value that will be returned when the execution would otherwise return an empty string.
Error	String	RawData	Sets the value to return in case on error occurs during execution. The Viper expressions this.error(), this.error(full) and this.error(type) are available in this context.
Id	String	MustBeAttribute Trim	Sets the Id of the macro. Macros with Ids set can be accessed using Viper by referring to page.[id].[methodname()].
LocalId	String	MustBeAttribute Trim	Sets the local id of the macro in the current buffer scope.
Rem	String	RawData NoCache Trim	Sets the remarks. Remarks have no effect on the actual execution of the module. They only improve the readability of the code.
ResultFormat	String	RawData	Sets the resultformat.
ResultType	Enum	-	Sets the type of the result. Enum values: Undefined Not set None No result String Default type Object Generic object Binary Binary data Boolean Boolean DataTable DataTable DateTime Date/time Float Floating point numeric data Integer Integer Locator Extended Uri Xml Xml Data
Save	Collection	-	Sets the buffer names.
Status	Enum	-	Gets a value indicating the ModuleStatus of this module. Enum values: Unknown Unknown BeginInitialize Initializing the module EndInitialize Module has fully initialized BeginSetProperties Properties are about to be set EndSetProperties Properties have been set BeginExecute Execution starts BeginFormatData Starting data formatting. EndFormatData Ended data formatting. BeginFormatResult Before formating result. EndFormatResult After formatting result EndExecute Execution is ending StartLoseScope Execution has completed EndLoseScope Module is about to unload Error Module is in an error state
Timeout	Float	-	Sets the timeout in seconds. In the overriden Execute() method, you can call CheckTimeout() to check whether execution has timed out.
Trim	Enum	MustBeAttribute	Gets a value indicating how the whitespace is trimmed.
Whitespace	Enum	MustBeAttribute	Gets a value indicating whether to preserve whitespace. Enum values: Inherit Inherit from parent. Preserve Keep all whitespace. Remove Remove all whitespace. Normalize Convert all whitespace to single spaces. SimpleFormat Convert all whitespace to single spaces, but keep single line breaks.

Local Viper Methods

Viper	Extension	Description
This.ClearForcedResult		Sets the result of the macro. used to override the normal handling of the result creation.
This.GetForcedResult		Gets the forced result of the macro, set by overriding the normal rendering using SetForcedResult().
This.RenderTime	✓	Returns the render time of the macro in milliseconds.
This.SetForcedResult		Sets the result of the macro. used to override the normal handling of the result creation.

Shared Local Viper Methods

Viper	Extension	Description
This.AIM.Relations	✓	Gets a list of all outgoing AIM relations created by the macro.
This.Buffer.Exists		Checks whether a local buffer exists.
This.Buffer.Get		Gets a local buffer.
This.Buffer.Set		Sets a local buffer.
This.Error.InnerException.Message		Returns the text message of the inner exception of the exception that has occurred.
This.Error.InnerException.SmartsiteCode		Returns Smartsite error code of the inner exception of the exception that has occurred.
This.Error.InnerException.Throw		Makes Smartsite throw the inner exception.
This.Error.InnerException.ToString		Returns the full information of the inner exception of the exception that has occurred, including the stack trace.
This.Error.InnerException.Type		Returns the full Type name of the inner exception of the exception that has occurred.
This.Error.Message		Returns the text message of the exception that has occurred.
This.Error.SmartsiteCode		Returns the Smartsite Error code of the exception that has occurred.
This.Error.Throw		Makes Smartsite throw the current exception.
This.Error.ToString		Returns the full information of the exception that has occurred, including the stack trace.
This.Error.Type		Returns the full Type name of the exception that has occurred.
This.FindExtension		Finds an extension macro.
This.GetParameter	✓	Gets the value of the given parameter/property.
This.ParameterExists	✓	Checks whether the given parameter/property is set.
This.Result		Returns the result of the macro. Typically used in the ResultFormat property, to format, convert or encode the result.
This.SXMLPath		Gets the path to the macro in the current execution stack.

Remarks

Example

Faceted Search Complete Example

This is an self-containing example, which uses both Faceted Search macros: facetsearchprepareinputdata and facetedsearchquerybuilder. It is only dependent on an xml item containing configuration/query xml. Furthermore, it uses the sqlquery macro and standard formatting to retrieve and display the search results.

Smartsite SXML	Copy Code
<!-- retrieve configuration/query xml --> {buffer.set(xml, convert.toxml(sxml.decode(itemdata.field('xml',QUERY_XML))))} <!-- use 'content' source --> {buffer.set(sources,'content')} <!-- call prepareinputdata macro to process the search term(s); a datatable will be returned --> <se:facetedsearchprepareinputdata searchterms="viper" operation="auto" configurationxml="{buffer.get(xml)}" resulttype="datatable" sources="{buffer.get(sources)}" save="inputdata" /> <!-- add contenttype filter to the datatable --> {datatable.rows.add($inputdata, 'contenttype', 1)} Input data for the querybuilder: <!-- display the inputdata datatable --> {datatable.simpleformat(inputdata)} <!-- call querybuilder macro to construct SQL query; this macro will also output the sqlparams datatable --> <se:facetedsearchquerybuilder mode="searchquery" save="search_query" sources="{buffer.get(sources)}"> <se:parameters> <se:parameter name="configurationxml">{buffer.get(xml)}</se:parameter> <se:parameter name="tableorview">{channel.view()}</se:parameter> <se:parameter name="outputbuffername">sqlparams</se:parameter> <se:parameter name="facetvalues"> <se:collection inputdata="inputdata" /> </se:parameter> </se:parameters> </se:facetedsearchquerybuilder> <!-- display the query --> Query: {buffer.get(search_query)} <!-- add lowerbound and upperbound to sqlparams for the paging --> {datatable.rows.add($sqlparams, 'lowerbound', 'integer', 1)} {datatable.rows.add($sqlparams, 'upperbound', 'integer', 10)} Input datatable for sqlquery: <!-- display the sqlparams datatable --> {datatable.simpleformat(sqlparams)} {buffer.set(htmlresult,'')} <p>Results: <!-- sqlquery macro to execute the search, using the constructed SQL statement and the sqlparams datatable --> <se:sqlquery sql="{buffer.get(search_query)}" save="results" resulttype="datatable" error="{buffer.set(htmlresult,'Error: '+this.error.message())}"> <se:parameters> <se:parameter name="params"> <se:collection inputdata="sqlparams" /> </se:parameter> </se:parameters> </se:sqlquery> <!-- use standard formatting to display the search result(s) --> <se:format save="htmlresult" inputdata="results" condition="$htmlresult==''" default="No results."> <se:rowformat> <tr> <td>{this.field(nr)}</td> <td>{this.field(title)}</td> </tr> </se:rowformat> <se:resultformat> <table>{this.result()}</table> </se:resultformat> </se:format> {buffer.get(htmlresult)} </p>

Smartsite SXML

Copy Code

<!-- retrieve configuration/query xml -->
{buffer.set(xml, convert.toxml(sxml.decode(itemdata.field('xml',QUERY_XML))))}

<!-- use 'content' source  -->
{buffer.set(sources,'content')}

<!-- call prepareinputdata macro to process the search term(s); a datatable will be returned -->
<se:facetedsearchprepareinputdata
    searchterms="viper"
    operation="auto"
    configurationxml="{buffer.get(xml)}"
    resulttype="datatable"
    sources="{buffer.get(sources)}"
    save="inputdata"
/>

<!-- add contenttype filter to the datatable  -->
{datatable.rows.add($inputdata, 'contenttype', 1)}

Input data for the querybuilder:
<!-- display the inputdata datatable -->
{datatable.simpleformat(inputdata)}

<!-- call querybuilder macro to construct SQL query; this macro will also output the sqlparams datatable -->
<se:facetedsearchquerybuilder mode="searchquery" save="search_query" sources="{buffer.get(sources)}">
    <se:parameters>
        <se:parameter name="configurationxml">{buffer.get(xml)}</se:parameter>
        <se:parameter name="tableorview">{channel.view()}</se:parameter>
        <se:parameter name="outputbuffername">sqlparams</se:parameter>
        <se:parameter name="facetvalues">
            <se:collection inputdata="inputdata" />
        </se:parameter>
    </se:parameters>
</se:facetedsearchquerybuilder>

<!-- display the query -->
Query:
{buffer.get(search_query)}

<!-- add lowerbound and upperbound to sqlparams for the paging -->
{datatable.rows.add($sqlparams, 'lowerbound', 'integer', 1)}
{datatable.rows.add($sqlparams, 'upperbound', 'integer', 10)}

Input datatable for sqlquery:
<!-- display the sqlparams datatable -->
{datatable.simpleformat(sqlparams)}


{buffer.set(htmlresult,'')}
<p>Results:
    <!-- sqlquery macro to execute the search, using the constructed SQL statement and the sqlparams datatable  -->
    <se:sqlquery sql="{buffer.get(search_query)}" save="results" resulttype="datatable" error="{buffer.set(htmlresult,'Error: '+this.error.message())}">
        <se:parameters>
            <se:parameter name="params">
                <se:collection inputdata="sqlparams" />
            </se:parameter>
        </se:parameters>
    </se:sqlquery>
    
    <!-- use standard formatting to display the search result(s) -->
    <se:format save="htmlresult" inputdata="results" condition="$htmlresult==''" default="No results.">
        <se:rowformat>
            <tr>
                <td>{this.field(nr)}</td>
                <td>{this.field(title)}</td>
            </tr>
        </se:rowformat>
        <se:resultformat>
            <table>{this.result()}</table>
        </se:resultformat>
    </se:format>

    {buffer.get(htmlresult)}
</p>

SXML