Wednesday, November 25, 2015

CRM Useful JScripts

Have started development on CRM 2015 Online.
My reference links are below:

Tuesday, November 3, 2015

Customizing the Dynamics CRM views

Would like to change the leads view with following criteria.
  • ·         Lead should be filter by Country. Country is not rendering in views.
  • ·         Leads should be filter by created by. Not by owner.
  • ·         Leads should be filter by company name.
  • ·         Is it possible to see his colleagues changes/entries in entities?

Finally Publish the customizations. Done.

An unknown function with name 'substringof' was found.

While doing some client script have faced the issue.

  $.each(searchWords, function (key, word) {
                            if (key) filterWords += "%20and%20";
                            // double up any single quotes
                            word = word.replace(/'/g, "''");
                            // url escape word
                            word = encodeURIComponent(word);
                            filterWords += "contains(ProductName,'" + word + "')";

                        // create base portion of the URI
                        var queryUri = serviceUri + "Products?" +
                          "$select=ProductID,ProductName&" +
                          "$top=100&" +
                          "$filter=" + filterWords;
                        // configure datajs to allow cross domain callbacks using JSONP
                        OData.defaultHttpClient.enableJsonpCallback = true;
                        // run query
              , function (queryResponse) {
                            // for each result, add to list
                            $.each(queryResponse.value.results, function (o) {

  • " + this.ProductName + "
  • ");

    Monday, November 2, 2015

    Calculated and Measure columns in PowerBI

    Have been generating couple of reports using the calculated columns like the below.

    Sunday, November 1, 2015

    Power BI updates

    Generating reports using Power BI is part of my daily activities.
    Following link is for the latest updates of Power BI.