Graphql how to filter on hubdb select column

TDwebdev — Wed, 21 Dec 2022 12:25:51 GMT

Hi,

I want to filter on hubdb select column: product and onderwerp:

And because it is a select column do i have to put this: $product.value ?

If i dont use a variable and place hardcoded a value the filter works. But i want it based on a hubdb multi select column.

Code:

# label: "Downloads listing" # description: "Query that retrieves and filters downloads in different ways. When filtering by company we need to find the company first and then fetch its associated downloads. We use the directives and @include to control which query will run. The last two queries fetch the values we use for generating the filtering options in the UI." # $offset: {{ request.query_dict.offset || 0 }} # $limit: {{ (module.cards_per_row * module.rows_per_page) || 5 }} # $product: {{ request.query_dict.product || '' }} # $onderwerp: {{ request.query_dict.onderwerp || '' }} query downloads_listing( $offset: Int, $limit: Int, $product_name: [HS_Enum], $onderwerp_text: [HS_Enum] ) { HUBDB { # Gets vacatures when there is either no filtering, or we're filtering by location and/or department. downloads_filter: downloads_collection(limit: $limit, offset: $offset, filter: {product__eq: $product, onderwerp__eq: $onderwerp}) { items { name url } hasMore limit offset total } downloads_dropdown_values: downloads_collection { items { product onderwerp datum } } } }

Re: Graphql how to filter on hubdb select column

TitiCuisset — Tue, 03 Jan 2023 13:27:37 GMT

Hi @TDwebdev

Thank you for reaching out.

I want to tag some of our experts here - @Kevin-C @Indra @miljkovicmisa @Anton do you have any thoughts for @TDwebdev on this?

Thank you!

Best

Tiphaine

topic Graphql how to filter on hubdb select column in CMS Development

Graphql how to filter on hubdb select column

Re: Graphql how to filter on hubdb select column