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 Avaliação positiva
1 Solução aceita
dannio
Solução
Top colaborador(a) | Parceiro Diamante
Top colaborador(a) | Parceiro Diamante

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

Exibir solução no post original

4 Respostas 4
dannio
Solução
Top colaborador(a) | Parceiro Diamante
Top colaborador(a) | Parceiro Diamante

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 Avaliação positiva
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 Avaliação positiva
PamCotton
Gerente da Comunidade
Gerente da Comunidade

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 Avaliação positiva