I am trying to add an ORDER BY
statement in a SOQL query. I am already using the same statement in the WHERE
clause of the query, but am getting an error saving it.
An unexpected error occurred. Please include this ErrorId if you contact support: 973471439-38882 (132416824)
I'm not sure if this is a platform problem or syntax problem. I am thinking it's a platform problem based on this post as I am working out of a Spring 18 sandbox. Oddly, I am able to run the query in that post though.
Query
SELECT Id, StartDate, EndDate, Start_Date_Time__c, End_Date_Time__c, Location__r.BillingStreet, Location__r.BillingCity, Maximum_Participants__c,
Location__r.BillingState, Location__r.BillingPostalCode, Location__r.Name,
(
SELECT Id
FROM CampaignMembers
WHERE Status != 'Cancelled'
)
FROM Campaign
WHERE StartDate >= :req.startDate.date()
AND EndDate <= :req.endDate.date()
AND DISTANCE(Location__r.BillingAddress, GEOLOCATION(:req.lat, :req.lng), 'mi') < :req.miles
AND RecordType.DeveloperName = :SEMINAR_RECORD_TYPE
AND Available__c = true
AND StartDate >= :Date.today()
ORDER BY StartDate ASC, DISTANCE(Location__r.BillingAddress, GEOLOCATION(:req.lat, :req.lng), 'mi') ASC
The lat and long values are coming from the method parameters in a model object.
Model:
public class SearchModel {
public String campaignId;
public Integer miles;
public String zip;
public DateTime startDate;
public DateTime endDate;
public Decimal lat;
public Decimal lng;
public String consultationOrSeminar;
public String productInterest;
}