Increase Row Count

[Dan Tolgyesi1]

Hi,

A while ago the row counts (where the user can select to show 10 / 20 / 50 / 100 rows etc) on each table was locked down to 20 rows.

I am unable to find out where I can increase this back to 100 (ideally only for myself). I have tried the rowcount under user preferences and increased this to 100 for myself but there has been no change after clearing my cache.

Can anyone help me or point me in the right direction as to where I can find it.

Thank you very much
Regards,
Dan

[Jim Coyne]

The platform-wide setting can be found under System Properties \ UI Properties. The property is called "'Items per page' drop-down options (comma separated, no spaces)". Changing it there would add 100 for everyone.

Or, like you did for yourself, you can change the user preference, BUT you need to log out then back in for it to take effect.

[Erik Stolberg]

This change can be done within the interface by any user (from what I can tell):

1. On Eureka and Fuji, load up a list page.
2. Right-click on the X to Y of Z record counter in top-right corner of page.
3. Select Show > X rows per page

[sammarcow]

jim.coyne estolberg Can this be accomplished with query string?

[Erik Stolberg]

What do you mean "query string" ...? If you're looking to run a script to update the values for all users or set a global value, it's best done by what jim.coyne gave already.

If you have a use case where you need to change/remove existing user preferences (e.g. change preferences for anyone who has 100 set instead of the default 20), you can script it, but if you're asking how to do that, I would say you should not be running scripts in the first place. However, in the spirit of a complete answer, I'll give the tables and encoded GlideRecord queries instead of complete code:

// change global user preference

table: sys_user_preference

query: name=rowcount^system=1

//change preference for all users with 100 rows set

table: sys_user_preference

query: name=rowcount^system=0^value=100

// change global system property

table: sys_properties

query: name=glide.ui.record.count