Apex Code Development You need to sign in to do that
Don't have an account?
IC-Tanner Avoiding double SOQL statement
When creating a variable from an SOQL query, it appears to be necessary to verify that there is a value to match up with the variable before trying to assign the value to it.
For example, if I utilize the following code:
workshopLeadRTID = [Select Id from RecordType where SobjectType='lead' and Name=:'Workshop Lead'].id;
If no value is found via the SOQL query, I receive a runtime error when what I want is to have no value assigned to the variable without the error. Therefore I normally run two queries below:
//determine if a value is found based on the query
integer workshopLeadRTID_count = [Select count() from RecordType where SobjectType='lead' and Name=:'Workshop Lead'];
//if a value is found, assign it to the variable.
if (workshopLeadRTID_count > 0)
{
workshopLeadRTID = [Select Id from RecordType where SobjectType='lead' and Name=:'Workshop Lead'].id;
}
It seems to me that there must be a better way of doing this that I am not seeing to avoid having to do 2 SOQL queries instead of just 1. Any suggestions? thanks!
Yes, assign it to a list first:
List<RecordType> recordTypes = [Select Id from RecordType where SobjectType='lead' and Name=:'Workshop Lead'];
By the way, there is another mechanism to get recordtype information:
List<Schema.RecordTypeInfo> leadRecordTypeInfos = Lead.SobjectType.getDescribe().getRecordTypeInfos();
This saves the query but counts against the recordtypeinfo call limit though you might find it more valuable as it provides more info than the query does, specifically whether it's available for the user and whether it's the default.
Check out the Apex Language Reference for more info.
All Answers
Yes, assign it to a list first:
List<RecordType> recordTypes = [Select Id from RecordType where SobjectType='lead' and Name=:'Workshop Lead'];
By the way, there is another mechanism to get recordtype information:
List<Schema.RecordTypeInfo> leadRecordTypeInfos = Lead.SobjectType.getDescribe().getRecordTypeInfos();
This saves the query but counts against the recordtypeinfo call limit though you might find it more valuable as it provides more info than the query does, specifically whether it's available for the user and whether it's the default.
Check out the Apex Language Reference for more info.