You can save your tables inside SuperWEB2. Once saved, the table definitions will be available again the next time you log in to SuperWEB2.
Tables saved by users in SuperWEB2 are typically private (only visible and accessible to the user who created the table). Depending on how your administrator has configured SuperWEB2, you may also be able to load and save shared tables, which are accessible to multiple SuperWEB2 users.
Click the Save icon to save the current table:
You will be prompted to select the save location and enter a name for the table. Choose your name and location and click Save:
Depending on how your system administrator has configured SuperWEB2, you may have a choice of save locations:
- Choose the Private folder to save a table that is accessible to you only.
- Choose any of the shared folders (indicated by the shared folder symbol, ) to save a table that will be accessible to other SuperWEB2 users. You will only be able to save to a shared folder if your administrator has given you permissions to save to that folder. The folder permissions will also determine which other SuperWEB2 users will be able to access the folder. Check with your administrator to confirm how permissions have been set up in your SuperWEB2 deployment.
The name of the table must be less than 255 characters long. When you save tables to the Private folder, they must have a unique name; tables saved to a shared folder can have the same name as an existing table saved shared table.
Load a Saved Table - My Tables Tab
Once you have saved a table, you can access that table again from the My Tables tab.
- Select the My Tables tab.
- Select the table you want to reopen.
- Click Open.
If you currently have a table open, then SuperWEB2 displays a message warning you that any unsaved table content will be lost (this means that the selected table will replace the currently active table). Click OK.
- Your saved table displays.
Load a Saved Table - Data Catalogue
You can also access saved tables from the database catalogue. The catalogue is displayed when you log in to SuperWEB2, or whenever you click the Catalogue link in the top right corner:
To open your saved table from the catalogue, go to the Databases list and click the database it was created from, then go to the Tables list and double-click the table name. For example:
Manage Saved Tables
The My Tables tab includes options for renaming saved tables, creating new copies of saved tables, and deleting saved tables:
To rename a saved table (this option is available for private saved tables only):
- Select the check box next to the table you want to rename.
- Enter a new name in the text box.
- Click Rename.
To create a copy of a saved table (this option is available for private saved tables only):
- Select the check box next to the table you want to copy.
- Click Copy.
To delete a saved table:
- Select the check box next to the table or tables you want to delete.
- Click Delete.
- Click OK to confirm you want to delete the table or tables. Make sure you check that you are deleting the correct table or tables, as there is no way to undo the deletion.
Change the Sort Order for My Tables
Depending on how your administrator has configured SuperWEB2, you may be able to change the order that tables are listed in the My Tables tab.
To check and change this setting:
Click the menu button in the top-right corner and select Preferences
Choose between Alphabetical (tables will be displayed in ascending alphabetical order) or Last Modified (the most recently modified/created tables will appear at the top of the list).
- Click Save.
If you do not see the Preferences option on the menu, then this means that your administrator has turned off the ability to set this preference. Your saved tables will be displayed in the order set by your administrator (by default, this is alphabetical order).
Large Table Downloads
If your system has been configured to use the Job Queue Manager feature, then the My Tables tab may also show details of large tables that you have queued for download. You can use the options to check the status of large table queries, download any tables that have completed processing, and manually delete the tables:
See Large Tables - SuperWEB2 for more information about using SuperWEB2 in large table mode.