: fq={!frange l=5 u=10}sum(user,num)
Hmmmm, One of us massivly missunderstood the original question - and i'm
pretty sure it's Yonik.
i don't think he wants results where the user field plus the num field are
in the range of 5-10 ... i think he wants the list of user Ids (which are
numbers in his examples, but could just as easily be strings) where the
sum of the "num" fields in all documents that have the same value in the
"user" field are the same.
I can't think of any easy way to do that ... it isn't the kind of thing an
Inverted Index is particuaraly good at. but maybe there's soemthing in
the Field Collapsing patch (searching the archives/wiki will bring up
pointers) that can filter on stats like this?
: On Mon, Nov 23, 2009 at 8:49 AM, Julian Davchev <j...@drun.net> wrote:
: > Hi folks,
: > I got documents like
: > user:1 num:5
: > user:1 num: 8
: > user:5 num:7
: > user:5 num:1
: > ....
: >
: >
: > I'd like to get per user that maches sum of num range 5 to 10
: > In this case it should return user 5 as 7+1=8 and is within range.
: > User 1 will be false cause sum of num is 5+8=13 hence outside range 5 to 10
-Hoss
