Configure default value for number of records per page

[Achim]

Hi,

 

is there a way to cofigure the default value for the number of records per page for all users? We would really like to set this password grid option for all users to a higher default value than 10.

 

Thanks and regards

Achim

[support]

Hi Achim,

 

Sorry, this is not currently possible - mainly because users can have different screen resolutions, and they may not want more than 10 records to be displayed at a time.

If you want, you can execute a SQL command against the DB like below to update for all users:

USE Passwordstate

UPDATE [UserAccounts] SET P_Records = 20

Regards

Click Studios

[Achim]

Hi,

 

nevertheless it would be great if there was a system setting for this.

 

Unfortunately the update of the "P_Records" value didn´t work for us. Any suggestions why this did not work?

We updated the value in the database but nothing changed.

 

Regards

Achim

[support]

Hi Achim,

 

The only reason that command should not have worked is because:

• You need to log out, then back in to pick up the change
• Or on a Password List, you have previously saved the Grid layout, or the number of records to display - this would override this setting in the UserAccounts table.

 

Regards

Click Studios

[Achim]

Hi,

 

Thank you for your quick response.

We tried both possibilities but those didn´t seem to be the problem.

 

Regards

Achim

[support]

Hi Achim,

 

I did test that SQL Statement before I posted it here. For item 2, you can only test this if you deleted data from the GridSettings table - is this what you did?

 

Regards

Click Studios

[Achim]

Hi,

 

we tested this by looking for this setting in the screen options in an account where no changes were made.

There the number of records per page was 10 and not the value we took for "P_Records" in the database.

 

Regards

Achim

[support]

Okay, thanks Achim.

[Sarge]

13 hours ago, Achim said:

nevertheless it would be great if there was a system setting for this.

 

A system wide setting I don't agree with, however perhaps one that is configurable by User Account Policies, and overwritable via the user from their User Preferences screen.

Not sure how nicely that would play with the password lists settings for number of records to display. Perhaps the individual password list settings would take precedence over the user preferences settings, and the user preferences settings could be set to a default (but changeable) value via User Account Policies.