Need to Get Specific data from HubDB

[PrasadKD]

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.

[LPM · Accepted solution]

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

[PrasadKD]

I tried and got the result. Thank you so much

[PrasadKD]

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?

[PamCotton]

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

Thank you.

Pam