I am sorting a custom collection by a text field EAV attribute (UMC was originally used to scaffold the module which has been heavily modified since).
my_name in this case often has the same value for many entries. Consider a collection of dogs. Many entries would have
labrador as a value for
breed field. There are many possible fields so keeping them enumerated in a
<select> list would be cumbersome, I'd rather keep them as a text field (with my own validation so that
labrador isn't mistaken as
labredor or something).
The problem is that my returned results will randomly order the
my_name field so that any entries with the same value will be clustered together but will be listed in a different order every time. How can I make sure this ordered collection is the same each time?