Re: Find rows within range of other rows

2013-05-31 Thread bbarani
) Category3 (23) item 4 (23) If you are using old version of SOLR, you can follow these steps.. http://loose-bits.com/2011/09/20/pivot-facets-solr.html -- View this message in context: http://lucene.472066.n3.nabble.com/Find-rows-within-range-of-other-rows-tp4067115p4067428.html Sent from the Solr

Find rows within range of other rows

2013-05-30 Thread Mike Ree
I need to do a query where I need to find all people who have done 2 events within a range. I currently log one row per an event. Example: Person,Date,ViewedUrl 1,2012May10,google.com 2,2012May10,yahoo.com 1,2012May13,yahoo.com 2,2012May13,google.com Sample request would be wanting to find all pe