CRM javascript to find field value of an enity by passing id?

(0) Share

Report

Posted on by Community Member

Hi All,

I have an entity named Item . Item having field named as current stock, which will be updated on purchasing .

I want to get the current stock value by passing the item id from the look up(on change of item look up).Please give me some samples.

I am new to CRM

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (4)

Nithya Gopinath 17,078 on at

Like (0)

Report

Hi Nidhin,

Why should you pass the item id for getting the current stock value?

Was this reply helpful? Yes No
Suggested answer

AbiRami 516 on at

Like (0)

Report

Hi Nidhin,

Do u want current stock value in another entity or in the same entity?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I need to show the current stock in Purchase entity. The purchase entity form have the look up of Item enity.

Was this reply helpful? Yes No
Verified answer

AbiRami 516 on at

Like (0)

Report

Then u can retrieve the field values from Item entity using the lookup value in purchase entity. Refer the following link.

arvindcsit.wordpress.com/.../retrieve-related-entitys-field-value-from-client-side-using-odata

Thanks

Was this reply helpful? Yes No
Verified answer

Nithya Gopinath 17,078 on at

Like (0)

Report

Hi Nidhin,

Please refer the following community thread. it helps you a lot to retrieve data of one entity to another entity using JavaScript.

community.dynamics.com/.../139190

Was this reply helpful? Yes No
Verified answer

JohnAnonymous 5,241 on at

Like (0)

Report
To do this you need to do the following:

Get the id of the item lookup value on your current form.

De a query via the WebApi to retreive the value from the item entity

Use that value in the way you need to

For both 1 and 2 there are a lot of resources available with examples. If you are not experienced with REST, I would advise you to use the CRM Rest Builder github.com/.../CRMRESTBuilder

Was this reply helpful? Yes No
Verified answer

Nithya Gopinath 17,078 on at

Like (0)

Report
You could try the following code.

function GetCurrentStockValue() { //Get the details of item record associated with the purchase record var EntityName, EntityId, LookupFieldObject; var resultXml;
//Retrieve the item lookup id in purchase record LookupFieldObject = Xrm.Page.data.entity.attributes.get('itemid'); if (LookupFieldObject.getValue() != null) { EntityId = LookupFieldObject.getValue()[0].id; EntityName = LookupFieldObject.getValue()[0].entityType; resultXml = getDetails(EntityName, EntityId); } //Check if field Value Contains or Not if (resultXml != null && resultXml.attributes['currentstock'] != null) { //Fetching the field from item record associated with the purchase record var currentstock = resultXml.attributes['currentstock'].value; // Setting the value of current stock depending on the item selected in the purchase record Xrm.Page.getAttribute("currentstock").setValue(currentstock); } } //Get the details of a record by entity name and entity id function getDetails(EntityName, EntityId) { var cols = ["currentstock"]; var retrievedResult = XrmServiceToolkit.Soap.Retrieve(EntityName, EntityId, cols); return retrievedResult; }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Its done thanks Nithya and all others for your helps.

Was this reply helpful? Yes No