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/

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?

• http://www.powerobjects.com/2015/01/09/workaround-show-company-name-lead-views-dynamics-crm/

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

");

                            });
http://stackoverflow.com/questions/24994774/webapi-2-2-does-not-support-substringof-function

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

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