Sorting the resultset


(Valentin Pletzer) #1

Hi,

I am using filters to get a result which I sort by field A and then
limit with size. What I would like is to do is to sort the result by
field B. Is that possible? Both fields (A and B) have the type long.

Thanks
Valentin


(Shay Banon) #2

Yea, just sort on B instead of A, or are you asking if you can sort on
both? If so, then yes, just have both fields in the sorting part.

On Fri, Jan 20, 2012 at 3:17 PM, Valentin pletzer@gmail.com wrote:

Hi,

I am using filters to get a result which I sort by field A and then
limit with size. What I would like is to do is to sort the result by
field B. Is that possible? Both fields (A and B) have the type long.

Thanks
Valentin


(Valentin Pletzer) #3

Sorry. I didnt explain it well it enough. What I want is to sort only
the resulting 10 records by field B.

On Jan 20, 4:02 pm, Shay Banon kim...@gmail.com wrote:

Yea, just sort on B instead of A, or are you asking if you can sort on
both? If so, then yes, just have both fields in the sorting part.

On Fri, Jan 20, 2012 at 3:17 PM, Valentin plet...@gmail.com wrote:

Hi,

I am using filters to get a result which I sort by field A and then
limit with size. What I would like is to do is to sort the result by
field B. Is that possible? Both fields (A and B) have the type long.

Thanks
Valentin


(Karussell) #4

why not sort them in-memory on your own? it shouldn't make a
difference

Peter.


(system) #5