Denzil free answered 3 years ago

0 0 Best answer

Any updates on this one?

Krzysztof Wilk staff commented 3 years ago

Hi!

Yes, now elements with the "$" sign should be sorted correctly. :)

Best regards

Add comment

Denzil free answered 3 years ago

0 0 Best answer

Any news? Will be a game changer, can't use the component for now :(

Piotr Glejzer staff commented 3 years ago

we are working now on a new version of MDBReact so this will probably show in this version soon.

Denzil free commented 3 years ago

Thanks, looking forward. I hope a new version will be built on hooks? :)

Piotr Glejzer staff commented 3 years ago

The new version MDBReact with Bootstrap 5 will be built on hooks :)

But updated MDBReact with Bootstrap 5 will be still in classes.

Add comment

Caelan Marks free answered 3 years ago

0 0 Best answer

+1 for this feature, I want to be able to sort percentages 200.1% > 99.9% and the sort is not sufficient as is. To add, this doesn't work with floats either so it's pretty useless for sorting anything with decimal places.

Add comment

Denzil free answered 3 years ago

0 0 Best answer

Any updates on this one? The component is quite useless without proper number formatting sorting.

Add comment

Uttam Dutta free answered 3 years ago

0 0 Best answer

Hi Jakub,

As you have mentioned.

================

In one of the next versions, the datatable should accept data like search and searchValue -> the search will be displayed and searchValue will be used for sorting and filtering. But it's just the concept form, for now, you have to use what I have described.

Is there any update on this?

Piotr Glejzer staff commented 3 years ago

We will update this in the next versions. I don't why this still no resolved. I added the task to check it.

Add comment

Slavoljub Mihajlovic free answered 5 years ago

0 0 Best answer

@Jakub Mandra

I prepared data like $123,456.78 , $12,000 So the Salary was formatted with comma for every thousands and added currency symbol at the front But sorting is not working properly Can you help me how I can do it ?

Thanks, Slavoljub

Jakub Mandra staff commented 5 years ago

As I mentioned in my first answer for this post: DataTable should sort numbers normally, you have to set up the data in the proper format (Number).

So you should use 123456,78, 12000.

In one of the next versions, the datatable should accept data like search and searchValue -> the search will be displayed and searchValue will be used for sorting and filtering. But it's just the concept form, for now, you have to use what I have described.

Best,

Jakub

Jeffrey.Hendrikse free commented 4 years ago

Hello,

Has there been any progress on implementing this feature? it would be very nice to be able to sort formatted numbers.

Kind regards, Jeffrey

Konrad Stępień staff commented 4 years ago

Hi @Jeffrey.Hendrikse,

Not yet, but work in progress. We have to take a look at the component and sorting system. Sorry for problems, and please wait for new updates.

Best, Konrad.

Add comment

Jakub Mandra staff answered 5 years ago

0 0 Best answer

Hi,

DataTable should sort numbers normally, you have to set up the data in proper format.

Do not use string for numbers. Examlple:

<pre class="prettyprint"><code>import React from 'react';
import { MDBDataTable } from 'mdbreact';

const DatatablePage = () => {
  const data = {
    columns: [
      {
        label: 'Name',
        field: 'name',
        sort: 'asc',
        width: 150
      },
      {
        label: 'Position',
        field: 'position',
        sort: 'asc',
        width: 270
      },
      {
        label: 'Office',
        field: 'office',
        sort: 'asc',
        width: 200
      },
      {
        label: 'Age',
        field: 'age',
        sort: 'asc',
        width: 100
      },
      {
        label: 'Start date',
        field: 'date',
        sort: 'asc',
        width: 150
      },
      {
        label: 'Salary',
        field: 'salary',
        sort: 'asc',
        width: 100
      }
    ],
    rows: [
      {
        name: 'Tiger Nixon',
        position: 'System Architect',
        office: 'Edinburgh',
        age: 1000,
        date: '2011/04/25',
        salary: '$320'
      },
      {
        name: 'Garrett Winters',
        position: 'Accountant',
        office: 'Tokyo',
        age: 999,
        date: '2011/07/25',
        salary: '$170'
      },
      {
        name: 'Ashton Cox',
        position: 'Junior Technical Author',
        office: 'San Francisco',
        age: 10,
        date: '2009/01/12',
        salary: '$86'
      },
      {
        name: 'Cedric Kelly',
        position: 'Senior Javascript Developer',
        office: 'Edinburgh',
        age: 22,
        date: '2012/03/29',
        salary: '$433'
      },
      {
        name: 'Airi Satou',
        position: 'Accountant',
        office: 'Tokyo',
        age: 21,
        date: '2008/11/28',
        salary: '$162'
      },
    ]
  };

return (
 <MDBDataTable
 striped
 bordered
 small
 data={data}
 />
 );
}

export default DatatablePage;
</code></pre>

I think it should be considered in the documentation. Thanks for report.

Best,

Jakub

Please insert min. 20 characters.

Hi,

DataTable should sort numbers normally, you have to set up the data in proper format.

Do not use string for numbers. Examlple:

import React from 'react';
import { MDBDataTable } from 'mdbreact';

