HuBdb Specify Specific Select Label

Developer Support CMS Development
1

Hi
I am looking to be able to specify one of the select dropdown labels within the query. My code is:

{% if dynamic_page_hubdb_row.business_outcomes.label %}
{% set row = hubdb_table_row(121356853, 191295276975) %}
{% endif %}

The business outcomes select dropdown has 4 items. I would like to be able to set up the code so that I can specify the label. For example:

{% if dynamic_page_hubdb_row.business_outcomes.<label_name1> %}
{% set row = hubdb_table_row(121356853, 191295276975) %}
{% elif dynamic_page_hubdb_row.business_outcomes.<label_name2> %}
{% set row = hubdb_table_row(121356853, 191349738266) %}
{% elif dynamic_page_hubdb_row.business_outcomes.<label_name3> %}
{% set row = hubdb_table_row(121356853, 191349738222) %}
{% elif dynamic_page_hubdb_row.business_outcomes.<label_name4> %}
{% set row = hubdb_table_row(121356853, 1913497382149) %}
{% endif %}

Thanks

2

Hi Woodsy,

You’re on the right track, but HubL doesn’t let you use dynamic property names like
‎`dynamic_page_hubdb_row.business_outcomes.<label_name>`.

Instead, you’ll want to check the label or value as a string.

Here’s how you can do it:

{% if outcome_label == "Label 1" %}
 {% set row = hubdb_table_row(121356853, 191295276975) %}
{% elif outcome_label == "Label 2" %}
 {% set row = hubdb_table_row(121356853, 191349738266) %}
{% elif outcome_label == "Label 3" %}
 {% set row = hubdb_table_row(121356853, 191349738222) %}
{% elif outcome_label == "Label 4" %}
 {% set row = hubdb_table_row(121356853, 1913497382149) %}
{% endif %}

Just swap out “Label 1”, “Label 2”, etc. for your actual select option labels from HubDB.