How to filter the results of an oData array

(0) Share

Report

Posted on by Community Member

Hi All,

On the quote entity, I have an oData query that returns the records of a custom entity (new_alerts).

"/XRMServices/2011/OrganizationData.svc/new_alertsSet?$select=new_alertsId,new_Alert,new_Message,new_ClientId,new_Category"

I would like to take the GUID from the Potential Customer field (customerid) and select the records that also have that customers GUID held in (new_ClientId). This gives me the GUID of customerid in entityId:

function guidLookup() {
        var entityName, entityId, entityLabel, lookupFieldObject;

        lookupFieldObject = Xrm.Page.data.entity.attributes.get("customerid");
        if (lookupFieldObject.getValue() != null) {
           entityId = lookupFieldObject.getValue()[0].id;
           entityName = lookupFieldObject.getValue()[0].entityType;
           entityLabel = lookupFieldObject.getValue()[0].name;
        }
}

But how would I get the following (results[0].new_ClientId.Id) out of my oData query to use in a comparison? Bearing in mind I might have many records, i.e. [1], [2], [3], etc. and I would like to search in all of them for the GUID in entityId.

7024.Capture2.PNG

Thanks

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Community Member on at

Like (0)

Report
Copy link

Link copied!
I've got myself this far....

// Process the results var alertArray = JSON.parse(req.responseText).d.results; if (alertArray != null && alertArray.length > 0) { for (i = 0; i < alertArray.length; i++) { var showAlert += alertArray[i].new_ClientId.Name + " - " + alertArray[i].new_Alert + "<br>"; } }

However, now when the script fires, it creates this error:

ReferenceError: 'function' is undefined at eval code (eval code:1:1)

ReferenceError: 'quote_Populate_Alerts' is undefined at eval code (eval code:1:1) at RunHandlerInternal (espprojects.crm4.dynamics.com/.../ClientApiWrapper.aspx) at RunHandlers (espprojects.crm4.dynamics.com/.../ClientApiWrapper.aspx) at ExecuteHandler (espprojects.crm4.dynamics.com/.../ClientApiWrapper.aspx) at Mscrm.TurboForm.Control.CustomScriptsManager.prototype.$Aw_1 (espprojects.crm4.dynamics.com/.../formcontrols.js) at Mscrm.TurboForm.Control.CustomScriptsManager.prototype.executeHandler (espprojects.crm4.dynamics.com/.../formcontrols.js) at Mscrm.TurboForm.Control.CustomScriptsManager.prototype.executeHandlerByDescriptor (espprojects.crm4.dynamics.com/.../formcontrols.js) at Anonymous function (espprojects.crm4.dynamics.com/.../formcontrols.js) at Anonymous function (espprojects.crm4.dynamics.com/.../global.ashx) at Mscrm.TurboForm.Control.Data.DataEntity.prototype.$Bk_1 (espprojects.crm4.dynamics.com/.../formcontrols.js)

Was this reply helpful? Yes No
Verified answer

Anne Pessoa 14 on at

Like (0)

Report
Copy link

Link copied!

Hi Ederen,

Not sure if I understood what you want to do.

You want to search all alerts for the customer? If so you can use the filter for that:

msdn.microsoft.com/.../gg309461(v=crm.7).aspx

Would be something like "/XRMServices/2011/OrganizationData.svc/new_alertsSet?$select=new_alertsId,new_Alert,new_Message,new_ClientId,new_Category$filter=new_ClientId/Id eq (guid'" + customerid+ "')"

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks for the answer. The filter might just move me a step closer to what I need.

I want to retrieve all the alerts for the customer and show them in a text field with the Name of the account, maybe the date created and the actual alert.

That ReferenceError is a bit odd. In my troubleshooting, I have found that the webpage is not loading the script during the event and so the event is missing the reference, hence 'undefined'. I have no idea why this is happening.

Was this reply helpful? Yes No
Suggested answer

Aman Kothari on at

Like (0)

Report
Copy link

Link copied!
Hi,

You can use normal JS code or third parties library like underscore , lodash etc for iterating JS array .

you can iterate using

1. forEach

alertArray.forEach(function (obj, index) { //check your condition here if(obj.new_ClientId.Id==entityId){ //write your logic here

} }); 2.Underscore.js or Lodash.js _.each(alertArray,function(obj){

//check your condition here if(obj.new_ClientId.Id==entityId){ //write your logic here

}

})

Hope it'll help you.

Thanks

Aman Kothari

Blog LinkedIn

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Anne,

If I use "$filter=new_ClientId/Id eq (Guid'" + customerId + "')" like you said, each time the code runs, it gives the error

TypeError: Unable to get property 'results' of undefined or null reference

at quote_Populate_Alerts

This is directly related to the $filter= string above.

The error suggests it cannot find any results, but I can confirm that customerId contains a guid string without curly braces and that there are at least 2 records in the search with that GUID

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Anne, you have cause me hours of pain lool!! Well not you directly, it's more my noobness!

You missed the & before the $filter. I should've tested the url first but instead I just bashed my head for hours until I had the glorious idea of trying the url and hey-presto....a decent error message about '&' being expected.

A great (and much needed) learning experience. Thank you

Was this reply helpful? Yes No