How to Sort a Column with another Hidden Column

Problem:

I have a column A with inventory numbers ('Ma 856' or 'Ep 002'). So the type is text, but I want to sort it by the number part (856, 002).

I'm thinking of creating a hidden column B with just the number part.

I 'd like to sort A with B.

How I do that?

Solution:

If you want to sort a column with another hidden column, you will have to add the hidden attribute and specify sort direction by adding the sort-asc or sort-desc attribute on the <zg-column> tag of the column we intend to hide (Please use this demo for reference) Note: You will still need the sorter attribute on the <zing-grid> tag.