Multi select filter

ben-duchy — Wed, 22 Dec 2021 09:55:14 GMT

Does anyone know how or if its possible to use the 'selectattr' filter for a multi select in HubDB?

For a normal select list I use something like:

{% set housename = house_db | selectattr ("housetype.name","equalto","Buckingham") %}

However I have changed the column type in HubDB to be a multi-select and updating the above filter to the below doesn't work. Does anyone know what I need to do?

{% set development = house_db | selectattr ("housetype.name","contains","Buckingham") %}

Re: Multi select filter

ben-duchy — Wed, 22 Dec 2021 11:42:14 GMT

I've figured it out...

I started by calling in the whole table, then using a secondary loop combined with an if condition manged to filter out the relevant rows.

{% set house_type_db = hubdb_table_rows(1234567) %}

{% for row in house_type_db %} {% for item in row.development %} {% if item.name == "Chapelgarth" %}  {% endif %} {% endfor %} {% endfor %}

topic Multi select filter in CMS Development

Multi select filter

Re: Multi select filter