If the user wants to see record 2-4, he/she should get
I tried both facet and field collapse, it seems neither satisfies our
The problem of facet is it can only sort either on the number of counts
or the alphabetical order. If sort on counts, B will be returned before
The problem of using Field collapse is its pagination is based on doc,
not on group. In my pagination example, Doc 2-4 will be returned instead
of 3, 7, 9.
Does anyone have similar experience before? Any suggestions?