Help Centre Forum

TOTECS Forums

Is there the ability to filter and show only selected attribute columns within the Product Attribute Values Data Set tab?
Author
Thread

Author Rowan Drew
10th July 2024
A question was asked where within the Connector Data Sets window, within the Attributes section, for the Product Attribute Values tab, is there the ability to filter and show only 2 attribute columns, for example "Brand" and "Wheel" named attributes?

TOTECS Software Development Manager
Comments

Author Rowan Drew

TOTECS Software Development Manager
Yes in the Connector's 1.28.1.0 release, within the Data Sets window, across all data types, a "search operator" option labelled "Is In List" was added. When this option is selected it allows a list of search values to be matched on for the records or columns being targeted. These search values need to be separated by (double bar characters) || and spaces either side of the bar characters.

So within the Dataset's Product Attribute Values tab, if the Filter Column's "search operator" option is set to "Is In List", and the search text box has a value set to "Brand || Wheel", then only attribute columns will display that an attribute name equal to "Brand" or "Wheel". Using this approach you can target many attribute columns or values, for example if the search value is set to "Brand || Wheel || Height || Condition || Length" then it can displays attribute columns that match those 5 attribute names.

Conversely using the "Is Not In List" search operator allows to show all attribute columns excluding the values given, so if the search value is set to "Brand || Wheel", then it will display all attribute columns except for Brand or Wheel attributes.

More information about the search operators and searching within Data Sets can be found at https://www.squizz.com/docs/connector/Data-Sets.html under the heading "Searching Records Within A Data Set"

  Comment has been marked as the answer