I have a “Services” collection, in which most Services are sorted Alphabetically, but a few need to appear at the top. To do this I have a YES/NO Featured field.
Collection sorting is defined as follows;
Only two items, “Hedge trimming” and “Lawn mowing” are featured.
Landscaping WAS featured, but is now switched off.
For some reason, I’m seeing this sort order…
The 2 featured ones appear at the top, alphabetically.
Then “Landscaping” which was featured but is no longer featured, is out of order. Following this, are the rest of the Services in alpha as expected.
My suspicion as to the cause of the BUG is that you may be backing this with a relational database and initializing YES/NO fields to NULL instead of FALSE. If I’m right, if you look at the back-end DB, all Services would be Featured = NULL, except the two Featured ones = TRUE, and “Landscaping” = FALSE.
The visible sort order of “is On first”, in effect is TRUE items, then FALSE items, then NULL items.