Int property sorting

Question

How do I get an int property to sort "normally?" 0, 1, 2 ,3...9, 10, 11... instead of the sort that is pictured in the first number below (below).

current sort in the view is being sorted by the following...

<script>

    $("#tbltrans").dataTable({

        order: [[0, 'asc']],

        "pageLength": 20

    });

</script>

I want to change the way the numbers (re: first number) sorts the view

Answer 1

Solution

create a hidden field/column as the first column of the view of the first int property of the two int property calculated field.

e.g.
IF Calculated Field =
ExampleIntProptery1 + ExampleIntProperty2

Create a hidden ExampleIntProptery1 column as the first column in the view.

            <th hidden>
                @Html.DisplayNameFor(model => model.ExampleIntProperty1)
            </th>                
                                    /
             <td hidden>
                    @Html.DisplayFor(modelItem => item.ExampleIntProperty1)
             </td>

Answer 2

you need to use a custom sorting plugin. see:

https://datatables.net/plug-ins/sorting/

you can build your own, if none of these do what you want.