Database Sort

Hi, I have made a database and connected it to a table. All of the columns have come across OK but the items below are in a different order. I have re-sorted them in both the Live and Sandbox and saved this but they are still showing up in a different order on the page itself. I have unlinked and relinked but this hasn’t helped. Any ideas please?

Hi! Just a question: have you added sort on dataset?

Hi Mantas,
Thank you for your reply. Yes I believe I have sorted them on the first column name A-Z in the database. Is a dataset different to the database?
It looks in the correct order in the Dashboard/database/database collections and also in the Site Structure/database/database name/sandbox and live. It comes across in the wrong order on the actual webpage https://www.tts-ltd.co.uk/copy-of-3d-printing-and-testing
You can see it is listed as Beam 8 ,7, 6 and then 3 etc whereas I believe I have asked it to be sorted as Beam 1 to 8
Thanks again.

Ok, yes, sort should be added on dataset, that should solve your issue.
Sorting on database is just a helpful preview tool to see your data in different ways. Where sorting on dataset is more of a functional sort which implies how items will be seen on your live page. I hope this answers your question.

Ah I see. I have got it now thank you. I didn’t realise there was a dataset and a database. All sorted with your help. thank you

Np, glad to help :slight_smile: