[SalesForce] SOQL where clause use 15-character ID

Posting this here just so that anyone else who comes along and missed the spectacular shining gem dropped by Peter Chittum in another question.

https://salesforce.stackexchange.com/a/9570/660

The "case-insensitive" Id is not case-insensitive in and of itself. It is unique case-insensitive.

Could SFDC convert the id using the reverse of the algorithm derived from the last 3 digits of the 18? Yes. But we don't. Not being the person who designed or built them, but just another developer in the field like you, near as I can tell we just drop those characters, meaning if you have code that manipulates any of the alpha characters and changes their case, you will have broken the Id.

I'm so happy to have come across this. Thanks Peter!

Actually, your class has some other errors:

• Account it's not a variable
• Event is not a variable
• dateCompare is always set to true

Also, as Martin pointed out, you can't use a variable from your classe as a filter, since that isn't a field on the object being queried.

What you should do is order the events on your query and show only the ones you need.

Try something like this:

public with sharing class initialMeeting {

  public List<Event> finalList {get;set;}

  public initialMeeting() {

    Map<Id, Date>() meetingDates = new Map<Id, Date();
    for(Account acc : [SELECT Id, Initial_Meeting_Date__c 
                                FROM Account 
                                WHERE Status__c = 'Active Prospect']){
        meetindDates.put(acc.Id, acc.Initial_Meeting_Date__c);
    }

    finalList = new List<Event> ();
    for(Event ev : [SELECT Id, AccountId, Subject, ActivityDate 
                        FROM Event 
                        WHERE type='Meeting'
                        AND AccountId IN :meetingDates.keySet()]{
      if(ev.ActivityDate == meetingDates.get(ev.AccountId) finalList.add(ev);
    }
  }

  public List<Event> getUsersEvents() {
    return finalList;
  }
}

I didn't test this code, so you may have to tweak a little the comparison on the map and the ActivityDate.

Other option would be to order the events on the query and just retrieve the first from each account. Something like this:

List<Event> finalList = new List<Event>();
Set<Id> filteredAccounts = new Set<Id>();
for(Event ev : [SELECT Id, AccountId, Subject, ActivityDate 
                   FROM Event 
                   WHERE type='Meeting'
                   AND AccountId IN (SELECT Id 
                                     FROM Account 
                                     WHERE Status__c = 'Active Prospect')
                   ORDER BY ActivityDate ASC]){
    if(filteredAccounts.add(ev.AccountId)) finalList.add(ev);
}