I have a list of news articles currently ordered by published date. I want to introduce a way of promoting an article to the top of the list for a few days.
I have created a new checkbox metadata field called “Promote”.
I want to change the sort order to metadata “Promote” first, then “published date” second.
If I change the default sorting order to “Promote” it just seems to randomize the results.
Any help getting this fixed would be hugely appreciated.