There are two settings that you can change to control the sort order of datasets and tables.
Dataset Sort Order
By default, the list of datasets shown in the catalogue screen is sorted in ascending alphabetical order.
If you prefer, you can display them in the order they were added to the catalogue in SuperADMIN. If you choose this order, then any new datasets you add in SuperADMIN will automatically appear at the bottom of the list, as opposed to being sorted alphabetically.
To change the setting, set the value of
catalogue.sortDatabases in the configuration.properties configuration file to
You will need to restart SuperWEB2 or the Tomcat service to apply this change.
Saved Tables Sort Order
By default, the Saved Tables section will sort the list of saved user tables in ascending alphabetical order. You can change this default if necessary so that Saved Tables sorts the tables in the order they were last modified (the most recently modified/created tables will appear at the top of the list).
Users can access a Preferences page where they can choose whether they want to sort tables alphabetically or in last modified order. The user preferences are accessible by default, but if you do not want to allow your users to change this setting you can prevent access to the user preferences.
Set the Default Sort Order
To change the default Saved Tables sort order to be last modified, use the following command in SuperADMIN:
If you want to revert to alphabetical order, use the following command:
The default will apply to all users who have not specifically set a preference in their SuperWEB2 user preferences page. Once a user has selected a preference, their selection will take precedence over anything you set in SuperADMIN.
Deactivate the Preferences Page
By default, users have access to a preferences page where they can select their preferred sort order for Saved Tables (this page also displays their Open Data API key, if they have access to the API):
If you prefer, you can prevent users from accessing this page. If you deactivate the preferences page, then the Saved Tables sort order will be determined by whatever you set in SuperADMIN (or will be alphabetical order by default if you do not set anything in SuperADMIN), and users will not be able to access their API key in SuperWEB2.
To deactivate the user preferences page:
- Open <tomcat_home>\webapps\webapi\WEB-INF\classes\configuration.properties in a text editor.
Locate the following setting:
Set the value to
- Save your changes and restart Tomcat or the SuperWEB2 service.