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

    Thursday, October 22, 2015

    Remote desktop connection softwares

    We know the TeamViewer to full fill our requirement. Today i got one more software to do similar activities called Ammyy Admin

    Monday, October 19, 2015

    'advance' is unavailable: call the 'advancedBy(n)' method on the index

    'advance' API has been removed in Swift 2.0



    Below is some more examples







    Solution is in the screenshot and below is the reference
    http://stackoverflow.com/questions/32237243/advancedby-api-in-swift-2-0

    Saturday, October 10, 2015

    Access Is Denied: How to Identify and Fix a Security Role Issue in CRM 2015 Online

    Today got following issue

















    Log error :
    SecLib::AccessCheckEx failed. Returned hr = -2147187962, ObjectID: c27b7472-2210-e511-80fd-c4346bada1fc, OwnerId: 84055570-cf5d-e411-87c7-2c59e5420674,  OwnerIdType: 8 and CallingUser: 3466ec11-9283-e411-9cca-d89d6763df40.

    ObjectTypeCode: 1, objectBusinessUnitId: 8765d948-802f-e411-b567-2c59e5420674, AccessRights: AppendToAccess
    Resolution:
    Give the Bussiness Unit access level at Account entity.
    Resources:
    http://www.powerobjects.com/2015/02/13/access-denied-identify-fix-security-role-issue/
    http://www.consultcrm.co.uk/blog/2011/07/security-roles-microsoft-crm-2011