Why multilist field is not showing all the items in Sitecore

I have just started working on new Sitecore project. From couple of weeks I was busy on requirement gathering and doing a manager kind of works (Boring). Programming, coding and technical stuffs are my first love.

Within this new project, one of my teammate created one folder in Sitecore and populated 400 items within it. He pointed that folder to multilist control.

He started complaining that he is not getting all the 400 items of folder in Multilist. I thought he was doing something wrong.

Later on I didn't found any reason why multilist is showing only first 100 records and why not showing all 400 items?

Solution:-

I come to know that there is one setting in web.config file where it’ss mentioned that multilist and valuelookup control will only show first 100 items. If you want to show all the items then keep its value to 0.

<!--  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="100" />

But Sitecore also warns that if you set its value to 0 than it may affect Sitecore performance for large results set.

I am big fan of Sitecore configuration technique.

Please leave your comments or share this trick if it’s useful for you.