Datatable Custom Sorting

[daniel.redgate]

Having trouble with the datatable again I have sorted data by Due Date before uploading the table as follows:

As you can see, it should sort by due date in ascending order. If i print out the text from the sorted due date search it shows the expected results (dates in ascending order):

However when i look at the table output, it isnt in any order:

It seems that however you feed the datatable, it is sorting things alphabetically by the first displayed column, which doesnt make any sense! it’s better not to sort and allow the user to do the sorting prior to feeding the datatable.

Am i missing something? Would love to be able to solve this and prevent customers from resorting the table every time they load the page!

Thanks,

Daniel

[Ecaterina]

Hello, dear.
Thanks for reaching us.

Let us please check this data filtering issue with devs. Once I have any useful updates - I’ll let you know. Apologies, it might take some time due to the weekend, so please be patient.

Additionally, we strongly recommend you to use join with and “,” at the end of the data item to display the list of items correctly.

Please find the screenshot below:

We apologize for this inconvenience.
BR,

[daniel.redgate]

format as text can be made equivalent to 'join with “,” ', by setting the delimiter. doesn’t make sense to add yet another item to the end of the search unnecessarily!

[Ecaterina]

Hello, dear @daniel.redgate

We investigated we issue with data filtering, which appeared during the plugin exploitation from your side.

Currently, all settings of this plugin are used from the libraries it uses and the plugin only accepts sorting in one format, namely yy/mm/dd or yyyy/dd/mm.

So, if you will use this format for your data filtering, the result will be correct.

We’ve taken into consideration the ability to change the date format for filtering in future updates. We need to see how feasible it is to implement. Thanks for understanding and for your feedback!

Hope it will help you.
BR,