<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Show number of matching rows as a number in CMS Development</title>
    <link>https://community.hubspot.com/t5/CMS-Development/Show-number-of-matching-rows-as-a-number/m-p/425076#M22195</link>
    <description>&lt;P&gt;&lt;SPAN&gt;Apologies if this has been asked already, but I cannot find any information that can help me solve this.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;I am building a custom website module that references the rows within HubDB. It will display how many rows meet a set criteria such as the location (example below).&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;{% set no_sites = table | selectattr ("&lt;A href="http://site.name/" target="_blank" rel="noopener"&gt;site.name&lt;/A&gt;","equalto","Bowgreave") | length %} &lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Number of Sites located in Bowgreave = &lt;STRONG&gt;{{ no_sites }}&lt;/STRONG&gt; &amp;lt;!-- correctly shows 44 --&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Since the above worked, I decided to use it as a guide and instead tried using a date column to see how many meetings are on a specific date, but unfortunately it didn't work! (see below)&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;{% set no_dates = table | selectattr ("close_date | datetimeformat('%e/%m/%Y')","equalto","28/05/2021") | length %}&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Show number of meetings with this date = &lt;STRONG&gt;{{ no_dates }} &lt;/STRONG&gt;&amp;lt;!--Should show 10 --&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Placing the date inside a text field within HubDB and removing the datetimeformat from the above code seemed to work, but the moment it's placed within a date field and using the above datetime code, nothing displays! I assume I've not coded it correctly to compensate for this field type, but as yet I'm unable to figure it out. Does anyone know what I'm doing wrong?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Thanks in advance.&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Tue, 06 Apr 2021 14:30:22 GMT</pubDate>
    <dc:creator>ben-duchy</dc:creator>
    <dc:date>2021-04-06T14:30:22Z</dc:date>
  </channel>
</rss>

