Order Collection By Multiple Fields
I have a requirement that means i have to do some jiggery pokery to output a list of items in a order that means some are "sticky" and others just flow in the order they were posted.
I had this working with a small subset of data, but now that more data is in, i can see that the original solution wont work and i need to do a two column sort to get the "sticky" items to sort first and then the rest after.
I did see a thread from 2 years ago that said multiple sort fields wasn't available at the time but may come in, but can't seem to see any documentation on it if it has. If not i may have to do two database calls and get separate lists and smash them together, but trying to avoid that if possible.