topic Re: How to combine the hubdb and selection field in CMS Development

How to combine the hubdb and selection field

Raghavendra — Mon, 20 Mar 2023 10:30:42 GMT

in the below code in the place of Athletics i need to add selection field or choice field, but it is showing syntax error

<div class="sporteng-acs-outer">
<div class="pagecenter">
<div class="sporteng-acs-inner">
<div class="sporteng-acs-heading">
<h2>
{{ module.case_studies_heading }}
</h2>
</div>
{% set case_data = hubdb_table_rows(module.hubdbtable_field, 'sport_filter=Athletics&limit=3') %}
<div class="sporteng-acs-cards">
{% for data in case_data %}
<div class="sporteng-acs-repeater">
<div class="sporteng-acs-repeater-image" style="background:url('{{ data.sport_image.url }}');">

</div>
<div class="sporteng-acs-repeater-text-section">
<div class="sporteng-acs-repeater-title">
<h3>
{{ data.title }}
</h3>
</div>
<div class="sporteng-acs-repeater-overview">
{{ data.description }}
</div>
<div class="sporteng-acs-repeater-readmore">
<a href="{{ data.page_link }}">
Read more >>>
</a>
</div>
</div>
</div>
{% endfor %}
</div>
</div>
</div>
</div>

Re: How to combine the hubdb and selection field

piersg — Mon, 20 Mar 2023 17:40:19 GMT

Like so:

{% set queryparam = '&sport_filter__in=' ~ module.sport_type ~ '&limit=3' %} {% set case_data = hubdb_table_rows(module.hubdbtable_field, queryparam) %}

Where module.sport_type is the id of your selection field. Use capitalize filter e.g. "module.sport_type|capitalize" if you're not ensuring the values of the selection field are written in sentence case so they match the values from your HubDB.

Re: How to combine the hubdb and selection field

AM23 — Tue, 21 Mar 2023 05:10:00 GMT

Thank you its working..😊

Re: How to combine the hubdb and selection field

AM23 — Tue, 21 Mar 2023 08:11:34 GMT

but it is not working for all data it is case sensitive.

Re: How to combine the hubdb and selection field

piersg — Tue, 21 Mar 2023 09:36:20 GMT

Yes, it is case sensitive

Re: How to combine the hubdb and selection field

AM23 — Tue, 21 Mar 2023 09:40:05 GMT

but in html how to make it incase sensitive

Re: How to combine the hubdb and selection field

piersg — Tue, 21 Mar 2023 14:30:48 GMT

You have to match your HubL output with the HubDB values. So if all your values are first letter capitalised only e.g. "Athletics" or "High jump" (sentence case), then do

module.sport_type|capitalize

Depends how you've written your values in the HubDB.

Re: How to combine the hubdb and selection field

AM23 — Mon, 27 Mar 2023 04:10:46 GMT

in some row the first 3 letter is in capital in that condition it is not working.

Re: How to combine the hubdb and selection field

AM23 — Mon, 27 Mar 2023 09:21:28 GMT

is it works only for capitalize, it is not working for upper or lower case

Re: How to combine the hubdb and selection field

piersg — Mon, 27 Mar 2023 09:24:19 GMT

Just match the values of the choice field in your custom module to the values in the HubDB, so specifically set the value to be "AFL" and it should work.

Re: How to combine the hubdb and selection field

piersg — Mon, 27 Mar 2023 09:32:12 GMT

Then make the value of the "AFL" in the choice field "Afl" (the label can still be "AFL").

Re: How to combine the hubdb and selection field

AM23 — Mon, 27 Mar 2023 09:37:35 GMT

for Heigh lighted it is not working. and replace is also not working for & and ()

Re: How to combine the hubdb and selection field

AM23 — Mon, 27 Mar 2023 09:47:21 GMT

{% set queryparam = '&sport_filter=' ~ module.choice_field|capitalize|replace('_',' ')|replace('&','') ~ '&limit=3' %}
{% set case_data = hubdb_table_rows(module.hubdbtable_field, queryparam) %}