How to iterate through entity record using javascripts.

(0) Share

Report

Posted on by EmployeeOcta

can any one give me any sample for crm 2016 for iterating through entity record and check value of the field for the given hardcore value.

e.g.fetch a contact entity record and want to check if lastname is equal to "CONSUMER".

for an example i want the above one ,

Ones i get it will apply the same logic in the for actual reason.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

MNarmeen 1,848 on at

Like (0)

Report

You have to do it via plugin.

alisharifiblog.wordpress.com/.../retrieve-multiple-records-with-xrmservicetoolkit

Was this reply helpful? Yes No
EmployeeOcta 6 on at

Like (0)

Report

var Opportunity = Utilities.queryMultipleEntities(oDataSelect);

if(Opportunity != null && Opportunity.length !=0 )

{

if(Opportunity[0].StateCode.Value == 1 )

{

//doing some work here.

}

.Value is not supported in crm 2016 , how can resolve this.

Was this reply helpful? Yes No
Suggested answer

MNarmeen 1,848 on at

Like (0)

Report

getValue(); is used in javascript

Was this reply helpful? Yes No
EmployeeOcta 6 on at

Like (0)

Report

Hello MN,

can you replace this line of code

if(Opportunity[0].StateCode.Value == 1 )

from above .

show me how to do that.

Was this reply helpful? Yes No
MNarmeen 1,848 on at

Like (0)

Report

are you doing this in javascript?

Was this reply helpful? Yes No
Suggested answer

Sravan Kumar Chandh... 140 on at

Like (1)

Report

Start with simple. Try executing this code in console window of ie, by opening the desired record. This is essentially nothing but iterating all the form data attributes and checking to find if any field's value is "CONSUMER". Fetching the record is another part.

Xrm.Page.data.entity.attributes.get(function(attribute,index){

if(attribute.getValue()=="CONSUMER"){alert("found");}

})

If it solved, please mark the answer as verified.

Was this reply helpful? Yes No
Suggested answer

Gopalan Bhuvanesh 11,401 on at

Like (0)

Report

Hi

My understanding from your code (Utilities.queryMultipleEntities) is that you are using opusUtilities library.

If it is so, this library uses Organization data service (OData v2 REST endpoint), which is deprecated now, and JQuery.

You do not need to change this code from .Value, as long as it works fine. Because this is how you would be able to retrieve the value for the attribute of the records returned from this library function.

If you want to use different library (for Web API) instead of Opus, you can do so, accordingly.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

You can try this approach with fetchxml and web api via javascript as shown in the below link

www.hbs.net/.../using-fetchxml-in-web-api-queries-via-javascript-f

Was this reply helpful? Yes No
EmployeeOcta 6 on at

Like (0)

Report

Hello Guys,

if i use below code then what will happen.

var Opportunity = Utilities.queryMultipleEntities(oDataSelect);

if(Opportunity != null && Opportunity.length !=0 )

{

if(Xrm.Page.getAttribute(Opportunity[0].StateCode).getSelectedOption().value; == 1 )

{

//doing some work here.

}

Was this reply helpful? Yes No