lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xuesong Luo" <x...@successfactors.com>
Subject facet and field collapse
Date Thu, 04 Oct 2007 17:21:12 GMT
Hi, there,

Our index stores employee working history information. For each
employee, there could be multiple index records. The requirement is:

1.	The search result should be sorted on score.
2.	Each employee should only appear once regardless how many match
are found.
3.	The result should support pagination.

 

For example, if the original search result is:

 

doc=1, id=A, score=100
doc=2, id=A, score=90
doc=3, id=B, score=80
doc=4, id=A, score=70
doc=5, id=B, score=69
doc=6, id=B, score=68
doc=7, id=C, score=60
doc=8, id=C, score=59
doc=9, id=D, score=59
doc=10, id=E, score=58
...............
doc=206, id=B, score=40
.........
 
We want the final result to be:
 
Doc=1, id=A
Doc=3, id=B
Doc=7, id=C
Doc=9, id=D
Doc=10, id=E
 
If the user wants to see record 2-4, he/she should get
 
Doc=3, id=B
Doc=7, id=C
Doc=9, id=D
 
 
I tried both facet and field collapse, it seems neither satisfies our
requirement.
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
A. 
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? 
 
Thanks
Xuesong
 

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message