locked
How do I save the result of a FetxhQuery to a field instead of the console in a Plugin? RRS feed

  • Question

  • For instance, I have the code block below that is set to run post-operation on the LEAD Entity, I would like to save the result to a field on the same Lead entity form called  "new_Opportunities"; how can I do this?

    // *****************************************************************************************************************
    //                FetchXML      opportunity_count   Aggregate 2
    // *****************************************************************************************************************
    // Fetch the count of all opportunities.  This is the equivalent of
    // SELECT COUNT(*) AS opportunity_count ... in SQL.
    string opportunity_count = @" 
    <fetch distinct='false' mapping='logical' aggregate='true'> 
        <entity name='opportunity'> 
           <attribute name='name' alias='opportunity_count' aggregate='count'/> 
        </entity> 
    </fetch>";
    
    EntityCollection opportunity_count_result = _serviceProxy.RetrieveMultiple(new FetchExpression(opportunity_count));
    
    foreach (var c in opportunity_count_result.Entities)
    {
        Int32 aggregate2 = (Int32)((AliasedValue)c["opportunity_count"]).Value;
        System.Console.WriteLine("Count of all opportunities: " + aggregate2); 
    
    }
    System.Console.WriteLine("===============================");

    Wednesday, January 8, 2014 10:29 AM