Product attribute search

Get A Quote

Search options

Content

This section contains information about different search options that can be used to find entity by attribues.

Multi value

It is possibel to select several values per a filter. In this case selected values will be used with OR logic.

For example, User selects:

  • Brands: Northwind Traders;Proseware
  • Cord length: 3;5

In this case all products with either Northwind Traders or Proseware brands and with 3 or 5 cord lenght will be selected.

Wildcards

Wildcards are supported for both text and number values:

  • Text attribute filter supports the following wildcards: *(any), ?(one), #(numeric), !(not), []range.
    For example, Brand: [A-C]*[!P] (‘Cola’ match, ‘Comp’ isn’t match)
  • Integer and decimal filters support numeric range.
    For example, Cord length: [5-6.75].
    Multi value is supported, Cord length: [5-6.75];[10.1-11]
  • Integer and decimals filters support Not wildcard.
    For example, Cord length: !5
    Outside range is supported, Cord length: ![5-12]

Empty value

Attribute filter supports searching by empty value. In case the empty value is selected in the lookup it will be used to filter products that have the empty value in the attribute. Products that don’t have the attribute assigned won’t be selected. I.e. only products that have the attribute assigned and empty value in this attribute will be selected.

And/Or search

Although the typical search need is an “And” search which works like a drill-down search the “Or” search is also supported. In the below example the “Or” option will give all products of the brans Northwind Traders or products where the cord length is either 4 or 5 irrespective of brand.

Copy

The search result can be copied to clipboard. To copy result just click the copy button on the search pane and then past the value:

The filtered items separated by comma will be copied to the clipboard. This can be used to copy the item list into query ranges for reports, or batch jobs, or as value for another form filters.

The Copy feature is configurable, so User can change the field to copy (by default it is Item number, but it can be changed to any table field), default separator is comma.

The configuration can be found here: Product attribute extension parameters > Search by attributes > select the form > Advanced button:

Category and sub-category search

Parent category often doesn’t contain attributes directly assigned to it, so attribute filters won’t be shown automatically on the search pane when filtering on the parent category.

You can add child category attributes to the search pane manually and filter on attributes from the child category:

  • Lookup the Hierarchy, Category field and select Audio category
  • The grid is refreshed and contains released products from the Audio category. The search pane doesn’t contain any attribute filter. Click the Add (+) button.
  • The Product attributes form opens. The form contains all company attributes. Any attributes can be added to the Selected list. There is a Child attributes view option that filters out all child category attributes. Select one or many needed attributes from child categories and click Add. Let’s select Brand and Cord length attributes and click Ok.
  • The search pane now contains the Brand and Cord length attribute filters.
    Select, for example, the following values in the attribute filters:
    • Brand = Northwind Traders,
    • Cord length = 4 and 5 (the multiselect lookup is supported).

With the help of the Product Attribute Search the ‘4302’ and ‘4303’ items with Northwind Traders brand and 4m or 5m cord length has been found in the USRT company.

Cross hierarchy/category search

If it is required to find products from any hierarchy and any category the attribute filters can be added manually without hierarchy/category specified.

  • Clear the Hiearchy, Category field. The attribute filters disappear from the search pane. The grid is refreshed and contains all released products.
  • Click the Add (+) button to add a new attribute filter. The Product attributes form opens. Filter by Brand. Note that the USRT demo data contains two Brand attributes. Select the one that has the ProvisionedChannelAttributeText attribute type and click Ok.
  • The Brand attribute filter is added to the Released product details form.

Select, for example, the following values in the Brand attribute filter: Fabrikam, Litware (the multiselect lookup is supported).

The found released products separated by comma can be copied to the clipboard by Copy button.