Development questions
Write a SOQL query to fetch all Opportunities created in the Last 30 Days whose StageName is not Closed Lost.
Combine the LAST_N_DAYS date literal with a stage filter.
soql
SELECT Id, Name, StageName, CreatedDate FROM Opportunity
WHERE CreatedDate = LAST_N_DAYS:30 AND StageName != 'Closed Lost'
Date literals avoid hardcoded dates, so the query stays valid every day.
soqlscenariodate-literals
More Development questions
- What is an Apex Trigger in Salesforce and when should you use it over Flows?
- What is the difference between before triggers and after triggers?
- Explain all Trigger context variables (isInsert, isUpdate, isDelete, isUndelete, isBefore, isAfter, isExecuting, size, operationType).
- What is the difference between Trigger.new and Trigger.old?
- In which trigger events are Trigger.new and Trigger.newMap available?
- In which trigger events are Trigger.old and Trigger.oldMap available?