Need to Get Specific data from HubDB

Develop, Build & Integrate CMS Development
, , , , , , , , ,
1

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.

2

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

Thank you.

Pam

3

You can add a not_null condition to the query:

e,g if outputting onto a HS page:

{% for row in hubdb_table_rows(<tableId or name>, '&no1__not_null=&no2__not_null=') %}

{% endfor %}

and just add the condition for every column

4

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?

5

I tried and got the result. Thank you so much