Solved

ListView Paging not working

  • 27 March 2017
  • 2 replies
  • 26 views

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.

icon

Best answer by khanh1 11 April 2017, 01:23

View original

2 replies

Userlevel 1
Badge +8

Hi  @MundoX


 


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


 


 

Userlevel 6
Badge +16

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.

Reply