Wednesday, November 25, 2015

CRM Useful JScripts

Have started development on CRM 2015 Online.
My reference links are below:
https://lakshmanindian.wordpress.com/2012/05/12/crm-2011-jscripts/

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
                        OData.read(queryUri, function (queryResponse) {
                            // for each result, add to list
                            $.each(queryResponse.value.results, function (o) {
                                $("#queryResultsList").append("

  • " + 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.












    https://www.youtube.com/watch?v=62mLfiNcqVM

    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.
    http://blogs.msdn.com/b/powerbi/archive/2015/10/20/custom-visualizations-support-and-22-other-features-in-the-power-bi-desktop-october-update.aspx