Hello, I created a page using the wix database. I added everything into the database, and the sandbox information is not lining up with the live part of the database. Its is duplicating information, putting everything in a different order than how I set up the “sort”. What could be causing this? How do I fix it? Also another problem, when I go to add a new item, it only adds as the second line, instead of at the bottom.
I also want new dates to be at the bottom of the database, but they are at the top. Basically, I want things to go by order of the dates… please let me know if this makes any sense.
If you go to the link below, it is duplicating dates, that are not even in the database more than once…
By default we sort items creation date (you’ll notice, that if you come back to the collection after adding item it might have changed its place). But the good thing is that you can choose to view your data in any order you want.
You can click “Sort” and choose by which field you want your results to be ordered. In your case you can choose the Date column. Alternatively, you can choose to click on the right side of the column header and select sort there. This applies to both Sandbox and Live.
However, your date column is created as Text, so results will be sorted in alphabetical order, rather than by actual date.
Also in the database for sandbox and live it is showing properly. See images attached, but when I go to the URL https://www.dericksebastian.com/PastTourDates it is not what is showing in the database. After I sync and publish, and then go to another page and then back into the database, my sort is changed (without us touching it)
I’m having a similar issue. I created a new column with sort numbers, since I want things in a very unique order. However, even though this sort is saved in the sandbox and live, my sort is not showing up on the website.
the sort set in collection view is not propagated to live sites. If you want the sort to be reflected in the site, it needs to be set at the Dataset level (or in case of code - query API).
You can read more about applying sort in Dataset here:
Hello, I am running into a problem on my website. Essentially, on my site I sort my dataset on content manger and in live by title; however, in my code when I refer to the sorted values they are not sorted. Can someone please help me with this. My site is satnactprep.com
Please add your own issue into a new post instead of bumping up an old post. Explain what you are trying to do, what works, and what doesn’t. Also, add any code in a code block as stated in the Forum Guidelines.
