Limit the number of records in list layout

[georgechen]

Is there a way to limit the number of records in list layout?       I've read Limit the number of Records display on Report ? which introduces a script include code, but I wonder if there is a Filter options accomplish the same?

Thanks,

[cwilkerbb]

George,

Another option, depending on your actual application, is to set the URL on the left nav and pass this URL parameter:

sysparm_userpref_rowcount=1000

where 1000 is your rowcount.  

You could also investigate changing the User Preferences, creating one for "System" that will set the "rowcount" to whatever you want by default.  

Note that neither of these prevent the user from changing the rowcount.

-Chris

[georgechen]

Thanks Chris.   I tired sysparm_userpref_rowcount=1000 the list seeks to fetch 1000 records at a time, if you click 'next page', it moves to record 1002.

another parameter sysparm_force_row_count=1   it seems to pull out one record when the module loads; when you perform a search it shows more than one records depends on your previous sysparm_userpref_rowcount setting

Is the finding correct?

[cwilkerbb]

George,

That sounds about right.   The userpref gets saved in the "User Preferences" so the "1000" would be consistent for that table.   for_row_count might work better as it might not save it in the User Preferences.

-Chris