const DatatablePage = () => {
  const data = {
    columns: [
      {
        label: 'Name',
        field: 'name',
        sort: 'asc',
        width: 150
      },
      {
        label: 'Position',
        field: 'position',
        sort: 'asc',
        width: 270
      },
      {
        label: 'Office',
        field: 'office',
        sort: 'asc',
        width: 200
      },
      {
        label: 'Age',
        field: 'age',
        sort: 'asc',
        width: 100
      },
      {
        label: 'Start date',
        field: 'date',
        sort: 'asc',
        width: 150
      },
      {
        label: 'Salary',
        field: 'salary',
        sort: 'asc',
        width: 100
      }
    ],
    rows: [
      {
        name: 'Tiger Nixon',
        position: 'System Architect',
        office: 'Edinburgh',
        age: 1000,
        date: '2011/04/25',
        salary: '$320'
      },
      {
        name: 'Garrett Winters',
        position: 'Accountant',
        office: 'Tokyo',
        age: 999,
        date: '2011/07/25',
        salary: '$170'
      },
      {
        name: 'Ashton Cox',
        position: 'Junior Technical Author',
        office: 'San Francisco',
        age: 10,
        date: '2009/01/12',
        salary: '$86'
      },
      {
        name: 'Cedric Kelly',
        position: 'Senior Javascript Developer',
        office: 'Edinburgh',
        age: 22,
        date: '2012/03/29',
        salary: '$433'
      },
      {
        name: 'Airi Satou',
        position: 'Accountant',
        office: 'Tokyo',
        age: 21,
        date: '2008/11/28',
        salary: '$162'
      },
    ]
  };

  return (
    <MDBDataTable
      striped
      bordered
      small
      data={data}
    />
  );
}

export default DatatablePage;

I think it should be considered in the documentation. Thanks for report.

Best,

Jakub

Slavoljub Mihajlovic free commented 5 years ago

Can you help me @Jakub Mandra? I wrote current status in below message

Thanks, Slavoljub

Add comment

Jakub Mandra staff answered 5 years ago

0 0 Best answer

Hi,

DataTable should sort numbers normally, you have to set up the data in proper format.

Do not use string for numbers. Examlple:

<pre class="prettyprint"><code>import React from 'react';
import { MDBDataTable } from 'mdbreact';

const DatatablePage = () => {
  const data = {
    columns: [
      {
        label: 'Name',
        field: 'name',
        sort: 'asc',
        width: 150
      },
      {
        label: 'Position',
        field: 'position',
        sort: 'asc',
        width: 270
      },
      {
        label: 'Office',
        field: 'office',
        sort: 'asc',
        width: 200
      },
      {
        label: 'Age',
        field: 'age',
        sort: 'asc',
        width: 100
      },
      {
        label: 'Start date',
        field: 'date',
        sort: 'asc',
        width: 150
      },
      {
        label: 'Salary',
        field: 'salary',
        sort: 'asc',
        width: 100
      }
    ],
    rows: [
      {
        name: 'Tiger Nixon',
        position: 'System Architect',
        office: 'Edinburgh',
        age: 1000,
        date: '2011/04/25',
        salary: '$320'
      },
      {
        name: 'Garrett Winters',
        position: 'Accountant',
        office: 'Tokyo',
        age: 999,
        date: '2011/07/25',
        salary: '$170'
      },
      {
        name: 'Ashton Cox',
        position: 'Junior Technical Author',
        office: 'San Francisco',
        age: 10,
        date: '2009/01/12',
        salary: '$86'
      },
      {
        name: 'Cedric Kelly',
        position: 'Senior Javascript Developer',
        office: 'Edinburgh',
        age: 22,
        date: '2012/03/29',
        salary: '$433'
      },
      {
        name: 'Airi Satou',
        position: 'Accountant',
        office: 'Tokyo',
        age: 21,
        date: '2008/11/28',
        salary: '$162'
      },
    ]
  };

return (
 <MDBDataTable
 striped
 bordered
 small
 data={data}
 />
 );
}

export default DatatablePage;
</code></pre>

I think it should be considered in the documentation. Thanks for report.

Best,

Jakub

Please insert min. 20 characters.

Hi,

DataTable should sort numbers normally, you have to set up the data in proper format.

Do not use string for numbers. Examlple:

import React from 'react';
import { MDBDataTable } from 'mdbreact';

const DatatablePage = () => {
  const data = {
    columns: [
      {
        label: 'Name',
        field: 'name',
        sort: 'asc',
        width: 150
      },
      {
        label: 'Position',
        field: 'position',
        sort: 'asc',
        width: 270
      },
      {
        label: 'Office',
        field: 'office',
        sort: 'asc',
        width: 200
      },
      {
        label: 'Age',
        field: 'age',
        sort: 'asc',
        width: 100
      },
      {
        label: 'Start date',
        field: 'date',
        sort: 'asc',
        width: 150
      },
      {
        label: 'Salary',
        field: 'salary',
        sort: 'asc',
        width: 100
      }
    ],
    rows: [
      {
        name: 'Tiger Nixon',
        position: 'System Architect',
        office: 'Edinburgh',
        age: 1000,
        date: '2011/04/25',
        salary: '$320'
      },
      {
        name: 'Garrett Winters',
        position: 'Accountant',
        office: 'Tokyo',
        age: 999,
        date: '2011/07/25',
        salary: '$170'
      },
      {
        name: 'Ashton Cox',
        position: 'Junior Technical Author',
        office: 'San Francisco',
        age: 10,
        date: '2009/01/12',
        salary: '$86'
      },
      {
        name: 'Cedric Kelly',
        position: 'Senior Javascript Developer',
        office: 'Edinburgh',
        age: 22,
        date: '2012/03/29',
        salary: '$433'
      },
      {
        name: 'Airi Satou',
        position: 'Accountant',
        office: 'Tokyo',
        age: 21,
        date: '2008/11/28',
        salary: '$162'
      },
    ]
  };

  return (
    <MDBDataTable
      striped
      bordered
      small
      data={data}
    />
  );
}

export default DatatablePage;

I think it should be considered in the documentation. Thanks for report.

Best,

Jakub

Add comment

In one of the next versions, the datatable should accept data like search and searchValue -> the search will be displayed and searchValue will be used for sorting and filtering. But it's just the concept form, for now, you have to use what I have described.

Noah Lee