selectattr filter questions

解決
Highlighted
常連投稿者

I have the following code to filter rows in a DB table:

{% set table = hubdb_table_rows(1040830, queryparam) %}

After those rows are returned I have the following code to further list the results:

 

 

{% set easi_set_buildings = table|selectattr('catid','equalto','eset-std') %}

{% if easi_set_buildings == [] %}
    <!-- Do Nothing -->
{% else %}
    <h3>Headline</h3>
    {% for row in easi_set_buildings %}
        Do Stuff
    {% endfor %}
{% endif %}

This is working fine.

 

Here are my questions.

1. I tried using the following:

{% set easi_set_buildings = table|selectattr('catid','containing','eset-std') %}

and nothing happened.

Can I use the selectattr filter when referencing a multi select column (or a column that contains multiple values)?

 

2. Can I apply multiple "requests" to the selectattr filter... like:

{% set easi_set_buildings = table|selectattr('catid','equalto','eset-std' AND 'subcatid','containing','blah') %}

Any help is greatly appreciated.

 

Thanks!

 

返信
0 賛成の数
承認済みベストアンサー

受理された解決策
アドバイザー

@jestlinbaum my bad.

Had copied only a part from the link スマイリー ハッピー

 

Here's the complete one

 

If this shouldn't work - search for "HubDB filtering by custom module" by "Anton"(me) in this board. スマイリー ハッピー

 

 

Please let me know, if this works for you

 

 

 

regards

Anton








check Did my post help answer your query? Help the Community by marking it as a solution
4件の返信4
アドバイザー

Hi @jestlinbaum ,

have you tried to concatenate the both options?

 

I've had a project last year where I had to concatenate multiple HubDB column entries to one filter... the concatenate operator did it's job スマイリー ハッピー

 

You can find the thread here

 

 

 

 

 








check Did my post help answer your query? Help the Community by marking it as a solution
返信
0 賛成の数
常連投稿者

@Anton  thanks for the response!

The link you left gives me this:

 

"The page you are trying to access was not found. Please check your URL for typos and try again."

 

Would love to see it. 

Are you referring to the Join filter?

 

Thanks again.

返信
0 賛成の数
アドバイザー

@jestlinbaum my bad.

Had copied only a part from the link スマイリー ハッピー

 

Here's the complete one

 

If this shouldn't work - search for "HubDB filtering by custom module" by "Anton"(me) in this board. スマイリー ハッピー

 

 

Please let me know, if this works for you

 

 

 

regards

Anton








check Did my post help answer your query? Help the Community by marking it as a solution
常連投稿者

@Anton  yes, I think this is what I'm looking for.

 

Thank you so much!

返信
0 賛成の数