How to get the name of the country name?

Question

Hi All,

I am trying to retrieve the country name. How can I do that? Below is my code that I use to retrieve the province, district municipality, local municipality and wards:

var query = new Query();
query.geometry = view.toMap(event);
query.distance = 0;
query.units = "meters";
query.spatialRelationship = "intersects";
query.returnGeometry = true;
query.outFields = [ "PROVINCE", "DCS12_NAME", "S12_NAME", "WARD_NO" ];

queryTask.execute(query).then(function(results){

var feat = results.features[0];
provinces = feat.attributes.PROVINCE;
wards = feat.attributes.WARD_NO;
districts = feat.attributes.DCS12_NAME;
municipalities = feat.attributes.S12_NAME

showWards.push(wards);
var xwards = showWards.toString();

console.log(provinces);
console.log(wards);
console.log(districts);
console.log(municipalities);
console.log(xwards);

I have tried using

query.outFields = [ "COUNTRY","PROVINCE", "DCS12_NAME", "S12_NAME", "WARD_NO" ];

but it is not working. Please assist

Kind Regards

Siyabonga Kubeka

SiyabongaKubeka · Answer

Hi Jeffery

Thank you very much, it now works.

JeffreyWilkerson · Answer

You needed another parenthesis, or right round bracket before the catch, to finish off the 'then' function from the query.  My guess is that you added one at the end of the catch to make it compile, but that should only be 1 right parenthesis, round bracket.  Try this:

queryTask.execute(query).then(function(results){

var feat = results.features[0];
    provinces = feat.attributes.PROVINCE;
    wards = feat.attributes.WARD_NO;
    districts = feat.attributes.DCS12_NAME;
    municipalities = feat.attributes.S12_NAME

showWards.push(wards);
    var xwards = showWards.toString();

console.log(provinces);
    console.log(wards);
    console.log(districts);
    console.log(municipalities);
    console.log(xwards);

//Call to CRM to populate the lookup field for Province
    debugger;

window.parent.Xrm.WebApi.online.retrieveMultipleRecords("dea_province", "?$select=dea_name,dea_provinceid&$filter=dea_name eq '" + provinces + "'").then(
        function success(results) {
            debugger;
            for (var i = 0; i < results.entities.length; i++) {
                var dea_name = results.entities[i]["dea_name"];
                var dea_provinceid = results.entities[i]["dea_provinceid"];

//Populate lookup
                var lookupValue = new Array();
                lookupValue[0] = new Object();
                lookupValue[0].id = dea_provinceid; // GUID of the lookup id
                lookupValue[0].name = dea_name; // Name of the lookup
                lookupValue[0].entityType = "dea_province"; //Entity Type of the lookup entity
                window.parent.Xrm.Page.getAttribute("dea_province").setValue(lookupValue);
            }
        },
        function(error) {
            Xrm.Utility.alertDialog(error.message);
        }
    );

//Call to CRM to populate the lookup field for the Local Municipality

window.parent.Xrm.WebApi.online.retrieveMultipleRecords("dea_localmunicipality", "?$select=dea_localmunicipalityid,dea_name&$filter=dea_name eq '" + municipalities + "'").then(
        function success(results) {
            for (var i = 0; i < results.entities.length; i++) {
                var dea_localmunicipalityid = results.entities[i]["dea_localmunicipalityid"];
                var dea_name = results.entities[i]["dea_name"];

//Populate lookup
                var lookupValue = new Array();
                lookupValue[0] = new Object();
                lookupValue[0].id = dea_localmunicipalityid; // GUID of the lookup id
                lookupValue[0].name = dea_name; // Name of the lookup
                lookupValue[0].entityType = "dea_localmunicipality"; //Entity Type of the lookup entity
                window.parent.Xrm.Page.getAttribute("dea_localmunicipality").setValue(lookupValue);
            }
        },
        function(error) {
            Xrm.Utility.alertDialog(error.message);
        }
    );

//Call to CRM to populate the lookup field for District Municipality

window.parent.Xrm.WebApi.online.retrieveMultipleRecords("dea_districtmunicipality", "?$select=dea_districtmunicipalityid,dea_name&$filter=dea_name eq '" + districts + "'").then(
        function success(results) {
            for (var i = 0; i < results.entities.length; i++) {
                var dea_districtmunicipalityid = results.entities[i]["dea_districtmunicipalityid"];
                var dea_name = results.entities[i]["dea_name"];

//Populate lookup
                var lookupValue = new Array();
                lookupValue[0] = new Object();
                lookupValue[0].id = dea_districtmunicipalityid; // GUID of the lookup id
                lookupValue[0].name = dea_name; // Name of the lookup
                lookupValue[0].entityType = "dea_districtmunicipality"; //Entity Type of the lookup entity
                window.parent.Xrm.Page.getAttribute("dea_districtmunicipality").setValue(lookupValue);
            }
        },
        function(error) {
            Xrm.Utility.alertDialog(error.message);
        }
    );

//Populate the coordinates field
    debugger;
    window.parent.Xrm.Page.getAttribute("dea_latitude").setValue(latlon);
    window.parent.Xrm.Page.getAttribute("dea_longitude").setValue(latlon);
    window.parent.Xrm.Page.getAttribute("dea_ward").setValue(xwards);
    //THE END OF CALLS TO CRM
})
.catch(function (error) {
    console.error("Query Error: " + error);
});

SiyabongaKubeka · Answer

Hi Jeffery, I tried putting this, but I get an error saying .catch is not a function. Please see my complete code below: GIS Map for CRM

Here is the error code