Stored Queries

Here you can create new Search Filters that will be available in the product search, see Product Search Page.

UI

Query

Defines the main Solr query.

A Freemarker template can be used to access the specified query parameters and create a Solr query.

Query parameters can be accessed by their name. If a parameter is part of a parameter group, it must be accessed by the groups name: ${groupName.paramName}.

Some query parameters provide additionasl information, see Query Parameters below for more information.

Filter Query

Can be used to restrict the search result, see the Solr documentation for more information.

Filter queries will be cached and in some situations be faster as when used in thwe regular query.

Caution

The default fq is -_nest_path_:* to make sure, that only products and no nested documents will be found. By removing this from the default this will lead to wrong search results.

Right now it is only possible to define one filter query, although Solr allows multiple filter queries.

Field List

Can be used to add additional fields to the search result.

The fields will be displayed in the UI. If an alias is specified for a field, this alias will be the header of the column.

If left empty, a deafult set of fields will be displayed: ProductId / Description, CatalogId, Status

For the syntax see the Solr documentation.

Example values:

SupplierID:supplierId, ManufacturerID:manufacturerId productId
ChangedOn:changedOn, ChangedBy:changedBy
Category:attrValue_string_product_category

Sort

Can be used to sort the search result, see sort parameters.

Example values:

productId desc
score asc

Default Field

pecifies a default field that is used when no field in the query is provided.

E.g. Query=GearFit2 and Default Field=productId will find the product GearFit2.

Most likely this fields won’t be needed bacuase the query should always have the correct fields.

Query Parameters

Type Attribute Value

A special parameter is available in the freemarker template for this parameter type:
${paramName.attribute} can be used to access the attribute and its information, e.g. ${attributeValue.attribute.attributeId}.

Type Classification Group

A special parameter is available in the freemarker template for this parameter type:
${paranName.path} can be used to access the groups path as it willo be stored in the index, see following code example.

AND ({!parent which="*:* -_nest_path_:*"}+classificationGroupAssociation_hierarchyPath:\/${groupCriteria.path})
which results in following Solr query
AND ({!parent which=\"*:* -_nest_path_:*\"}+classificationGroupAssociation_hierarchyPath:\\/CarParts/Brake/BrakePads)