Friday, 26 June 2015

Sitecore query analyzer in returning wrong Count

I was trying to get count of number of subitems within my ItemPath using below query select count(ItemPath/* ) but this query is returning always 500 though the number of items
select count(ItemPath/* ) but this query is returning always 500 though the number of items
Sitecore climber  suggest to check below properties 

   <!--  Query.MaxItems
            Specifies the max number of items in a query result set.
            If the number is 0, all items are returned. This may affect system performance, if a
            large query result is returned.
            This also controls the number of items in Lookup, Multilist and Valuelookup fields.
            Default value: 100
      -->
      <setting name="Query.MaxItems" value="500" />

It worked

https://community.sitecore.net/developers/f/8/p/512/1955#1955

No comments:

Post a Comment

Featured post

Getting Started With SOLR

Getting Started with Solr ·           Features o    Hit highlighting o    Auto correction o    Faceted Search o    Multi lan...