Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
Select TOP 100 on Mediachase.BusinessFoundation.Data.dll
By default there is a limitation of 1000 BF entities being returned. You can change that value in Configs\baf.data.metaobject.config, change maxListObject to a bigger value. Note that a too big value can affect performance.
Regards,
/Q
May 15, 2017 16:24
<p>Hey </p>
<p></p>
<p>Can we make it to 100000 ? what is the maximum number I could have in this config?</p>
#183410
Oct 12, 2017 17:52
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
I had an issue with my client because some of the Sizes configured are not returning from BusinessManager.List. After some investigation, I found using the SQL Server Profile the queries are executed with TOP 1000.
My client in this moment has 1117 different sizes.
exec sp_executesql N'SELECT TOP 1000 [t01].[SizeId] AS [SizeId], [t01].[SizeName] AS [SizeName], [t01].[SizeCode] AS [SizeCode] FROM [cls_Size] AS [t01]'I developed a solution to get the information from this table.
Can I consider this an EpiServer issue?
There is a solution or path to fix this issue?