topic Re: Need to Get Specific data from HubDB in CMS Development

Need to Get Specific data from HubDB

PrasadKD — Tue, 22 Feb 2022 21:28:11 GMT

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.

Re: Need to Get Specific data from HubDB

PamCotton — Tue, 22 Feb 2022 21:52:06 GMT

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

Thank you.

Pam

Re: Need to Get Specific data from HubDB

dannio — Wed, 23 Feb 2022 01:56:30 GMT

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

Re: Need to Get Specific data from HubDB

PrasadKD — Wed, 23 Feb 2022 11:14:21 GMT

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?

Re: Need to Get Specific data from HubDB

PrasadKD — Wed, 23 Feb 2022 13:49:47 GMT

I tried and got the result. Thank you so much