Class Sort

When data needs to be sorted according to one or several attributes, we can use Sort to represent the sorting information and generate appropriate hyperlinks that can lead to sort actions.

A typical usage example is as follows,

async sampleRouteHandler(request, response, next)
{
    let sort = new Sort({
        attributes': {
            age',
            name': {
                asc': { first_name: 'asc', last_name: 'asc' },
                desc': { first_name: 'desc', last_name: 'desc' },
                default': 'desc',
                label': 'Name',
            },
        },
    });

    let models = Post::findAll({ where: { status: 1 }, order: sort.getOrders()})

    return response.render('/index.ejs', { models, sort, sorter });
}

View:

// display links leading to sort actions
<%- sort.link('name') + ' | ' + sort.link('age') %>

fore(let model of models) {
    // display model here
}

In the above, we declare two attributes that support sorting: name and age. We pass the sort information to the Post query so that the query results are sorted by the orders specified by the Sort object. In the view, we show two hyperlinks that can lead to pages with the data sorted by the corresponding attributes.

For more details and usage information on Sort, see the guide article on sorting.