StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>If you want to default order by id then you can add toString method to your Object and return the id as string as this is used by .sort:</p> <pre><code>var Item = function(orderId, forename, surname, heading) { this.OrderId = orderId; this.Forename = forename; this.Surname = surname; this.Heading = heading; }; Item.prototype.toString=function(){ return this.OrderId+""; }; // create a bunch of Items tmpArray.sort();// done, it's sorted by id now </code></pre> <p>If you want to sort it on certain key(s) then you can pass a sort function to tmpArray.sort</p> <pre><code>function sortItems(arr,keys){ var len=keys.length; arr.sort(function(a,b){ var i=0; while(a[keys[i]]===b[keys[i]]&&i<len){ i++; } return i===len?0:(a[keys[i]]>b[keys[i]])?1:-1; } }; // sort by Surname then by Forename (if 2 items have same Surname) sortItems(tmpArray,["Surname", "Forename"]); </code></pre> <p>Looking at your question again I see it's not the sorting that is the problem but the grouping. here is a function that would implement grouping for you.</p> <pre><code>var Item = function(orderId, forename, surname, heading) { this.OrderId = orderId; this.Forename = forename; this.Surname = surname; this.Heading = heading; }; // Creation of objects var obj1 = new Item(1, "James", "Smith", "Heading1"); var obj2 = new Item(2, "Tracey", "Janes", "Heading1"); var obj3 = new Item(3, "Sarah", "Cann", "Heading1"); var obj4 = new Item(1, "Matt", "Bars", "Heading2"); var obj5 = new Item(2, "Alex", "Magi", "Heading2"); var tempArray=[]; tempArray.push(obj1); tempArray.push(obj2); tempArray.push(obj3); tempArray.push(obj4); tempArray.push(obj5); function sortItems(arr,keys){ var len=keys.length; arr.sort(function(a,b){ var i=0; while(a[keys[i]]===b[keys[i]]&&i<len){ i++; } return i===len?0:(a[keys[i]]>b[keys[i]])?1:-1; }); }; // sort on Heading sortItems(tempArray,["Heading","Forename","Surname"]); function groupBy(arr,key){ var i=0,ret={}; for(i=0;i<arr.length;i++){ if(!ret[arr[i][key]]){ ret[arr[i][key]]=[]; } ret[arr[i][key]].push(arr[i]); } return ret; }; var grouped=groupBy(tempArray,"Heading"); var key="",i =0,ret=[]; // If any code in your page adds to Object.prototype then this breaks // like Object.prototype.mySmartFuncion since mySmartFunciton will show // up as key in for key in anyObject for(key in grouped){ ret.push(grouped[key][0].Heading); for(i=0;i<grouped[key].length;i++){ ret.push("\t"+grouped[key][i].Forename + grouped[key][i].Surname); } } console.log(ret.join("\n")); </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload