Grid data - sorting by subfacets

[Matthew Griffiths]

Hi,

We are using heliosearch to generate the values for a data grid using a combination of subfacets and facet functions like this:

&facet.field=FIELD1&subfacet.FIELD1.field=FIELD2&f.FIELD2.facet.stat=total_amount:sum(Amount)

This gives us a grid (a bit) like this:

               | FIELD2_VALUE1 | FIELD2_VALUE2 | FIELD2_VALUE3 |

----------------------------------------------------------------

FIELD1_VALUE1  | 123           | 234           | 345           |

FIELD1_VALUE2  | 789           | 890           | 901           |

We want to offer sorting of the grid by column but can find no way to do this in the query.

We are currently reading all value into memory and then sorting in the code but performance is low.

Can you provide any direction as to how this can be achieved?

Many thanks, Matt