How to sort the hubdb data, if hubdb table particular column is checked

Raghavendra — Fri, 31 Mar 2023 07:52:10 GMT

<div id="applynow" class="GrowingTeamOuterWrapper" style="background-color:{{ module.style.background_color.color }};padding: {{ module.style.padding_top }}px 0px {{ module.style.padding_bottom }}px;">
<div class="page-center">
<div class="GrowingTeamHeading">
<h2 style="color:{{ module.style.heading_color.color }};">{{ module.heading }}</h2>
<p style="color:{{ module.style.content_color.color }};">{{ module.content }}</p>
</div>
{% set table_headline = hubdb_table_column(module.hubdbtable_field, "region_v2").options %}
<div class="FilterColumn">
<select>
<option value="all">Filter by region</option>
{% for varName in table_headline %}
{% set region = varName.name %}
<option value="{{ region }}">{{ region }}</option>
{% endfor %}
</select>
<div class="pagination-container"></div>
</div>
{% set table_toget_col = hubdb_table_rows(module.hubdbtable_field) %}
<div class="GrowingTeamInnerWrapper">
{% for row_toget_col in table_toget_col %}
{% if (row_toget_col['close_date'] >= unixtimestamp(local_dt))%}
<div class="GrowingTeamCol {% for row_multi in row_toget_col.region_v2 %} {{ row_multi.name|replace(' ', '-')|replace('/', '-')|replace('---', '-') }} {% endfor %}">
<div class="LabelCol">
<p>{% for row_multi in row_toget_col.region_v2 %} {{ row_multi.name }}{% if not loop.last %}, {% endif %} {% endfor %}</p>
</div>
<div class="HeadingWrapper">
<h2>{{ row_toget_col.job_title }}</h2>
</div>
<div class="DetailsWrapper">
<ul>
<li><img src="https://fs.hubspotusercontent00.net/hubfs/5217051/IQGeo-2021/Careers-Page/Icon%20feather-map-pin.svg"> {% for row_loc in row_toget_col.location %} {{ row_loc.name }} {% endfor %}</li>
<li><img src="https://fs.hubspotusercontent00.net/hubfs/5217051/IQGeo-2021/Careers-Page/Icon%20metro-calendar.svg"> Apply by: {{ row_toget_col.close_date|datetimeformat('%B %d %Y') }}</li>
</ul>
</div>
<div class="DescriptionWrapper">
<p>{{ row_toget_col.short_description }}</p>
</div>
<div class="BtnWrapper">
<a href="{{ row_toget_col.job_description_link }}">Find out more</a>
</div>
</div>
{% endif %}
{% endfor %}
</div>
<div class="pagination-container"></div>
</div>
</div>

the checked column data should display first, rest data should display last

Re: How to sort the hubdb data, if hubdb table particular column is checked

PamCotton — Fri, 07 Apr 2023 14:59:36 GMT

Hello @Raghavendra, thank you for posting in our Community!

I want to invite our top experts to share their thoughts @Brownstephen101 @miljkovicmisa @stefen any recommendations for @Raghavendra?

Thank you,

Pam

Re: How to sort the hubdb data, if hubdb table particular column is checked

stefen — Mon, 10 Apr 2023 13:49:09 GMT

@PamCotton @Raghavendra you can use the following argument in your table rows function:

{% set table_toget_col = hubdb_table_rows(module.hubdbtable_field, "&orderBy=the_column_name_with_checkmarks") %}

If you want the order reversed you can add a - symbol right before the column name like so:

{% set table_toget_col = hubdb_table_rows(module.hubdbtable_field, "&orderBy=-the_column_name_with_checkmarks") %}

Re: How to sort the hubdb data, if hubdb table particular column is checked

Raghavendra — Tue, 11 Apr 2023 12:13:00 GMT

thanks it is working its my mistake..😊

topic How to sort the hubdb data, if hubdb table particular column is checked in CMS Development

How to sort the hubdb data, if hubdb table particular column is checked

Re: How to sort the hubdb data, if hubdb table particular column is checked

Re: How to sort the hubdb data, if hubdb table particular column is checked

Re: How to sort the hubdb data, if hubdb table particular column is checked