I'm not sure your point <3> makes sense. If you're searching by author, how do you define "the four most relevant titles"? Relevant to what?
If you are searching text of the publications, then displaying authors with no publications seems unhelpful. If you're searching the bios, how do you define "relevant titles"? Or are relevant titles based on some other criteria than you're searching on? But don't get stuck on worrying about duplicate data, denormalization of data is a common practice in Solr/Lucene. But I'm at something of a loss until you clarify what "relevant titles" means when searching for authors. Best Erick On Wed, Jul 18, 2012 at 2:36 PM, s215903406 <s...@s215903406.onlinehome.us> wrote: > Could anyone suggest the options available to handle the following situation: > > 1. Say we have 1,000 authors > > 2. 65% of these authors have 10-100 titles they authored; the others have > not authored any titles but provide only their biography and writing > capability. > > 3. We want to search for authors, group the results by author, and show the > 4 most relevant titles authored for each (if any) next to the author name. > > Since not all authors have titles authored, I can't group titles by author. > Also, adding their bio to each title places a lot of duplicate data in the > index. > > So the search results would look like this; > > Author A > title0, title6, title8, title3 > > Author G > no titles found > > Author E > title4, title9, title2 > > Any suggestions would be appreciated! > > > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Solr-grouping-facet-query-tp3995787.html > Sent from the Solr - User mailing list archive at Nabble.com.