HubDB rearrange order

[Rahel]

Hi

We gathered our team members in a HubDB and have them displayed on our website. We would like to rearrange the order, e.g. make it alphabetical or change it from time to time. 

Is there a possibility? 

Thanks, Rahel

[DBoroi5]

When I use Rearrange Beta @wspiro the listing reverts back to original order on publish and refresh. 

[wspiro]

Hi @DBoroi5,

When you say the listing reverts, are you referring to the actual listing of content on your website? Or the order as set within the table. 

If the manual listing is not taking effect on your website, make sure your HubL query for the rows does not include an orderBy or sort query. The manual sort you set in a table only applies if the data is not otherwise sorted in another way in your code. 

If the table itself is not retaining the manually set order, that sounds like it might be a bug. To confirm, you are manually dragging and dropping rows, not using the related column sorting BETA (click on column headers) which does not impact display order. Column sorting is meant to be temporary to help you manage your data, manual row reordering is designed to persist. 

If this does not help, please send me a DM with links and some more details and we can take a look. Thanks

[Deepika9041]

Hey

I am not able to drag the row as there is no drag arrow appears also not able to select the row, please tell me how to drag the row is there any other method for dragging or there is any other method for shuffling of rows?

[wspiro]

@Deepika9041 please see my instructions in this post for how to opt your account into this BETA: https://community.hubspot.com/t5/HubSpot-Ideas/HubDB-rearrange-order/idc-p/684632/highlight/true#M12...

If you have any issues, please DM me your account ID and I can opt the account in. 

[olokke]

Hi @wspiro ,

I have the same issue as @DBoroi5 above. After rearranging rows in HubDb, it reverts back to the original order after publish or refresh of the page. 

Any solution to this issue?

Thanks

[wspiro]

Hi @olokke, thanks for reaching out. I will need you to answer the same questions I asked above to help troubleshoot. 

When you say the listing reverts, are you referring to the actual listing of content on your website? Or the order as set within the table.

If the manual listing is not taking effect on your website, make sure your HubL query for the rows does not include an orderBy or sort query. The manual sort you set in a table only applies if the data is not otherwise sorted in another way in your code.

If the table itself is not retaining the manually set order, that sounds like it might be a bug. To confirm, you are manually dragging and dropping rows, not using the related column sorting functionality (click on column headers) which does not impact display order. Column sorting is meant to be temporary to help you manage your data, manual row reordering is designed to persist.

If this does not help, please send me a DM with links and some more details and we can take a look. Thanks