SF - SOQL Best Practice (To Be Continued)

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
];

Part 2 Best Practice