Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I know the question is getting old but I made this functionality possible not long ago and got a pull request in the queue of SlickGrid projet on Github under my name. You could maybe try it out and give me some feedback. I modified 3 files to do so, including the example file. At this point, I do not know if my commit will be accepted or not, so try it at your own risk, though I'm very confident about my solution as I am already using it at work. Here is the link to it: <a href="https://github.com/mleibman/SlickGrid/pull/522/files" rel="nofollow">https://github.com/mleibman/SlickGrid/pull/522/files</a> </p> <p>Here is an example of 3 multiple columns grouping, this code portion comes from the <code>example-grouping.html</code> file which I modified as well. Defining multiple grouping works with arrays, very similar to previous implementation, just wrap it in arrays when defining multiple grouping. </p> <pre><code>function groupByDurationPercentageStart() { dataView.groupBy( ["duration", "percentComplete", "start"], [ (function (g) { return "Duration: " + g.value + " &lt;span style='color:green'&gt;(" + g.count + " items)&lt;/span&gt;"; }), (function (g) { return "Complete: " + g.value + " &lt;span style='color:green'&gt;(" + g.count + " items)&lt;/span&gt;"; }), (function (g) { return "Start Date: " + g.value + " &lt;span style='color:green'&gt;(" + g.count + " items)&lt;/span&gt;"; }) ], [ function (a, b) { return a.value - b.value; }, function (a, b) { return a.value - b.value; }, function (a, b) { // string sorting var x = a.value, y = b.value; return x == y ? 0 : (x &gt; y ? 1 : -1); } ] ); dataView.setAggregators([ new Slick.Data.Aggregators.Avg("percentComplete"), new Slick.Data.Aggregators.Sum("cost") ], true, false); } </code></pre> <p>Hope it helps you guys, now it really does have all features, I love this grid =)</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. This table or related slice is empty.
    2. VO
      singulars
      1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

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