Features not working

[Stavros Menegos]

Hi,

I am using the latest version of Kendo UI i.e. 2017.3.921. I am trying to include in my solution the kendo-pivot but it seems that some of the features are not working:

1. The configuration option sortable enables the "Sort Ascending / Descending" options in the pivot grid BUT when clicked they do nothing. I tried in local binding demo and added the sortable: true just below the filterable property, and it does not work. I tied the same in the documentation of the sortable configuration setting but the dojo example does nothing

2. I have a kendo-pivot bound to a datasource with remote data of json type. I perform a read operation, the kendo pivot as well as the kendo configurator is populated with data. The pivot has only one Row dimension and no column fields (one measure, only). Should I expand the Row dimension to all its values and force a requery i.e. datasource.read() again the read function of the transport definition is execute OK BUT the statement options.sucess fails with the exception "cannot read property value of undefined"

 

function preparePivotDS(espqParams, esOptions) {
                var qParams = angular.isFunction(espqParams) ? espqParams() : espqParams;

                var xParam = {
                    transport: {
                        requestEnd: function(e) {
                            var response = e.response;
                            var type = e.type;
                            console.log(type); // displays "read"
                            console.log(response.length); // displays "77"
                        },

                        read: function(options) {

                            var pqOptions = {};

                            var executeParams = qParams.Params;
                            if (executeParams instanceof esGlobals.ESParamValues) {
                                if (!executeParams.isValidState()) {
                                    var err = new Error($translate.instant("ESUI.PQ.PARAMS_MISSING"));
                                    options.error(err);
                                    throw err;

                                }
                                executeParams = executeParams.getExecuteVals();
                            }

                            esWebApiService.fetchPublicQuery(qParams.GroupID, qParams.FilterID, pqOptions, executeParams)
                                .then(function(pq) {
                                    pq = pq.data;
                                    options.success(pq.Rows || []);
                                })
                                .catch(function(err) {
                                    $log.error("Error in DataSource ", err);
                                    options.error(err);
                                });
                        },

                    }
                };

                if (esOptions) {
                    angular.extend(xParam, esOptions);
                }

                return new kendo.data.PivotDataSource(xParam);
            }

[Stavros Menegos]

For the sorting issue, I found a similar thread in this forum, stating that sorting is only available to Olap data. The documentation of the sortable configuration property does not clarify this. Furthermore, I agree with a fellow reader, that in that case the sort icons and menus should be visible / available to the user.

Apart from that, should Progress is willing to support kendo-pivot on non olap data, then sorting should be supported. At least present the data sorted by measures either ascending or descending and not in the random order that are now presented.

 

[Konstantin Dikov]

Hello Stavros,

As documented in the following help topic, "The Kendo UI PivotDataSource has limited support for binding to flat data. Note that in this scenario not all of the features that are available when the widget is bound to an OLAP cube (such as sorting, hierarchies, and other) are supported."

• http://docs.telerik.com/kendo-ui/controls/data-management/pivotgrid/pivot-grid-faq#if-i-do-not-have-an-olap-cube-can-i-still-use-the-pivotgrid

As for introducing those features with the flat binding, you could vote in for the feature request in the public portal in order to increase their priority or log new ones:

• http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback/suggestions/18180664-add-sorting-to-kendo-ui-pivotgrid

Regards,
Konstantin Dikov
Progress Telerik

[Alex Hajigeorgieva]

Hello,

I am pleased to let you know that sorting by column and row headers with flat data is now implemented as of 2020 R3 release. You can take a look at the online demo:

https://demos.telerik.com/kendo-ui/pivotgrid/local-flat-data-binding

You can enable the sortable options in the field menu by adding sortable:true to the configuration options:

https://docs.telerik.com/kendo-ui/api/javascript/ui/pivotgrid/configuration/sortable

Regards,
Alex Hajigeorgieva
Progress Telerik