# Need to Get Specific data from HubDB

**URL:** <https://community.hubspot.com/t/need-to-get-specific-data-from-hubdb/51974>\
**Category:** CMS Development\
**Tags:** design-manager, hubdb, local-development, css, javascript, free, html, professional, starter, enterprise\
**Created:** [February 22, 2022, 7:33pm UTC](https://community.hubspot.com/t/need-to-get-specific-data-from-hubdb/51974 "2022-02-22T19:33:28Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![PrasadKD](https://avatars.discourse-cdn.com/v4/letter/p/ba9def/32.png) [@PrasadKD](https://community.hubspot.com/u/PrasadKD)\
**Post date:** [February 22, 2022, 7:33pm UTC](https://community.hubspot.com/t/need-to-get-specific-data-from-hubdb/51974/1 "2022-02-22T19:33:28Z")

</div>

I know HUBDB basics but I can’t find a solution to this on my own. please help me.

| name | no1 | no2 | no3 | no5 | no6 | no7 |
| --- | --- | --- | --- | --- | --- | --- |
| xxx | 1212 | 12412 | 12522 | 1562 | 2566 | 255 |
| yyy | 5658 | 5688 | 585 | | | |
| zzz | 585959 | 58958 | 58985 | 5985699 | 544455 | |

if you observe the above table, xxx has 7 no’s but yyy have 3no’s.

How to print HUBDB specified columns(in the above example, no’s) only if they are not null for each and every row.

---

<div class="post-metadata">

**Author:** ![PamCotton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/pamcotton/32/47916_2.png) [@PamCotton](https://community.hubspot.com/u/PamCotton)\
**Post date:** [February 22, 2022, 9:52pm UTC](https://community.hubspot.com/t/need-to-get-specific-data-from-hubdb/51974/2 "2022-02-22T21:52:06Z")

</div>

Hello @PrasadKD I would like to invite some top experts to this conversation @dannio @hhawk  
@hilton22 any suggestions to @PrasadKD ?

Thank you.

Pam

---

<div class="post-metadata">

**Author:** ![dannio](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dannio/32/95715_2.png) [@dannio](https://community.hubspot.com/u/dannio)\
**Post date:** [February 23, 2022, 1:56am UTC](https://community.hubspot.com/t/need-to-get-specific-data-from-hubdb/51974/3 "2022-02-23T01:56:30Z")

</div>

You can add a not\_null condition to the query:

e,g if outputting onto a HS page:

```lia-code-sample
{% for row in hubdb_table_rows(<tableId or name>, '&no1 __not_null=&no2__ not_null=') %}

{% endfor %}

```

and just add the condition for every column

---

<div class="post-metadata">

**Author:** ![PrasadKD](https://avatars.discourse-cdn.com/v4/letter/p/ba9def/32.png) [@PrasadKD](https://community.hubspot.com/u/PrasadKD)\
**Post date:** [February 23, 2022, 11:14am UTC](https://community.hubspot.com/t/need-to-get-specific-data-from-hubdb/51974/4 "2022-02-23T11:14:21Z")

</div>

Great But this one works for the whole list page. I am doing profile pages for each one individually., so for every column, I will use something like this **" dynamic\_page\_hubdb\_row.no1".** Can you just tell me how to add the above filter for this?

---

<div class="post-metadata">

**Author:** ![PrasadKD](https://avatars.discourse-cdn.com/v4/letter/p/ba9def/32.png) [@PrasadKD](https://community.hubspot.com/u/PrasadKD)\
**Post date:** [February 23, 2022, 1:49pm UTC](https://community.hubspot.com/t/need-to-get-specific-data-from-hubdb/51974/5 "2022-02-23T13:49:47Z")

</div>

I tried and got the result. Thank you so much