Topic: Datatable default value and sorting behavior issue

wqzhou premium asked 3 years ago

Hi Devs,

I am trying to build a simple datatable that would display some numeric data. Data input is given below:

    var colArray = [{ 'label': 'A', 'field': 'AA' }, { 'label': 'B', 'field': 'BB' }];
    var rowArray = [{ 'AA': -10, 'BB': '0' },{ 'AA': 10, 'BB': '0' }, { 'AA': 111, 'BB': 0 }, { 'AA': 20, 'BB': Number(0) }, { 'AA': 100, 'BB': 0 }];

Numeric values are given in the data array for proper numerical sorting. 0 is a valid value. I encountered the following issue:

  • Number 0 is not recognized as a valid value when given as input data; instead, it is treated like a null value (default value '-' is used)

I think this issue is related to how the module sets the default value (by using || operator, but 0 is a falsy number in js). An alternative would be giving strings as input, but I am not sure how to specify proper sorting behavior on the column (I want numerical sorting (-10,10, 20, 100, 111), not lexicographical(-10, 10, 100, 111,20)). Any suggestions?

Expected behavior

All rows in column "B" should display a value of 0

Actual behavior

Only rows where string '0' given as data have 0 properly displayed

Resources (screenshots, code snippets etc.) enter image description here

Grzegorz Bujański staff answered 3 years ago

We will check it and fix it

Please insert min. 20 characters.


Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.



Specification of the issue

  • ForumUser: Premium
  • Premium support: Yes
  • Technology: MDB Standard
  • MDB Version: MDB5 3.8.1
  • Device: Desktop
  • Browser: Chrome 91.0.4472.124
  • OS: Windows 10
  • Provided sample code: No
  • Provided link: No