Filtering on SDK.REST.retrieveMultipleRecords problem

(0) Share

Report

Posted on by R.Seiffert

120

Hi everyone!

I am trying to archieve the following using the SDK.REST.retrieveMultipleRecords and facing a problem concerning the ODATA filter.

I have a Entity 1 with a simple lookup field to Entity 2. Now I try to execute a retrieveMultipleRecords with the filter set to only list me instances of Entity 1 where the linked Entity 2 has a specific name.

I already tried to set the filter like this: "$select=*&$filter=<Name of the lookup field in Entity 1>/Name eq '" + <name parameter>+ "'";

and

"$select=*&$filter=<Name of the relationship between the two Entities>/Name eq '" + <name parameter>+ "'";

But in case 1 I get an error message: Error 400: Bad Request: Reference to property Name on complex type EntityReference is not supported.

In case 2 I get the error that there is no 'Name' property in the Type 'Microsoft.Xrm.Sdk.Entity' at position 45.

Can somebody maybe give me a hint on how to set the filter correctly so that i am able to filter records with the 'Name' Property of the inlining EntityReference as the base?

Thx in advance!

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Somesh2207 1,563 on at

Like (0)

Report
Copy link

Link copied!

I would suggest to use the new Web API in CRM. Filtering on link entity is possible and easy to do in Web API.

BR

Somesh Siripuram

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report
Copy link

Link copied!
Hi Seiffert,

Try the following code for filtering. Here I am filtering the account records whose parent account (lookup) id is given.

var entity2LookupId = Xrm.Page.data.entity.getId(); if (entity2LookupId!= "") { var options = "/results$select=*&$filter=SchemaNameofLookUpIdInEntity1/Id eq guid'" + entity2LookupId+ "'"; SDK.REST.retrieveMultipleRecords( 'Entity1SchemaName', options, function (results) { }, function (error) { alert(error.message); }, function onComplete() { } ); }

Hope it helps.

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Based on my understanding, when you use odata to query with lookup field filter, you are query on the entityreference type record. The name is not unique ID for entityreference. You should use GUID instead of name.

Below are example from MSDN:

You can use the $filter query option to filter for the value of an EntityReference attribute. For example, if you have the Id value for a SystemUser record, you can retrieve a list of all the account records that a user is assigned by using the following filter:

/AccountSet?$filter=OwnerId/Id eq (guid'" + SystemUserId + "')

Was this reply helpful? Yes No
Tin 1,562 on at

Like (0)

Report
Copy link

Link copied!

Have you got solution?

I am getting same error,I need to filter lookup name basis not GUID.

Was this reply helpful? Yes No