Hello All Experts,
I am trying to creating a query but there seems to be my less understanding which is causing not to get correct value.
it will be really great if some one can help me to get the correct id.
Below is my queryexpression
private Guid fetchconnectionRoleId2(Guid _connectionRoleId, Guid Record2Id, IOrganizationService organizationService)
{
Guid _connectionRoleId2 = new Guid();
QueryExpression reciprocalrolequery = new QueryExpression
{
EntityName = ConnectionRole.EntityLogicalName,
ColumnSet = new ColumnSet(true),
LinkEntities =
{
new LinkEntity
{
JoinOperator = JoinOperator.Inner,
LinkFromEntityName = ConnectionRole.EntityLogicalName,
LinkFromAttributeName = "connectionroleid",
LinkToEntityName = "connectionroleassociation",
LinkToAttributeName = "connectionroleid",
LinkCriteria = new FilterExpression
{
FilterOperator = LogicalOperator.And,
Conditions =
{
new ConditionExpression
{
AttributeName = "associatedconnectionroleid",
Operator = ConditionOperator.Equal,
Values = { _connectionRoleId}
}
}
}
}
};
EntityCollection resultstemp = organizationService.RetrieveMultiple(reciprocalrolequery);
i need to basically fetch the _connectionRoleId2 but this will be somewhere in the connectionrole entity , but i am not able to write the correct query.