# How to display posts from HublDb?

**URL:** <https://community.hubspot.com/t/how-to-display-posts-from-hubldb/46404>\
**Category:** CMS Development\
**Tags:** hubdb, professional\
**Created:** [November 3, 2021, 2:26pm UTC](https://community.hubspot.com/t/how-to-display-posts-from-hubldb/46404 "2021-11-03T14:26:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Agile-Developer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/agile-developer/32/79091_2.png) [@Agile-Developer](https://community.hubspot.com/u/Agile-Developer)\
**Post date:** [November 3, 2021, 2:26pm UTC](https://community.hubspot.com/t/how-to-display-posts-from-hubldb/46404/1 "2021-11-03T14:26:32Z")

</div>

How to display blog posts from HublDB? you need to filter by column in table by category (id: 4). There is an output of messages (below is an example) it displays the latest messages) How to make output with a filter by an exact match with a category column?

```lia-code-sample
<!-- module html -->

{% set tableRows = hubdb_table_rows(module.table_id, 'limit=3&orderBy=-hs_created_at') %}

<div class="wrapper">
 <div class="heading"><span>Recent Blog</span> Articles</div>
 <div class="content">
 {% for row in tableRows %} {% set post = content_by_id(row['post_id']) %}
 <a href="{{ post.absolute_url }}" class="blog-post" target="_blank">
 <div class="post-img-wrapper">
 <img src="{{ post.featured_image }}" />
 <div class="content-type hidden">
 <img
 src="{{ module.content_type[row['content_type'].name|lower].src }}"
 />
 </div>
 </div>
 <div class="tags">
 <div class="tag-industry" data-type="{{ row['industry'].name|lower|replace(" ", "") }}">
 {{ row['industry'].name }}
 </div>
 {% for value in row['category'] %}
 <div class="tag-category" data-type="{{ value.name|lower|replace(" ", "") }}">
 {{ value.name }}
 </div>
 {% endfor %}
 </div>
 <div class="title">
 {{ post.name }}
 </div>
 <div class="details">
 <div class="publish-date">
 {{ post.publish_date_local_time|datetimeformat('%B %e, %Y') }}
 </div>
 <div class="author">
 {{ post.blog_author }}
 </div>
 </div>
 <div class="summary">
 <span>
 {{ post.post_summary|striptags }}
 </span>
 </div>
 </a>
 {% endfor %}
 </div>
</div>

```

---

<div class="post-metadata">

**Author:** ![Oezcan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/oezcan/32/53959_2.png) [@Oezcan](https://community.hubspot.com/u/Oezcan)\
**Post date:** [November 3, 2021, 3:09pm UTC](https://community.hubspot.com/t/how-to-display-posts-from-hubldb/46404/2 "2021-11-03T15:09:24Z")

</div>

Hello @Agile-Developer ,  
first of all, HubDB is completly different function than HubSpotBlog.  
In order to filter your HubDB rows by options from HubDB select option check real estate [tutorial](https://designers.hubspot.com/docs/tutorials/how-to-build-a-real-estate-listing-with-hubdb).

best regards

Özcan