Clarification requested on query results.

[Sohail Aboobaker]

Hi,

We have a schema that contains categories (multi valued) for different
levels. Each level of categories are indexed in a different field. Each
category entry contains its parent in its value. The level is separated by
a "|" symbol. We are seeing following results for a faceted query:

http://localhost:8983/solr/select?q=level1categories:Artists&group=true&group.field=groupby&group.main=true&facet=true&group.facet=true&facet.field=level1categories&facet.field=level2categories&rows=0

In above, level1category is queried for "Artists" and we get following
counts:

<result name="response" numFound="4761" start="0"/>
   <lst name="facet_counts">
        <lst name="facet_queries"/>
             <lst name="facet_fields">
                 <lst name="level1categories">
                      <int name="Artists">4761</int>
                       <int name="Jewelry">0</int>
                       <int name="Watches">0</int>
                   </lst>
                  <lst name="level2categories">
                           <int name="Artists|Direct from the Artist">265
</int>
                           <int name="Artists|Art from Dealers &
Resellers">198</int>
                           <int name="Artists|Entertainment Memorabilia &
Cinema">14</int>
                           <int name="Artists|Wholesale Lots">10</int>
                   </lst>
             </lst>
          <lst name="facet_dates"/>
           <lst name="facet_ranges"/>

The count for level2categories --> Artists|Direct from the Artist  is 265.

When I filter on leve2categories:Artists|Direct from the Artist, I receive
776 results. I am using following query:

http://localhost:8983/solr/select?q=level2categories:Artists|Direct%20from%20the%20Artist&group=true&group.field=groupby&group.main=true&facet=true&group.facet=true&facet.field=level1categories&facet.field=level2categories&rows=0

or this

http://localhost:8983/solr/select?q=level2categories:Artists\|Direct%20from%20the%20Artist&group=true&group.field=groupby&group.main=true&facet=true&group.facet=true&facet.field=level1categories&facet.field=level2categories&rows=0

I was expecting that it would return 265 as row count but I get following
counts as response:

<result name="response" numFound="776" start="0"/>
<lst name="facet_counts">
    <lst name="facet_queries"/>
         <lst name="facet_fields">
         <lst name="level1categories">
           <int name="Artists">776</int>
           <int name="Jewelry">0</int>
           <int name="Watches">0</int>
          </lst>
          <lst name="level2categories">
               <int name="Artists|Art from Dealers & Resellers">198</int>
               <int name="Artists|Direct from the Artist">180</int>
               <int name="Artists|Entertainment Memorabilia &
Cinema">0</int>
               <int name="Artists|Wholesale Lots">0</int>
          </lst>
</lst>

What am I doing incorrectly? What is it filtering on to come to 776 total
rows?

Regards,
Sohail