CMS Development

PrasadKD
Participant

Need to Get Specific data from HubDB

SOLVE

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.

0 Upvotes
1 Accepted solution
LPM
Solution
Top Contributor | Diamond Partner
Top Contributor | Diamond Partner

Need to Get Specific data from HubDB

SOLVE

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

View solution in original post

4 Replies 4
LPM
Solution
Top Contributor | Diamond Partner
Top Contributor | Diamond Partner

Need to Get Specific data from HubDB

SOLVE

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
Participant

Need to Get Specific data from HubDB

SOLVE

I tried and got the result. Thank you so much

0 Upvotes
PrasadKD
Participant

Need to Get Specific data from HubDB

SOLVE

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?

 

0 Upvotes
PamCotton
Community Manager
Community Manager

Need to Get Specific data from HubDB

SOLVE

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

 

Thank you.

Pam

Você sabia que a Comunidade está disponível em outros idiomas?
Participe de conversas regionais, alterando suas configurações de idioma !


Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !




0 Upvotes