HubDB Not Equals Filter On Multiple Values

Develop, Build & Integrate CMS Development
1

Hi,

I have a value in a variable that contains comma-separeted values of category names.

What I would like to do is pass this to my HubDB filter query to get back a list of records where those categories are not equal to the data.

Would be the approach of doing this?

{% set categories = "Category1, Category2, Category3" %}
{% set unused_categories = hubdb_table_rows(99999,"name__ne="~categories~"&orderBy=name") %}

Thanks for any help!

2

@Chris-M , @Jake_Lett , @webdew , can any of you offer @SirHubalot some guidance?

3

Hey @SirHubalot

You could use not_like just as you would contains, by passing it a comma separated values:

{% set categories = "Category1, Category2, Category3" %}
{% set cats = 'multiselect__not_like='~categories|join(',')%}
{% set table = hubdb_table_rows(XXXXXX, cats) %}

Hope this get ya going!