You’re offline. This is a read only version of the page.
Hi folks,
So here is my question, we have 2 table
Quote 1 :N Quotelineitem
So in the table quotelineitem we have many rows that are related to the quote.
For now, I need help on the coding. I want to retrieve all rows in a subgrid where the quoteid = the actual form we're on and then I want to add some text to a specific field call arb_lineitemsid
The code below is able to get me the guid of the actual form I am on which is good but the rest doesn't really work... I need guidance.
EntityReference mfpquotelookup = (EntityReference)entity.Attributes["new_mfpquote"];
Guid QuoteID = mfpquotelookup.Id;
var mfpquotelookupID = mfpquotelookup.Id;
var mfpquotelookupname = mfpquotelookup.Name;
// entity.Attributes.Add("arb_lineitemsid", mfpquotelookupID + "HEY");
QueryExpression qe = new QueryExpression("new_mfpquotelineitem");
qe.Criteria.AddCondition("new_mfpquote", ConditionOperator.Equal, QuoteID);
EntityCollection Colmfpquotelineitems = service.RetrieveMultiple(qe);
foreach (var targetEntity in Colmfpquotelineitems.Entities)
{
entity.Attributes.Add("arb_lineitemsid", mfpquotelookupID + "HEY");
}
Hi,
You can use FetchXML Builder in XRMTool Box and convert your FetchXml to Query Expression than work on it.
Example:
Share
Report
All responses (
Answers (
3,455
//Set condition Value
var query_quoteid = "your actual quote ID";
//Instantiate QueryExpression query
var query = new QueryExpression("new_mfpquotelineitem");
// Add columns to you want to edit
query.ColumnSet.AddColumn("arb_lineitemsid");
//Add filte query.Criteria
query.Criteria.AddCondition("quoteid",ConditionOperator.Equal, query_quoteid);
var result =service.RetieveMultiple(query);
if(result?.Entities?.Count !=0)
{
//fetch them
foreach(var item in result.Entites)
{
var updatedquotelineItem = new Entity("new_mfpquotelineitem");
updatedquotelineItem["arb_lineitemsid"]= (Guid)query_quoteid; //if the field is lookup data typ
//if field lookup you cannot add any Text. If the field Text field than you add text
updatedquotelineItem.Id = item.Id;
service.Update(updatedquotelineItem);
}
}
