List Restrict Row Count

[kathymorris]

Hi,

Many of our users are setting their row counts at 200, and 100 for the list views.

I looked in the system properties. The wiki told me to type sys_properties.list (which did not work).

What do I need to do to restrict the number of rows to let's say 20 or 50?

Thanks,

Kathy

[Pradeep Sharma]

Hello Kathy,

Navigate to system properties->UI Properties->Search for Items per page' drop-down options (comma separated, no spaces)->Changing the value here would add it for everyone.

[Pradeep Sharma]

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.

[kathymorris]

Hi Pradeep,

I was traveling and did not have access to my laptop. However, yes your response was helpful.

Thanks

[Alikutty A]

Hi Kathy,

You can change the default value for system property 'glide.ui.per_page' to 20, 50.

Even if you change this value globally, it wont be effective for existing users. For new users who login this property becomes effective.

For existing users, you need to run a background job to reset their user preference to the highest value that you set for rowcount. You can use this script. This is one of best practice to tackle system performance issue.

var gr = new GlideRecord('sys_user_preference');

gr.addQuery('name=rowcount');

gr.query();

while(gr.next()){

gr.value = '50';   // highest value set

gr.update();

}

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response