topic Re: Hubl filter to show future hubdb events used in rich text editor in CMS Development

Hubl filter to show future hubdb events used in rich text editor

cives — Tue, 02 Jul 2024 19:15:18 GMT

I'm using some hubl in a rich text editor within global content of my website and am trying to use a filter to show the date next to an event in a mega menu, only if it is in the future.

My current code is:

<h6 style="margin-bottom: 8px; font-size: 14px;">MAJOR EVENTS</h6> {% for row in hubdb_table_rows('14621261', "&orderBy=start_date&type=Major Event") %} <ul style="list-style-type: none; margin: 0; padding: 0;"> <li style="padding-bottom: 3px;"><a style="color: #171b25; margin: 0 15px; font-weight: 500; font-size: var(--fs-amm-menu-sub);" href="{{ row.event_url }}"> {{ row.name }} <strong>{{ row.start_date|datetimeformat('%b %d, %Y') }}</strong></a></li> </ul> {% endfor %}

I've tried

{% if row.start_date__gt=-86400s %} <strong>{{ row.start_date|datetimeformat('%b %d, %Y') }}</strong>{% endif %}

and

{% if row.start_date__gte=unixtimestamp(local_dt) %} <strong>{{ row.start_date|datetimeformat('%b %d, %Y') }}</strong>{% endif %}

Nothing seems to be working. Any guidance is appreciated. Thanks

Re: Hubl filter to show future hubdb events used in rich text editor

SteveHTM — Wed, 03 Jul 2024 14:09:41 GMT

@cives - I don't know if this will apply, but I presonally use the HubL filter 'between_times) to compare dates in a context like this.

As in:

{% set days_left = to_local_time(unixtimestamp()) | between_times( module.webinar_start , 'days') %}

Obviously you can deal with positive and negative values for your purposes.

Steve

Re: Hubl filter to show future hubdb events used in rich text editor

GRajput — Wed, 03 Jul 2024 14:17:39 GMT

Hi @cives

You need to convert your date in UNIX format and then compare that with the current date using a condition.

<h6 style="margin-bottom: 8px; font-size: 14px;">MAJOR EVENTS</h6> <div style="color: #000;"> {% set queryparam = "&orderBy=event_date" %} {% set queryparam = queryparam + "&start_date__gt=" + local_dt|unixtimestamp %} {% set table = hubdb_table_rows('YOUR HUBDB TABLE ID', queryparam) %} {% if table = [] %} <p class="lead">Sorry, no webinars available.</p> {% else %} <ul>{% for row in table %} <li>{{ row.event_name }} <strong>{{ row.event_date|format_date('dd/MMMM,yyy') }}</strong></li> {% endif %} {% endfor %}</ul> {% endif %}</div>

"I hope this will help you out. Please mark it as Solution Accepted and upvote to help another Community member.
Thanks!"

Re: Hubl filter to show future hubdb events used in rich text editor

cives — Wed, 03 Jul 2024 15:50:15 GMT

Thank you both for the response. The issue is that I am building this in a rich text module in my website's theme global content editor. I'm doing this to reference dynamic content in a dropdown menu.

<h6 style="margin-bottom: 8px; font-size: 14px;">MAJOR EVENTS</h6> {% set td = unixtimestamp(today("America/New_York").plusDays(0)) %} {{ td||pprint }} {% for row in hubdb_table_rows('14621261', "&orderBy=start_date&type=Major Event") %} <ul style="list-style-type: none; margin: 0; padding: 0;"> <li style="padding-bottom: 3px;"><a style="color: #171b25; margin: 0 15px; font-weight: 500; font-size: var(--fs-amm-menu-sub);" href="{{ row.event_url }}"> {{ row.name }}{{ unixtimestamp(row.start_date) }} {{ td }} {% if unixtimestamp(row.start_date)__gte="td" %}<strong>{{ row.start_date|datetimeformat('%b %d, %Y') }}</strong>{% endif %}</a></li> </ul> {% endfor %}

The issue is the comparison portion of the if statement, it appears the rich text editor does not like __gte""

gte or >=, the latter of which is escaped to >

{% if unixtimestamp(row.start_date) >= td %}

Is it possible to use operators/expressions in the rich text environment?

Thanks in advance.

Re: Hubl filter to show future hubdb events used in rich text editor

GRajput — Thu, 04 Jul 2024 08:39:06 GMT

Hi @cives

It will work in the rich text module. As you can see I have created a dummy Hubdb table and fetched the data from a rich text module ( source code )and it only displayed the upcoming events.

I hope this will help you out. Please mark it as Solution Accepted and upvote to help another Community member.
Thanks!