CMS Development

PrasadKD
Participante

Need to Get Specific data from HubDB

resolver

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 Me gusta
1 Soluciones aceptada
dannio
Solución
Colaborador líder | Partner nivel Diamond
Colaborador líder | Partner nivel Diamond

Need to Get Specific data from HubDB

resolver

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

Ver la solución en mensaje original publicado

4 Respuestas 4
dannio
Solución
Colaborador líder | Partner nivel Diamond
Colaborador líder | Partner nivel Diamond

Need to Get Specific data from HubDB

resolver

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
Participante

Need to Get Specific data from HubDB

resolver

I tried and got the result. Thank you so much

0 Me gusta
PrasadKD
Participante

Need to Get Specific data from HubDB

resolver

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 Me gusta
PamCotton
Administrador de la comunidad
Administrador de la comunidad

Need to Get Specific data from HubDB

resolver

Hello @PrasadKD  I would like to invite some top experts to this conversation @dannio @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 Me gusta