Get current sort order for particular column

xtech_dev

Hello,

Is there any way to receive column sort order inside render function?

I have a requirement to apply two different sorting rules: one for ascending and other descending sort order.

IT Man?

colin

Hi @xtech_dev ,

columns.render would be no good for those, since the values are cached on first access, so if direction was changed, it wouldn't be picked reflected.

What you need is to develop a sorting plugin - here, you can define different behaviour for ascending or descending. This page here has several already made - and this one here could be good to use as a template.

Cheers,

Colin

xtech_dev

Thanks for this clue, I will read the docs.

xtech_dev

Ok, got the idea - looks fine.

Is there any way to specify sort/order extension explicitly as part of columns (https://datatables.net/reference/option/columns)?

I have only seen something like "columnDefs": [{ "type": "numeric-comma", targets: 3 } ] but this seems to split column configuration into multiple places.

colin

Hi @xtech_dev ,

Yep, it can go in either - see columns.type - the examples have both ways of declaring it.

Cheers,

Colin

xtech_dev

OK, type will point which sort function to use.

But will it influence any other features,can i change it without consequences other than changing sort implementation?

colin

Hi @xtech_dev ,

The type can also affect the filtering, but that's unlikely to have an effect (or you would've spotted it!). So yep, you're good to go

Cheers,

Colin