hi, would faceting work? http://www.lucidimagination.com/Community/Hear-from-the-Experts/Articles/Faceted-Search-Solr
if you have a field for rootId that is multivalued + facet on it -- you'll get value+count pairs back (top 100 i think by default) bec :) On 16 July 2010 16:07, Ninad Raut <hbase.user.ni...@gmail.com> wrote: > Hi, > > I have a scenario in which I have to find count of distinct unique IDs > present in a field (rootId field in my case) for a particular query. > > I require this for pagination purpose. > > Is there a way in Solr to do something like this we do in SQL: > > select count(distinct(rootId)) > from table > where (the query part). > > > Regards, > Ninad R >