CMS Development

PrasadKD
参加者

Need to Get Specific data from HubDB

解決

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 いいね!
1件の承認済みベストアンサー
LPM
解決策
トップ投稿者 | Diamond Partner
トップ投稿者 | Diamond Partner

Need to Get Specific data from HubDB

解決

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

元の投稿で解決策を見る

4件の返信
LPM
解決策
トップ投稿者 | Diamond Partner
トップ投稿者 | Diamond Partner

Need to Get Specific data from HubDB

解決

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
参加者

Need to Get Specific data from HubDB

解決

I tried and got the result. Thank you so much

0 いいね!
PrasadKD
参加者

Need to Get Specific data from HubDB

解決

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 いいね!
PamCotton
コミュニティーマネージャー
コミュニティーマネージャー

Need to Get Specific data from HubDB

解決

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 いいね!