jqxGrid Default Sorting – Server side pagination

[MuthukumarParticipant]

Good Morning,
We are using jqxGrid for AngularJs 2. We have implemented server side pagination and the stored procedure returns recordset sorted on ‘ID’ column by default.
When I click sorting arrow button at the header of ‘ID’ columns, a Sort menu is displayed but all the three menu items: Sort Ascending, Sort Descending and ‘Remove Sort’ are enabled. The expected behavior is to show the menu with ‘Sort Ascending’ disabled and the other two options enabled.
In case, if ‘Sort Ascending’ / ‘Sort Descending’ menu item is clicked, the menu is not dismissed, it remains in the screen. But the sorting is happening and the grid is refreshed with the data.
This behavior is observed only for the first time when I invoke Sort menu. Once it is sorted, the subsequent invocation menu shows the menu items properly disabled/enabled.

Is there a way to specify ‘ID’ column as the default sort column to jqxGrid?

Thank you,
Muthukumar S

[Peter StoevKeymaster]

Hi Muthukumar S,

In the data source, you can set the sortcolumn member.

Ex:

    sortcolumn: 'ShipName',
    sortdirection: 'asc'

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[MuthukumarParticipant]

Hi Peter,
It does not resolve the issue. We noticed that it throws the following error in browser console when we invoke the Sort menu for the first time:

:60688/nodelib/@angular/core/bundles/core.umd.js:3010 TypeError: e[c] is not a function at a.(anonymous function).propertiesChangedHandler (http://localhost:60688/js/jqwidgets/jqxmenu.js:7:16745) at Object.a.jqx.set (http://localhost:60688/js/jqwidgets/jqxcore.js:8:21915) at Object.a.jqx.jqxWidgetProxy (http://localhost:60688/js/jqwidgets/jqxcore.js:8:23409) at HTMLDivElement.<anonymous> (http://localhost:60688/js/jqwidgets/jqxcore.js:8:28587) at Function.each (http://localhost:60688/XXXXX/lib/jquery/dist/jquery-3.2.0.js:362:19) at jQuery.fn.init.each (http://localhost:60688/XXXX/lib/jquery/dist/jquery-3.2.0.js:157:17) at jQuery.fn.init.a.fn.(anonymous function) [as jqxMenu] (http://localhost:60688/js/jqwidgets/jqxcore.js:8:28490) at a.(anonymous function)._arrangemenu (http://localhost:60688/js/jqwidgets/jqxgrid.js:7:15235) at n (http://localhost:60688/js/jqwidgets/jqxgrid.js:9:31765) at HTMLDivElement.<anonymous> (http://localhost:60688/js/jqwidgets/jqxgrid.js:10:1614)

Thank you,
Muthukumar S

[Peter StoevKeymaster]

Hi Muthukumar ,

We cannot reproduce such error unfortunately.

Best Regards,
Peter Stoev
jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts