I have a c# query below and would like to know how to add another condition to a linked entity. Cant seem to get it to work.
Entity entity = (Entity)context.InputParameters["Target"];
tracer.Trace("Getting Agreement Schedule Dates...");
//********* Get Agreement Invoice Dates *********
QueryExpression query = new QueryExpression();
query.EntityName = "f1_agreementscheduledate";
query.ColumnSet.Columns.Add("f1_agreementscheduledateid");
query.ColumnSet.Columns.Add("f1_workorder");
query.ColumnSet.Columns.Add("statecode");
query.ColumnSet.Columns.Add("f1_status");
query.LinkEntities.Add(new LinkEntity("f1_agreementscheduledate", "f1_agreementschedulesetup", "f1_schedulesetup", "f1_agreementschedulesetupid", JoinOperator.Inner));
query.LinkEntities[0].EntityAlias = "AgreementScheduleSetup";
query.LinkEntities[0].LinkCriteria = new FilterExpression();
query.LinkEntities[0].LinkCriteria.FilterOperator = LogicalOperator.And;
query.LinkEntities[0].LinkCriteria.Conditions.Add
(
new ConditionExpression("f1_agreementschedulesetupid", ConditionOperator.Equal, entity.Id)
//ADD ANOTHER CONDITION HERE
);
*This post is locked for comments
I have the same question (0)
