Hi All, Beloe is the snippet: trigger UpdateQuantity on SVMXC__Product_Stock__c (after insert,after update) { Set<Id> productIds = new Set<Id>(); Map<Id, SVMXC__Product_Stock__c> productToStock = new Map<Id, SVMXC__Product_Stock__c>(); for (SVMXC__Product_Stock__c stock : Trigger.new) { if (stock.SVMXC__Product__c != null) { productIds.add(stock.SVMXC__Product__c); productToStock.put(stock.Id, stock); } }
Map<Id, Product2> productMap = new Map<Id, Product2>([SELECT Total_Available_Quantity__c FROM Product2 WHERE Id IN :productIds]); List<Product2> productsToUpdate = new List<Product2>(); for(SVMXC__Product_Stock__c stock : trigger.new) { AggregateResult[] results = [Select SVMXC__Product__c,SUM(SVMXC__Quantity2__c) FROM SVMXC__Product_Stock__c GROUP BY SVMXC__Product__c]; system.debug('tttt' + stock); //SVMXC__Product_Stock__c oldStock = trigger.oldMap.get(stock.Id); // System.debug('oldStockId'+ oldStock); Product2 product = productMap.get(stock.SVMXC__Product__c); if(stock.SVMXC__Status__c.equalsIgnoreCase('Available')) { product.Total_Available_Quantity__c = stock.SVMXC__Quantity2__c; system.debug('test' + product.Total_Available_Quantity__c); productsToUpdate.add(product);
i have wrote a batch class ,But looks i am going Wrong Smewer , it shows no viable alternative at character ' '
my code looks like :
global class RMABatchProcess implements Database.Batchable<sObject>{
public String query ; public List<RMA_Staging__c> RMAStgobj = new List<RMA_Staging__c>(); public List<RMA_Staging_Lines__c> RMAStgLine = new List<RMA_Staging_Lines__c>();
global RMABatchProcess() { this.query = 'SELECT Id,Name,RecordTypeId,SM_Catalyst_RMA_Reason__c,SVMXC__Address_Type__c,SVMXC__Company__r.Name,SVMXC__Destination_City__c,SVMXC__Destination_Country__c,SVMXC__Destination_Location__r.Name,SVMXC__Destination_State__c,SVMXC__Destination_Street__c,SVMXC__Destination_Zip__c,SVMXC__Expected_Delivery_Date__c,SVMXC__Order_Status__c,SVMXC__Order_Type__c,SVMXC__Parts_Request__r.Name,SVMXC__Priority__c,SVMXC__RMA_Type__c,SVMXC__Service_Engineer__r.Name,SVMXC__Service_Order__r.Name,SVMXC__Source_City__c,SVMXC__Source_Country__c,SVMXC__Source_Location__r.Name,SVMXC__Source_State__c,(SELECT Id,Name,RecordTypeId,SVMXC__Actual_Quantity2__c,SVMXC__Actual_Receipt_Date__c,SVMXC__Disposition__c,SVMXC__Expected_Condition__c,SVMXC__Expected_Quantity2__c,SVMXC__Line_Status__c,SVMXC__Parts_Request_Line__r.Name,SVMXC__Product__r.Name,SVMXC__RMA_Shipment_Order__r.Name,SVMXC__Serial_Number__c,SVMXC__Service_Engineer__r.Name,SVMXC__Service_Order__r.Name FROM SVMXC__RMA_Shipment_Line__r WHERE SVMXC__Line_Status__c = \'Open\'),SVMXC__Source_Street__c,SVMXC__Source_Zip__c FROM SVMXC__RMA_Shipment_Order__c WHERE SVMXC__Order_Status__c = \'Open\' and RecordtypeId= \'012410000004qj3\''; }
global Database.QueryLocator start (Database.BatchableContext bc){ return Database.getQueryLocator(query); }
global void execute (Database.BatchableContext bc,List<sObject> scope){ for (sObject obj : scope){ SVMXC__RMA_Shipment_Order__c stageRMA = (SVMXC__RMA_Shipment_Order__c)obj; RMA_Staging__c RMAStg = new RMA_Staging__c();
Hi all. i need to write a trigger for : i have a requirment as , i have child object as Case ,In which their r 2 fields such as Assigned to and Technician Email. and second parent object is Eqipment in which i have a field called as email.
wat i need is when ever the assigned field is not null in child, den Eqipment ;s email should b copied to childs,s Technicain Email..
i have 1time donation field on Transaction obj,This should be sumed up and update the field total amount on contact. i have a lookup on transaction to contact. how to write batch apex fr this?
I have PledgeAmount ,No.Installments,InstallmentPeriod fields on transaction object ,I wanted to calculate paydate on Installment object. when installment period is selected as monthly, biYearly,Yearly.And update paydate on installment object
Hi All, Beloe is the snippet: trigger UpdateQuantity on SVMXC__Product_Stock__c (after insert,after update) { Set<Id> productIds = new Set<Id>(); Map<Id, SVMXC__Product_Stock__c> productToStock = new Map<Id, SVMXC__Product_Stock__c>(); for (SVMXC__Product_Stock__c stock : Trigger.new) { if (stock.SVMXC__Product__c != null) { productIds.add(stock.SVMXC__Product__c); productToStock.put(stock.Id, stock); } }
Map<Id, Product2> productMap = new Map<Id, Product2>([SELECT Total_Available_Quantity__c FROM Product2 WHERE Id IN :productIds]); List<Product2> productsToUpdate = new List<Product2>(); for(SVMXC__Product_Stock__c stock : trigger.new) { AggregateResult[] results = [Select SVMXC__Product__c,SUM(SVMXC__Quantity2__c) FROM SVMXC__Product_Stock__c GROUP BY SVMXC__Product__c]; system.debug('tttt' + stock); //SVMXC__Product_Stock__c oldStock = trigger.oldMap.get(stock.Id); // System.debug('oldStockId'+ oldStock); Product2 product = productMap.get(stock.SVMXC__Product__c); if(stock.SVMXC__Status__c.equalsIgnoreCase('Available')) { product.Total_Available_Quantity__c = stock.SVMXC__Quantity2__c; system.debug('test' + product.Total_Available_Quantity__c); productsToUpdate.add(product);
i have wrote a batch class ,But looks i am going Wrong Smewer , it shows no viable alternative at character ' '
my code looks like :
global class RMABatchProcess implements Database.Batchable<sObject>{
public String query ; public List<RMA_Staging__c> RMAStgobj = new List<RMA_Staging__c>(); public List<RMA_Staging_Lines__c> RMAStgLine = new List<RMA_Staging_Lines__c>();
global RMABatchProcess() { this.query = 'SELECT Id,Name,RecordTypeId,SM_Catalyst_RMA_Reason__c,SVMXC__Address_Type__c,SVMXC__Company__r.Name,SVMXC__Destination_City__c,SVMXC__Destination_Country__c,SVMXC__Destination_Location__r.Name,SVMXC__Destination_State__c,SVMXC__Destination_Street__c,SVMXC__Destination_Zip__c,SVMXC__Expected_Delivery_Date__c,SVMXC__Order_Status__c,SVMXC__Order_Type__c,SVMXC__Parts_Request__r.Name,SVMXC__Priority__c,SVMXC__RMA_Type__c,SVMXC__Service_Engineer__r.Name,SVMXC__Service_Order__r.Name,SVMXC__Source_City__c,SVMXC__Source_Country__c,SVMXC__Source_Location__r.Name,SVMXC__Source_State__c,(SELECT Id,Name,RecordTypeId,SVMXC__Actual_Quantity2__c,SVMXC__Actual_Receipt_Date__c,SVMXC__Disposition__c,SVMXC__Expected_Condition__c,SVMXC__Expected_Quantity2__c,SVMXC__Line_Status__c,SVMXC__Parts_Request_Line__r.Name,SVMXC__Product__r.Name,SVMXC__RMA_Shipment_Order__r.Name,SVMXC__Serial_Number__c,SVMXC__Service_Engineer__r.Name,SVMXC__Service_Order__r.Name FROM SVMXC__RMA_Shipment_Line__r WHERE SVMXC__Line_Status__c = \'Open\'),SVMXC__Source_Street__c,SVMXC__Source_Zip__c FROM SVMXC__RMA_Shipment_Order__c WHERE SVMXC__Order_Status__c = \'Open\' and RecordtypeId= \'012410000004qj3\''; }
global Database.QueryLocator start (Database.BatchableContext bc){ return Database.getQueryLocator(query); }
global void execute (Database.BatchableContext bc,List<sObject> scope){ for (sObject obj : scope){ SVMXC__RMA_Shipment_Order__c stageRMA = (SVMXC__RMA_Shipment_Order__c)obj; RMA_Staging__c RMAStg = new RMA_Staging__c();
I have PledgeAmount ,No.Installments,InstallmentPeriod fields on transaction object ,I wanted to calculate paydate on Installment object. when installment period is selected as monthly, biYearly,Yearly.And update paydate on installment object
