目录
Part 1 Common Skills
1.SOQL中的创建日期格式:
SELECT Id, Name,CreatedDate,CreatedBy.Name from Account WHERE CreatedDate > =2019-01-01T00:00:00Z
2.Workbench默认不可以写关联父级对象的SOQL语句
需要在workbench的Setting中设定。
路径: Workbench > setting > 勾选Allows SOQL Parent Relationship Queries
3. 使用IN 和NOT IN
SELECT id, AccountId FROM contact WHERE AccountId IN ('0013800001MYdadszAAP','0015000000SadNNAA5','00138000019TddawAAO')
SELECT id, AccountId FROM contact WHERE AccountId NOT IN ('0013800001MYdadszAAP','0015000000SadNNAA5','00138000019TddawAAO')
for APEX :
//List of billing cities to ignore
List<String> citiesToIgnore = new List<String>{'San Francisco', 'Mountain View', 'Tucson'};
//Query not in with bind variables
List<Account> accounts = [ Select Name, BillingCity from Account Where BillingCity NOT IN:citiesToIgnore
];