Local Bind and filter or sort don't work

8 posts, 1 answers
  1. Gus
    Gus avatar
    29 posts
    Member since:
    Jan 2015

    Posted 15 Feb 2015 Link to this post

    hello,

    I am use this example http://dojo.telerik.com/AZamu/2, with local binding I was modify to sort and filter and it don't work, this is my code:

    <!DOCTYPE html>
    <html>
    <head>
        <base href="http://demos.telerik.com/kendo-ui/pivotgrid/local-flat-data-binding">
        <style>html { font-size: 12px; font-family: Arial, Helvetica, sans-serif; }</style>
        <title></title>
        <link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.common.min.css" />
        <link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.default.min.css" />
        <link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.dataviz.min.css" />
        <link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.dataviz.default.min.css" />

        <script src="http://cdn.kendostatic.com/2014.3.1411/js/jquery.min.js"></script>
        <script src="http://cdn.kendostatic.com/2014.3.1411/js/kendo.all.min.js"></script>
    </head>
    <body>
    <script src="../content/shared/js/products.js"></script>

    <div id="example">
        <div id="configurator"></div>
        <div id="pivotgrid"></div>

        <script>
            $(document).ready(function () {
                var pivotgrid = $("#pivotgrid").kendoPivotGrid({
                    columnWidth: 120,
                    height: 570,
                  filterable: true,
                    sortable: true,
                    dataSource: {
                        data: products,
                        schema: {
                            model: {
                                fields: {
                                    ProductName: { type: "string" },
                                    UnitPrice: { type: "number" },
                                    UnitsInStock: { type: "number" },
                                    Discontinued: { type: "boolean" },
                                    CategoryName: { field: "Category.CategoryName" }
                                }
                            },
                            cube: {
                                dimensions: {
                                    ProductName: { caption: "All Products" },
                                    CategoryName: { caption: "All Categories" },
                                    Discontinued: { caption: "Discontinued" }
                                },
                                measures: {
                                    "Sum": { field: "UnitPrice", format: "{0:c}", aggregate: "sum" },
                                    "Average": { field: "UnitPrice", format: "{0:c}", aggregate: "average" }
                                }
                            }
                        },
                        columns: [{ name: "CategoryName", expand: true }, { name: "ProductName" } ],
                        rows: [{ name: "Discontinued", expand: true }],
                        measures: ["Sum"]
                    }
                }).data("kendoPivotGrid");

                $("#configurator").kendoPivotConfigurator({
                    dataSource: pivotgrid.dataSource,
                    height: 570
                });
            });
        </script>
        <style>
            #pivotgrid
            {
                display: inline-block;
                vertical-align: top;
                width: 70%;
            }

            #configurator
            {
                display: inline-block;
                vertical-align: top;
            }
        </style>
    </div>


    </body>
    </html>

    Why It don't work wiht local bind?

    Thanks.


  2. Answer
    Georgi Krustev
    Admin
    Georgi Krustev avatar
    3718 posts

    Posted 16 Feb 2015 Link to this post

    Hello Gustavo,

    Currently, the client PivotGrid Cube supports only drill-down functionality. Sorting and filtering are not supported for the time being. They are in our TODO list, but I cannot provide any specific time frame whether they will be available.

    Regards,
    Georgi Krustev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  3. Anand
    Anand avatar
    1 posts
    Member since:
    Apr 2016

    Posted 31 Jan Link to this post

    Hi,

    Just wanted to do a quick check if this works now in the latest version. If yes, how as I am unable to make sorting work in PivotGrid.

    Thanks,

    Anand

  4. Georgi Krustev
    Admin
    Georgi Krustev avatar
    3718 posts

    Posted 01 Feb Link to this post

    Hello Anand,

    The client PivotGrid cube supports drill-down and filtering functionality. Label sorting is still not available. It is in our plans to provide support for it, but I wouldn't be able to provide any specific time frame for that.

    Regards,
    Georgi Krustev
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  5. Łukasz
    Łukasz avatar
    5 posts
    Member since:
    Jan 2017

    Posted 04 Apr Link to this post

    Hello Georgi,

    Any update with sorting functionality? I have this same problem like Anand, its going to be urgent ;)

    Regards

    Łukasz

  6. Alex Hajigeorgieva
    Admin
    Alex Hajigeorgieva avatar
    210 posts

    Posted 06 Apr Link to this post

    Hello Łukasz,

    Unfortunately, the Kendo UI PivotGrid does not have a sorting implementation at present. Our priorities shifted and we never got round to the client cube sort. I could give you some guidance, however, please be advised that we cannot guarantee the results. Behind the scene, we loop over the flat data and the dimensions consecutively (this is the relation columns <---> dimensions). So if you sort the data by dimensions in advance, there is a good chance to generate a pivot sorted by columns and by rows.

    There are some alternative solutions to get the Kendo UI PivotGrid sorted that you may read about on the web. They require the creation of a .cub file which can then be used as OLAP. I don't know if they will be fit for your purpose, it is beyond my expertise, however, I thought I would share this with you nonetheless:

    https://support.office.com/en-us/article/Work-with-offline-cube-files-a1014690-efb7-480d-b717-308a39063235
    https://www.mrexcel.com/forum/excel-questions/33837-i-want-create-cub-file-excel.html

    Kind Regards,
    Alex Hajigeorgieva
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  7. Łukasz
    Łukasz avatar
    5 posts
    Member since:
    Jan 2017

    Posted 11 Apr in reply to Alex Hajigeorgieva Link to this post

    Hi Alex,

    Thanks for Your response. W tried before to sort data in advance. Success is partial. Not all dimension will be sorted this method because of aggregations (one dimension gather other detailed - you need decide which one should be sorted). I was considering switch to Microsoft OLAP but our customer is not ready for additional costs for now.

    If something will change in your roadmap please let me know.

    Regards

    Lukasz

     

  8. Boyan Dimitrov
    Admin
    Boyan Dimitrov avatar
    1869 posts

    Posted 13 Apr Link to this post

    Hello,

    Also I would suggest to keep eye on our Release History

    Regards,
    Boyan Dimitrov
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top