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.