topic HubDB Not Equals Filter On Multiple Values in CMS Development

HubDB Not Equals Filter On Multiple Values

SirHubalot — Tue, 18 May 2021 16:43:58 GMT

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!

Re: HubDB Not Equals Filter On Multiple Values

dennisedson — Wed, 19 May 2021 15:40:42 GMT

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

Re: HubDB Not Equals Filter On Multiple Values

Kevin-C — Thu, 20 May 2021 22:15:51 GMT

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!