ListView Paging not working for SmartObject List method from SQL Server table (with PK).
I have almost 1M records inside. It takes 20+seconds to load any page on it even on the ListView or in SmartObject Tester utility.
Paging not available, top N not available. How could we use the List method not loading all the records ?
Regards,
MundoX.
Best answer by khanh1
That is quite a lot of records. Another approach is to filter the data at SQL level (i.e. build a SQL view), you can create a SmartObject from SQL view and use it in the list view.
Hi
Thanks for posting you question on our community it is much appreciated
To answers your question posted
The best viable option will be to enable filtering on the list view
Here is a K2 Help Article that explians the details on how to enable this in Smartforms
http://help.k2.com/onlinehelp/k2smartforms/userguide/4.7/default.htm#list_view_layout.html
If this was helpfull , please can you click on the drop down and mark this as Accept the Solution
Regards
Heinrich
That is quite a lot of records. Another approach is to filter the data at SQL level (i.e. build a SQL view), you can create a SmartObject from SQL view and use it in the list view.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
