Dynamics Community Forum Thread Details

Nested Query Expression

CRM2016 On-premises

I am trying to retrieve new_transactionsetid from new_transactionsets. Currently I have the following Query Expression

                    Dim LookupTransactionSet As QueryExpression = New QueryExpression With {.EntityName = "new_transactionsets", .ColumnSet = New ColumnSet("new_transactionsetsid"), .Criteria = New FilterExpression()}
                    LookupTransactionSet.Criteria.AddCondition("new_fileserial", ConditionOperator.EndsWith, _str_serialnumber)
                    LookupTransactionSet.Criteria.AddCondition("new_creditdebitdate", ConditionOperator.Equal, _clearedfundsdate)
                    LookupTransactionSet.Criteria.AddCondition("new_transactioncount", ConditionOperator.Equal, _fileCount)
                    LookupTransactionSet.Criteria.AddCondition("new_submissionvalue", ConditionOperator.Equal, _fileTotal)
                    Dim TransactionSetCollection As EntityCollection = service.RetrieveMultiple(LookupTransactionSet)

new_transactiosets has a lookup field to new_originatingaccounts.

new_originatingaccounts has a field new_sun . I need to add another condition to my Query new_originatingaccounts.new_sun = "xxxxxx"

Is this possible to in effect create a join as you would in a SQL Query ?

LinkEntity linkEntity1 = new LinkEntity(); linkEntity1.JoinOperator = JoinOperator.Natural; linkEntity1.LinkFromEntityName = "new_transactionsets"; linkEntity1.LinkFromAttributeName = "new_orginatingaccounts"; linkEntity1.LinkToEntityName = "account"; // Logical Name of the lookup entity new_originating accounts points to linkEntity1.LinkToAttributeName = "accountid"; // Primary key of the lookup entity linkEntity1.LinkCriteria = new FilterExpression(); linkEntity1.LinkCriteria.FilterOperator = LogicalOperator.And; ConditionExpression condition1 = new ConditionExpression(); condition1.AttributeName = "new_sun"; condition1.Operator = ConditionOperator.Equal; condition1.Values = new object[] { "xxxxxxx" }; linkEntity1.LinkCriteria.Conditions = new ConditionExpression[] { condition1 };

LookupTransactionSet.LinkEntities = new LinkEntity[] { linkEntity1 };

Quick Links

Leaderboard