Javascript: multi value sort

Question

I have a problem that would be ideally handled by a RDBMS but I need it in Javascript. I was going to use Google gears but I have since discovered it's no longer in development.

What are some methods I could achieve the following?

I have a lot of products as JSON objects. Each has 3 properties I want to sort by, and I would want to be able to change the which property is sorted before the others. In SQL I might have written order by weight, height, power or other combinations.

The more powerful the solution the better, as I will probably want to expand requirements, all of which would be more easily handled by RDBMS, however I only want to know client-side options, as I will fall back to using a server-side RDBMS if absolutely necessary.

Thanks

Edit: Come to think of it, it might actually be quite simple just to use Array.sort(sortFn)?...

This post has similiar problem that the answers may help you: stackoverflow.com/questions/14245016/… — Gabriel Gartz
– Gabriel Gartz, Commented Jan 21, 2013 at 4:36
What will you do with the sorted objects? Is this just for presentation? Are you just sorting a table based on a column? — RobG
– RobG, Commented Jan 21, 2013 at 4:36

Jayy · Accepted Answer · 2013-01-21 04:54:52Z

1

Thanks Adam, and everyone, I will remember those for when my requirements evolve. Anyway, here's the solution I came up with...

function compare(a, b){
    var weight =    a.weight - b.weight;
    var power  =    a.power  - b.power;
    var height =    a.height - b.height;

    if (weight)  return weight;
    if (power)    return power;
    if (height)   return height;
    return 0;
};
objArr.sort(compare);

Thanks again

answered Jan 21, 2013 at 4:54

Jayy

14.9k27 gold badges108 silver badges168 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

tim-montague · Accepted Answer · 2014-12-19 23:42:12Z

0

Javascript Multi-Criteria / Multi-Parameter Sort

The easiest way to perform a javascript multi-criteria sort is to concatenate the criteria and compare them as 2 strings.

function sortByCriteria(data, criteria) {
    return data.sort(function (a, b) {

        var i, iLen, aChain, bChain;

        i = 0;
        iLen = criteria.length;
        for (i; i < iLen; i++) {        
            aChain += a[criteria[i]];
            bChain += b[criteria[i]];
        }

        return aChain.localeCompare(bChain);
    });
}

http://jsfiddle.net/oahxg4u3/6/

answered Dec 19, 2014 at 23:42

tim-montague

17.6k6 gold badges68 silver badges61 bronze badges

Collectives™ on Stack Overflow

Javascript: multi value sort

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related