Microsoft CRM SDK use Guid as query condition value

Question

I need to use the Mircosoft CRM SDK to pull a group of addresses based on the parentid stored in each of the address entities. This parentid naturally corresponds to the GUID of the parent record.

I've built this query two ways: first I simply place the GUID in the condition.Values property, and second I tried using and EntityReference.

If I simply use the GUID the query completes but I receive no results. If I use the EntityReference I get the following exception:

There was an error while trying to serialize parameter http://schemas.microsoft.com/xrm/2011/Contracts/Services:query. The InnerException message was 'Type 'Microsoft.Xrm.Sdk.EntityReference' with data contract name 'EntityReference:http://schemas.microsoft.com/xrm/2011/Contracts' is not expected. Consider using a DataContractResolver or add any types not known statically to the list of known types

I've also tried building the query using two different methods, however I get the same results along the same lines of GUID input into the condition value.

If I open the Microsoft Dynamics web page for the account I'm working on, I can clearly see that the address has been entered.

enter image description here

How do you go about including GUID to query on the parentid?

Method One

    ConditionExpression condition = new ConditionExpression();
    condition.AttributeName = "parentid";
    condition.Operator = ConditionOperator.Equal;

    //This works but returns no results
    condition.Values.Add(new EntityReference("account", id));

    //This throws the above exception
    //condition.Values.Add(new EntityReference("account", id));

    ColumnSet column = new ColumnSet(true);
    QueryExpression query = new QueryExpression();
    query.ColumnSet = column;
    query.EntityName = "customeraddress";
    query.Criteria.AddCondition(condition);

Method Two

        QueryExpression queryEx = new QueryExpression
            {
                EntityName = "customeraddress",
                ColumnSet = new ColumnSet(true),
                Criteria =
                    {
                        FilterOperator = LogicalOperator.And,
                        Conditions =
                            {
                                new ConditionExpression
                                    {
                                        AttributeName = "parentid",
                                        Operator = ConditionOperator.Equal,

                                        //Works but returns no results
                                        Values = {id}

                                        //Throws exception
                                        //Values = {new EntityReference("account", id)}
                                    }
                            }
                    }
            };

Exact same results using either the GUID directly or EntityReference — NealR
I guess outside of that the only things I could think of are 1) triple checking the ID you are passing in is actually the ParentID of those CustomerAddress records and 2) making sure the context you are running under has privileges to query those CustomerAddress records (and that it's not security that's preventing you from getting back results). Good luck! — p e p

Siddique Mahsud Siddique Mahsud · Accepted Answer · 2014-12-17T06:42:29

Query addresses in advance find:

enter image description here

If this results some records then below simple query should have data for u.

private EntityCollection getAddresses(Guid AccountID, IOrganizationService service)
{
    QueryExpression query = new QueryExpression("customeraddress");
    query.ColumnSet = new ColumnSet(true);
    query.Criteria.AddCondition("parentid", ConditionOperator.Equal, AccountID);    
    EntityCollection results = service.RetrieveMultiple(query);
    return results;
}

Microsoft CRM SDK use Guid as query condition value

2 Answers