I have the following query -
[SELECT Id, ContactId, LeadId, Status, Priority_c, CampaignId, Lead.Name, Contact.Name, Campaign.Name FROM CampaignMember WHERE CampaignId = :stdController.getRecord().Id ORDER BY Status DESC, Priority_c ASC NULLS LAST limit 1000];
Problem is that the NULLS LAST, does not work! I am getting null results appearing before my ordered results. I am required to have the null values required last so it is looking like I will need to implement my own custom sorting. Or does someone have any other workaround?