【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