How to catch parent record guid from grand child using javascript?

(0) Share

Report

Posted on by Community Member

hi,

i have a requirement.i have 3entities A,B and C. A to B there is 1 to n relationship and B to C there is 1 to n relationship..when i am working on C entity i want to catch the guid of the parent record with reference of b entity using javascript

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

Suggested answer

Iswarya 1,347 on at

Like (0)

Report

Hi,

C entity will have B entity lookupfield (like field name is B) from which u can get id of B entity. after getting B id , pass this id to B entity primary key and get the corresponding record ,from which we can get guid of A lookupfield. call this script in onsave of C entity

function GetRecid()

{

var bValue=Xrm.Page.getAttribute("new_b").getValue();

if(bValue!=null)

{

var bId=bValue[0].id;

var context = Xrm.Page.context;

    var serverUrl = context.getClientUrl();

    var ODataPath = serverUrl + "/XRMServices/2011/OrganizationData.svc";

    var retrieveResult = new XMLHttpRequest();

    retrieveResult.open("GET", ODataPath + "/new_BSet?$select=new_A&$filter=new_Bid/Id eq guid' " + bId+ "'", false);
    retrieveResult.setRequestHeader("Accept", "application/json");

    retrieveResult.setRequestHeader("Content-Type", "application/json; charset=utf-8?");

    retrieveResult.send();

    if (retrieveResult.readyState == 4 /* complete */) {
        if (retrieveResult.status == 200) {
            var retrieved = this.parent.JSON.parse(retrieveResult.responseText).d;

            var Result = retrieved.results[0];
            var TotalVal = 0;
            if (typeof Result !== "undefined") {


         //to get value of A entity Lookup field id
                    var lookupValue = new Array();
                    lookupValue[0] = new Object();
                    lookupValue[0].id = Result.new_A.Id;
                    lookupValue[0].name = Result.new_A.Name;
                    lookupValue[0].entityType = Result.new_A.LogicalName;
}

}

}

}

}

Was this reply helpful? Yes No
Suggested answer

Hemant Kumar Sahu 1,829 on at

Like (0)

Report

Hi Tejagupta,

You are working on C entity and there is 1:N between B and C.

So there must be lookup field of B in C entity.

Easily you can get the lookup field id that is guid.

var name = Xrm.Page.getAttribute('<FIELD_NAME>').getValue()[0].name;

var id = Xrm.Page.getAttribute('<FIELD_NAME>').getValue()[0].id;

Hemant

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your response..here is my requirement

function GetData()

{

var stateid=Xrm.Page.getAttribute("tj_state").getValue()[0].id;

var statename=Xrm.Page.getAttribute("tj_state").getValue()[0].name;

//alert(stateid);

//alert(statename);

var statecolumns=["tj_country","tj_religion"];

var obj=XrmserviceToolkit.Soap.Retrieve("tj_state",stateid,statecolumns);

//here 'tj_religion' is single line of text,am able to catch the value inside that but,'tj_country'

is the lookup how can i catch the lookup field data and id of that?

var religionname=obj.attributes['tj_religion'].value;

var countryid=obj.attributes['tj_country']. ??

}

Was this reply helpful? Yes No
Verified answer

Hemant Kumar Sahu 1,829 on at

Like (0)

Report

var countryid=obj.attributes['tj_country'].Id

This should work.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i tried that but not working bro

Was this reply helpful? Yes No
Suggested answer

Hemant Kumar Sahu 1,829 on at

Like (0)

Report

I would suggest debug.

Was this reply helpful? Yes No
Verified answer

Iswarya 1,347 on at

Like (0)

Report

Hi ,

when you debug in developer tool , obj.attributes['tj_country'] add this into watch expression and you will able to get idea .

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Finally got it but 'i' should be in lowercase

var countryid=obj.attributes['tj_country'].id;

Thanks for your help

Was this reply helpful? Yes No