columnSorting custom config

Tags: #<Tag:0x00007efc620fca98>
#1

Hey guys, does anybody know if there is a way to set a custom columnSorting config something like:

const tableSettings = { columnSorting: [{ column: 0, sortOrder: "asc" }, { column: 4, sortOrder: "desc"  }] }

I already went through the docs, and have not encountered anything like that, but there might be something I am ignoring. The idea is to set a multi column sort if possible, I know hands on table already support multi column sort, but wanted to accomplish it without upgrading hands on table version.

Is there another way around this?, was going to perform the sorts by my own and then update table data, is there a better approach?

Last question though, is there a way to use custom sort indicators instead of the default ones?

#2

Hi @jnosornov

Here it is https://jsfiddle.net/uzagxLvr/

You need to remember to replace your columnSorting by multiColumnSorting (line 10). Only then you can pass two objects for the initialConfig.

Here https://handsontable.com/docs/7.4.2/demo-multicolumn-sorting.html on the Default compare functions (sorting different kinds of data) paragraph you have an example (along with the explanation) on how to create custom sorting.

Let me know if you’d need anything more than that.

#3

Hey @aleksandra_budnik, one last question though

multiColumnSorting is available in hot since version 7, right?, If so, does hot settings also need to be set as a non-commercial version?, read in the docs multiColumnSorting is a PRO feature, what does it mean?, could you elaborate on the topic?.

Thanks for your time!!

Also, looking to collaborate to hot ecosystem, any path you would suggest?, should I go first for the core, and then the library wrappers like react-hot.

#4

Multi-column Sorting was firstly introduced in version 6.0.0 https://handsontable.com/docs/6.0.0/tutorial-release-notes.html for the Handsontable PRO version (paid version, under custom license). Since version 7.0.0 there’s only one version of Handsontable (free for non-commercial, paid for commercial).

Also, looking to collaborate to hot ecosystem, any path you would suggest?, should I go first for the core, and then the library wrappers like react-hot.

Can you share some details?

#5

@aleksandra_budnik hey sorry for the late response,

I just started reading the code base, once I fill confident enough I will try to handle some issues, if you have any advice it would be great, will reach to you or anyone else in the forums for doubts if any.

#6

once I fill confident enough I will try to handle some issues

You can also communicate with me one on one on emails (support@handsontable.com) if that’s more convenient.

#7