• SSK9
  • NEWBIE
  • 9 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 7
    Questions
  • 2
    Replies
Whenever a new record is added, all the contacts in must be notified of the record that was added through the 'Primary Contact Method: Phone or Email' field associated with that contacts.
  • March 30, 2018
  • Like
  • 0
Something went wrong while executing the PriceV1 node: invalid field expression "Forecast.Forecast.Item_Code__c" * "Forecast_Quantity__c"; for field 'PriceV1': Unsupported type: STRING for arg1 ("Forecast.Forecast.Item_Code__c") of ("Forecast.Forecast.Item_Code__c" * "Forecast_Quantity__c") (02K61000000TQ2XEAW_03C61000000VyNQEA0
Need Help
  • March 07, 2018
  • Like
  • 0
Hi ,
Can you help me fix this error .CustomerPricingModifier: System.LimitException: Too many SOQL queries: 101" error
I get this error when Data is sent from Orcale to Salesforce via Mulesoft.

trigger CustomerPricingModifier on Customer_Pricing_Modifiers__c (after insert)
{
    for(Customer_Pricing_Modifiers__c cp:Trigger.New){
        integer i=[Select count() from Customer_Pricing_Modifiers__c WHERE External_Unique_ID__c=:cp.External_Unique_ID__c];
        if(i>1){
        CustomerDupTriggHandler.DuplicateHandler(trigger.new);
        }
    }
}
  • March 06, 2018
  • Like
  • 0
How to Delete 100000 leads at once with criteria of created by a particular user and on a particular date
  • February 16, 2018
  • Like
  • 0
Update the task status to "completed" when the Case status is changed to Closed. I tried using the process builder , but it is not working. Help needed.
  • February 12, 2018
  • Like
  • 0
Error:Apex trigger InquiryTrigger caused an unexpected exception, contact your administrator: InquiryTrigger: execution of AfterUpdate caused by: System.QueryException: List has no rows for assignment to SObject: Class.InquiryTriggerHandler.InquiryHandler: line 13, column 1

How do I fix this issue?

 
public class InquiryTriggerHandler {
    
    public static void InquiryHandler(string caseid){
       
        
        
        
        
        Case cs=[SELECT id,OwnerId,ContactID,Confirmation_Email__c,ContactEmail From Case WHERE id=:caseid];
        
        system.debug('CaseID: '+caseid);
        
        user u=[select id,email from user where id=:cs.ownerid];
        
        system.debug('User Email: '+u.email);
        
        system.debug('Confirmation Mail: '+cs.Confirmation_Email__c);
        
        system.debug('Contact Email: '+cs.ContactEmail);
        
        List<Messaging.SingleEmailMessage> lsem=new List<Messaging.SingleEmailMessage>();
        
        Messaging.SingleEmailMessage sem=new Messaging.SingleEmailMessage();
        
        List<String> address=new List<String>();
        
        //address.add(u.email);
        
        address.add(cs.Confirmation_Email__c);
        
        address.add(cs.contactemail);
        
        address.add('siddharth.koduri@gmail.com');
        
        sem.setToAddresses(address);
        
        sem.setCcAddresses(new string[]{u.email});

        //sem.setSubject('testing');
        
        //sem.setplaintextbody('jjjj');
        EmailTemplate et=[SELECT id,Name FROM EmailTemplate WHERE name='Email Confirmation Template II'];
        
        sem.setTemplateId(et.id);
        
        sem.setTargetObjectId(cs.contactId);
        
        sem.setWhatId(cs.id);
        
       
       OrgWideEmailAddress owd=[SELECT id,Address FROM OrgWideEmailAddress WHERE Address=:system.label.Taconic_Mail_id];
       
       sem.setOrgWideEmailAddressId(owd.id);
        
        
       List<Attachment> att=[SELECT id,Name,Body,ContentType FROM Attachment WHERE ParentID=:caseid];
        
        List<Messaging.EmailFileAttachment> lefa=new List<Messaging.EmailFileAttachment>();
        
        for(Attachment a:att){
            
            Messaging.EmailFileAttachment efa=new Messaging.EmailFileAttachment();
            string contentvalue=(a.contentType).substringAfter('/');
            efa.setBody(a.body);
                efa.setFileName(a.Name);
            lefa.add(efa);
            
        } 
   
        sem.setFileAttachments(lefa); 
          
        
        
        lsem.add(sem);
            
        messaging.sendEmail(lsem);
    
        
        
    }
}

 
  • February 07, 2018
  • Like
  • 0
I created a custom object and want to upload data using DataLoader. I have to insert data based upon the 3 unique fields .If all the three unique fields have unique values then it should create a new record, Othwerwise it should overide the existing record.

How do I do this?

Thank you.
  • November 20, 2017
  • Like
  • 0
Something went wrong while executing the PriceV1 node: invalid field expression "Forecast.Forecast.Item_Code__c" * "Forecast_Quantity__c"; for field 'PriceV1': Unsupported type: STRING for arg1 ("Forecast.Forecast.Item_Code__c") of ("Forecast.Forecast.Item_Code__c" * "Forecast_Quantity__c") (02K61000000TQ2XEAW_03C61000000VyNQEA0
Need Help
  • March 07, 2018
  • Like
  • 0
Hi ,
Can you help me fix this error .CustomerPricingModifier: System.LimitException: Too many SOQL queries: 101" error
I get this error when Data is sent from Orcale to Salesforce via Mulesoft.

trigger CustomerPricingModifier on Customer_Pricing_Modifiers__c (after insert)
{
    for(Customer_Pricing_Modifiers__c cp:Trigger.New){
        integer i=[Select count() from Customer_Pricing_Modifiers__c WHERE External_Unique_ID__c=:cp.External_Unique_ID__c];
        if(i>1){
        CustomerDupTriggHandler.DuplicateHandler(trigger.new);
        }
    }
}
  • March 06, 2018
  • Like
  • 0