ApexSensei

Drills SOQL queries

Filter with date literals

SOQL date literals (TODAY, NEXT_N_DAYS:30, LAST_N_DAYS:30) are evaluated at query time in the user's time zone.

Your task

Count four tagged Opportunities by close date and created date, using SOQL date literals.

String tag = 'AS-Q314-' + UserInfo.getUserId() + '-' +
    String.valueOf(Datetime.now().getTime());
String stageName = Opportunity.StageName.getDescribe().getPicklistValues()[0].getValue();
List<Opportunity> seeded = new List<Opportunity>();
for (Integer offset : new List<Integer>{ -45, -5, 10, 45 }) {
    seeded.add(new Opportunity(Name = tag + '-' + offset, StageName = stageName,
        CloseDate = Date.today().addDays(offset)));
}
insert seeded;
String tagPattern = tag + '-%';

Requirements

  1. NEXT_N_DAYS:30 and LAST_N_DAYS:30 should be present
  2. CloseDate < TODAY and CreatedDate = TODAY should be present
  3. Name LIKE :tagPattern should be present in each WHERE
  4. Printed line should be built from runtime values
  5. Next 30 days: should be 1
  6. Past due: should be 2
  7. Last 30 days: should be 1
  8. Created today: should be 4

Sign in to open this drill