function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
YaduYadu 

Update Lookup Field help

  • Update the Sales_Target__c field (Lookup to Sales Target) for Sales Opportunities that match on Officer Code and Close Date/Period Start-End (with Count Against Targets checked)
  • SELECT SO.Id, … FROM Sales_Opportunity__c SO,

  •        Sales_Target__c ST

    WHERE      SO.Count_Against_Targets__c = true

    AND  SO.Officer_Code__c = ST.Officer_Code__c

    AND  SO.Close_Date__c  <= ST.Target_Period_End__c

    AND  SO.Close_Date__c      >= ST.Target_Period_Start__c

     

    If there are any SalesTarget that match the above criteria i need to update the SalesOppurtunity. sales target field on sales oppurtunity. This should handle bulk records

     

    Have a dead line. Please help me.

     

    Thanks!