Problem with the filter option of SDK.REST.retrieveMultipleRecords

(0) Share

Report

Posted on by cchanthony

Hi!

First post ever, hope you guys can give me some valuable help for my problem!

So I am writing a JS script in order to retrive some PhoneCalls which RegardingObjectId is the same of my current incident. To do that, I am using the function SDK.REST.retrieveMultipleRecords.

I have a problem setting the option of my query. I try to set the filter as below:

var optionString = "/PhoneCall?$filter=RegardingObjectId/Id eq (guid'" + editedFormGuid + "')"

but I have the feeling the filter is ignored and what is return by the function is ALL the PhoneCall records, instead of the ones that interest me.

This is how I call the function :

SDK.REST.retrieveMultipleRecords(
            "PhoneCall",
            optionString,
            successCallbackPhoneCall,
            function (error) { alert("errorCallBack message \n" + error.message); },
            function () {Xrm.Utility.alertDialog("retrieve completed");}
            );

Thanks,

Anthony

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report
Hello,

Try to replace line

var optionString = "/PhoneCall?$filter=RegardingObjectId/Id eq (guid'" + editedFormGuid + "')";

with line

var optionString = "$filter=RegardingObjectId/Id eq (guid'" + editedFormGuid + "')";

Was this reply helpful? Yes No
cchanthony 37 on at

Like (0)

Report
Hi Andrii,

Thanks for your reply.

I've try that already, but the result is the same.

Actually I cheated a bit on the Guid of my incident.

At the begining, I get the incident Id with :

var idForm = Xrm.Page.data.entity.getId();

then I notice that the string that I've got is like

"{825CB223-A651-DF11-AA8B-00155DBA3804}"

and when i check the RegardingObjecctId, once I retrieve the data, I have the same string BUT without those characters " and {, also in lowercase

825cb223-a651-df11-aa8b-00155dba3804

So the <editedFormGuid>, that I used in the function is the GUID in lowercase exactly as above.

thanks,

Anthony

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

Then the only way to discover why you code doesn't work properly is to troubleshoot it using Developer Tools. I use Chrome.

Was this reply helpful? Yes No
Verified answer

cchanthony 37 on at

Like (0)

Report
Thank you for your help Andrii.

I found out what was wrong with my script.

Previously the option was set as below :

var idForm = Xrm.Page.data.entity.getId();
var optionString = "/PhoneCall?$filter=RegardingObjectId/Id eq (guid'" + idForm+ "')"

The to get this filter works is :

var idForm = Xrm.Page.data.entity.getId();
optionString: "$select=*&$filter=RegardingObjectId/Id eq (guid'" + idForm + "')"

Now I only retrieve records which RegardingObjectId is equal to the ID of my incident

Anthony

Was this reply helpful? Yes No

Community site session details

Problem with the filter option of SDK.REST.retrieveMultipleRecords

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

Problem with the filter option of SDK.REST.retrieveMultipleRecords

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates