Augmented Reality and Virtual Reality

Here is the quick overview of Augmented Reality and Virtual Reality, also have explained how it is being used today and how it can change the future. Please let me know your comments, share this video if you like and feel free to email me happycodingblog@gmail.com. Description links: If you like this video, please do subscribe, like, share and comment. Please subscribt to Youtube Channel: https://www.youtube.com/channel/UC5I-...

Future of Artificial Intelligence

Have tried to give you the overview of Artificial Intelligence, fields that are using AI, also the Pros and Cons of it. Please let me know your comments, share this video if you like and feel free to email me happycodingblog@gmail.com. Description links: If you like this video, please do subscribe, like, share and comment.

Subscribe to : https://www.youtube.com/channel/UC5I-bCuSyY3MhV_dmfd_RcQ

Google's new OS [Fushsia and Flutter]

Have given just the introduction for the Google's new operating system that will replace Android and Chrome OS in future, If you like the video please do subscribe, like, share and comment.

Subscribe to YouTube channel

Email: happycodingblog@gmail.com

Blog: Happy4coding.blogspot.com

Twitter: https://twitter.com/MadhanDevarajan

The technology behind Bitcoin [Cryptography and Blockchain]

Have tried to provide the overview of the technology behind the Bitcoin. If you like the video please do subscribe, like, share and comment. To subscribe YouTube channel : https://www.youtube.com/channel/UC5I-... email: happycodingblog@gmail.com Blog: Happy4coding.blogspot.com Twitter: https://twitter.com/MadhanDevarajan

Introduction to Dynamics CRM

This video will help you understand the basics of Dynamics CRM in just 5 minutes. Description links: If you like this video, please do subscribe, like, share and comment.

Subscribe to YouTube : https://www.youtube.com/channel/UC5I-bCuSyY3MhV_dmfd_RcQ
Happy 4 Coding Blog: Happy4coding.blogspot.com 

Email: happycodingblog@gmail.com

To query the entities in Dynamics CRM from ADX Portal using jQuery

Introduction

This article demonstrates how to query the entities in Dynamics CRM using jQuery call and OData feeds from ADX Portal.

Steps to get records from Dynamics CRM entities:

It is difficult to get the Dynamics CRM Entities from ADX Portal using any Web API call, because that may require authorization token, client id and client secret etc. Also, you will not be able to get any client context or to use XRMServiceToolKit.

ADX Portal user can be just a contact in Dynamics CRM and would not be a user in CRM domain.  In this scenario, he will not be having access to Dynamics CRM entities directly.  He will be able to see the entities that are published in the ADX portal.

Here in the below example the user registers himself with the invitation code created in Dynamics CRM for Portal User having non-CRM domain email address (ex: Yahoo / Gmail / Hotmail).

Step: 1 Create a contact in Dynamics CRM with the external email address and then generate the invitation code for that contact.

Step: 2 With that Invitation code new user can be registered in the ADX portal.

Step: 3 Select the Dynamics CRM entities that you want to query from ADX Portal. Go to the Portals in Dynamics CRM and then select the Entity list to add entities that are to be published to ADX Portal as OData Feeds.

Step: 4 Also enable Entity Permissions to restrict the OData Feeds can be viewed by logged in Portal User.

Step: 5 Now go to the Custom JavaScript section in Entity list form or Web Page (Portals) use the ajax call for querying the OData feeds as shown below. 

$(document).ready(function (){

    var portaluser = '{{user.fullname}}';

    var filteroption = "fullname eq '" + portaluser + "'";

    var odataUri = "https://<Portal URL>/_odata/Contacts";

    odataUri += "?$filter=" + encodeURIComponent(filteroption);

    // ajax call to OData feeds of Contacts entity with the filter for finding current logged in user’s record

$.ajax({

        type: 'GET',

        contentType: 'application/json; charset=utf-8',

        datatype: 'json',

        url:  odataUri,                          

        beforeSend: function (XMLHttpRequest) {

            XMLHttpRequest.setRequestHeader('Accept', 'application/json');

        },

        async: true,

        success: function (data, textStatus, xhr) {             

           // Getting the company (Account) name that he belongs to

            var companyname = data.value[0].parentcustomerid.Name;

           

            $(".entitylist.entity-grid").on("loaded", function () {

                $(this).children(".view-grid").find("td[data-attribute='new_name']").each(function (i, e){

                    var attrvalue = $(this);

               // To remove other company’s records from the custom entity list view

                 if (!(attrvalue.context.innerText.contains(companyname))){

                        $(this).closest('tr').remove();

                    }

                });

            });

        },

        error: function (xhr, textStatus, errorThrown) {

            alert(textStatus + ' ' + errorThrown);

        }

    });

});

Output:

Measure Details View in CRM Portal:  The output displays only the records belongs to the account he is linked with.

Summary

In this article, I discussed how we can publish the entity as OData feeds and make use of ajax call to find records from the OData feeds. Hope it will be useful for you all, very soon will be back with a new article.  

JavaScript For Querying An Entity And Updating Attribute Values In Form

Introduction

This article demonstrates how to query an entity using FetchXML, JavaScript (XRMServiceToolKit), and how to update the form fields on form load or on change event.

Steps to implement JavaScript function in Dynamics CRM Form

JavaScript filename - TotalValueUpdate.js 

1. function TotalValues(FieldName, TotalFieldName) {  
2.     var countval = Xrm.Page.getAttribute("new_count").getValue(); // To get the field value of count – used in FetchXML query  
3.     var quarter = Xrm.Page.getAttribute("new_quarter").getValue(); // To get the field value of quarter – used in FetchXML query  
4.     quarter = quarter - 1;  
5.     var FieldValue = Xrm.Page.getAttribute(FieldName).getValue();  
6.     var fetchXML = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>" + " <entity name='new_report'>" + " <attribute name='new_reportid' />" + " <attribute name='new_name' />" + " <attribute name='" + TotalFieldName + "' />" + " <attribute name='createdon' />" + " <order attribute='new_name' descending='false' />" + " <filter type='and'>" + " <condition attribute='new_count' operator='eq' value='" + countval + "' />" + " <condition attribute='new_quarter' operator='eq' value='" + quarter + "' />" + " </filter>" + " </entity>" + "</fetch>"  
7.     var Records = XrmServiceToolkit.Soap.Fetch(fetchXML);  
8.     if (Records.length > 0) {  
9.         var prevTotalValue = Records[0].attributes[TotalFieldName].value;  
10.         var curTotalValue = prevTotalValue + FieldValue  
11.         Xrm.Page.getAttribute(TotalFieldName).setValue(curTotalValue);  
12.         return true;  
13.     } else {  
14.         Xrm.Page.getAttribute(TotalFieldName).setValue(FieldValue);  
15.         return false;  
16.     }  
17. }   

To add the above JavaScript file to Web Resource in Microsoft Dynamics CRM, please follow the below steps.
Go to the top ribbon, select the Settings icon and from there, click on the "Solutions" to create a new custom solution.

To create new solution, provide the values to the yellow highlighted fields shown below.

Then, select Web Resources from the left navigation and upload the JavaScript file using New icon (yellow highlighted).

Click on the Form Editor of the Report form to configure how and when the JavaScript function should be called on change event of a field.

Now, select the field and Change Properties from the top ribbon.

Select the Events tab and include all the highlighted JavaScript files by clicking "Add" icon. The most important thing in Event Handlers section is to select the Event OnChange and map the TotalValues() from the TotalValueUpdate.js.

Now, go to the Events Handler section, click on the Add button to mention the JavaScript library name from the dropdown and to specify the function name. Then, click OK once you are done.

Final output

Now, go to the entity form and check the value of Total values after entering this quarter value. It will be automatically adding the quarter value to the previous total and updating it to the current total value field.

I hope this article will be helpful for you to understand how to query Dynamics CRM Entities and update attributes in Form using JavaScript.