在salesforce中使用apex查询DB

Question

com和apex触发器

我有两个对象，即Customer_c和Order_c我正试图编写一个触发器来删除属于已被设置为非活动的客户的订单条目。

基本上我想触发更新customer_c表

从customer_c检索一个条目，其中Active_c(布尔值)在更新时被设置为false，并获取该客户的Name并在Order_c表中查找并删除属于该客户的所有'Name'(Orders)。

下面是我的触发代码。当我试图在salesforce中保存触发器时。我得到以下错误:

Error: Compile Error: unexpected token: 'res2' at line 13 column 19

有谁能帮我一下吗?

trigger NewCustomerActive on Customer__c(after update) {
  List<Customer__c> res2 = 
        [SELECT Name FROM Customer__c j WHERE j.Active__c = false];
  List<Order__c> res = 
        [SELECT Name FROM Order__c WHERE Customer__c = res2];
}

Answer 1

改为

trigger NewCustomerActive on Customer__c(after update) {
  List<Customer__c> res2 = 
        [SELECT Name FROM Customer__c j WHERE j.Active__c = false];
  List<Order__c> res = 
        [SELECT Name FROM Order__c WHERE Customer__c in:res2];
}

Answer 2

或者如果您想保存soql语句:

trigger NewCustomerActive on Customer__c(after update) {
  List<Order__c> res = 
        [SELECT Name FROM Order__c WHERE Customer__r.Active__c = false];
}