【Salesforce】SOQL Where文

Salesforce】SOQL Where文

 

 

例:

String nameString = 'a';

Account A = new Account(Name='a');
insert A;


List<Account> accList = new List<Account>();
accList = [SELECT Id FROM Account WHERE Name = :nameString];
System.debug('accList:'+accList);

List<Account> accList2 = new List<Account>();

String ss = new String{'a', 'b'};
accList2 = [SELECT Id FROM Account WHERE Name IN :ss];
System.debug('accList2:'+accList2);

 

結果:

accList:(Account:{Id=0015D00000O4zjNQAR, RecordTypeId=01228000000nUukAAE}, Account:{Id=0015D00000O4zm2QAB, RecordTypeId=01228000000nUukAAE})

 

accList2:(Account:{Id=0015D00000O4zjNQAR, RecordTypeId=01228000000nUukAAE}, Account:{Id=0015D00000O4zm2QAB, RecordTypeId=01228000000nUukAAE})

 

参考URL

https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/langCon_apex_SOQL_variables.htm