Yogen Trikannad (yogentrikannad74)

Post

Hello Sir

I am not getting maps location for the Google maps

Integration of Google maps using client API and html

Code:-
<!DOCTYPE html>
<html>
<head>
<style>
/* Set the size of the div element that contains the map */
#map {
height: 400px; /* The height is 400 pixels */
width: 100%; /* The width is the width of the web page */
}
</style>
</head>
<body>
<h3>My Google Maps Demo</h3>

<div id="map"></div>
<script>
// Initialize and add the map
function initMap() {
var latitude = parent.Xrm.Page.getAttributes("address1_latitude").getValue();
var longitude = parent.Xrm.Page.getAttributes("address1_longitude").getValue();

var location = {lat: latitude, lng: longitude};

var map = new google.maps.Map(
document.getElementById('map'), {zoom: 4, center: location});

var marker = new google.maps.Marker({position: location, map: map});
}
</script>

<script async defer
src="https://maps.googleapis.com/maps/api/js?key=AIzaSyCK1NjHz6D1dLmfeEVtkT9KVwctytfmDdo&callback=initMap">;
</script>
</body>
</html>

Let me know if any mistake is there in the code

Thanks

Post

Posted 2 years ago

Hello Sir

This is the code for Web API retrieving data
<!DOCTYPE html>

<html lang="en" xmlns="http://www.w3.org/1999/xhtml">;
<head>
<meta charset="utf-8" />
<title></title>
<script src="new_GlobalHelper"></script>
<script src="new_/Scripts/Somefile"></script>
<script>
function Buttonclick() {

// var contact =
//{
// "firstname": "Sample Contact",
// "lastname": "Web API",

//}

// create account record
//parent.Xrm.WebApi.createRecord("contact",contact).then(
// function success(result) {
// document.getElementById("text").innerHTML = result.id;
// // perform operations on record creation
// },
// function (error) {
// document.getElementById("text").innerHTML = error.message;
// // handle error conditions
// }
//);
// Use retrieve multiple for retrieving multiple records
parent.Xrm.WebApi.retrieveMultipleRecords("contact","$select=firstname,lastname,address1_city&$filter=address1_city eq 'Redmond'", 5000).then(
function success(result) {
var text;
for (var i = 0; i < result.entities.length; i++) {
console.log(result.entities[i]);
text += result.entities[i].firstname
}
// perform additional operations on retrieved records
document.getElementById("text").innerHTML = text;
},
function (error) {
console.log(error.message);
// handle error conditions
}
);

//Accessing from elements from HTML web resource
// We have to follow old code "Xrm.Page" not new code "formContext"
//var accountName = parent.Xrm.Page.getAttribute("name").getValue();

// In HTML web resource , you can use DOM(Document Object Model)
// In JavaScript web resource , DOM is not supported
// document.getElementById("text").innerHTML = accountName
}

</script>

</head>
<body>
<input type="button" value="Click Me" onclick="Buttonclick()" />
<p id="text">

</p>
</body>
</html>

On click Me button there is no response coming

4 comments

Liked by Nayakwadi Srivalli and 2 others

Post

Posted 2 years ago

Grouping and Aggregation Issue - Section 5 Aggregate Operations using FetchXML
Hello Sir I am getting below runtime error while using average method .

System.ServiceModel.FaultException`1: 'Aggregate AVG or SUM is not supported for attribute of type primarykey.'

The screenshot is attached

Code:-

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using Microsoft.Xrm.Sdk;

using Microsoft.Xrm.Tooling.Connector;

using Microsoft.Xrm.Sdk.Query;

namespace ConsoleApp

{

class Program

{

static void Main(string[] args)

{

// Authenicate

string connectionString = "AuthType=Office365;Url=https://mvcmar2017.crm8.dynamics.com/ ;Username=mvcmar2017@mvcmar2017.onmicrosoft.com;Password=Kenya@2020";

CrmServiceClient service = new CrmServiceClient(connectionString);

// Counting Leads

string query = @" <fetch distinct='false' mapping='logical' aggregate='true'>

<entity name='lead'>

<attribute name='leadid' alias='NumberofLeads' aggregate='avg' />

</entity>

</fetch>";

EntityCollection collection = service.RetrieveMultiple(new FetchExpression(query));

foreach (Entity item in collection.Entities)

{

Console.WriteLine(((AliasedValue)item.Attributes["NumberofLeads"]).Value.ToString());

}

Console.Read();

// Fetch XML

/*

string query = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>

<entity name = 'contact'>

<attribute name = 'fullname' />

<attribute name = 'parentcustomerid' />

<attribute name = 'telephone1' />

<attribute name = 'emailaddress1' />

<attribute name = 'contactid' />

<order attribute = 'fullname' descending = 'false' />

<filter type = 'and' >

<condition attribute = 'statecode' operator= 'eq' value = '0' />

<condition attribute = 'address1_city' operator= 'eq' value = 'Redmond' />

</filter >

</entity >

</fetch > ";

EntityCollection collection = service.RetrieveMultiple(new FetchExpression(query));

foreach (Entity contact in collection.Entities)

{

Console.WriteLine(contact.Attributes["fullname"].ToString());

}

Console.Read();

*/

}

}

}

I have uploaded the same query on Udemy.

Sign in to your account

mvcmar2017.crm8.dynamics.com

1 comment

Liked by Satish Reddy and 1 other

No more items...

Yogen Trikannad
28

Do you have questions for Yogen Trikannad?

Yogen Trikannad 28

Do you have questions for Yogen Trikannad?

Yogen Trikannad
28