I have an aggregate query on the Lead object. The query returns a list of Leads grouped by website (custom field) in a specific order based on a MAX of a date attribute.
Say once we iterate through the List, the ordered list of websites is ["websiteB", "websiteF", "websiteA"].
What if I want to re-query against the Lead object, and order the leads by this list of websites?
In mySQL, I could do an ORDER BY FIELD(..., ..., ..), or perhaps a case-when (see here: https://stackoverflow.com/questions/1244028/sql-order-by-list-of-strings). Any ideas in SOQL?