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.
Save Tables
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 (this option is always available to logged in users).
- 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 saved shared table.
Load Tables
You can reload saved tables one of three ways: from Table View, from Manage Tables and from Datasets.
Table View
You can access saved tables direct from Table View. Click the Tables tab:
SuperWEB2 displays a list of all the saved tables you have access to for this dataset. Double-click a table to open it, or click once to select and click Open Table.
Manage Tables
Select the Manage Tables option from the menu in the top right of SuperWEB2:
- Select Manage Tables.
- 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.
Datasets
You can also access saved tables from the Datasets tab. This is displayed when you log in to SuperWEB2, or whenever you click the Datasets link in the top left corner:
To open your saved table, click the dataset it was created from, then go to the Tables list and double-click the table name. For example:
Manage Saved Tables
Manage Tables also allows you to rename saved tables, create new copies of saved tables, and delete saved tables:
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.
Copy 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.
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 Table Sort Order
Depending on how your administrator has configured SuperWEB2, you may be able to change the order that tables are listed in the Saved Tables tab.
To check and change this setting:
Click the menu button in the top-right corner and select Account:
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 this option, 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 Manage 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 for more information about using SuperWEB2 in large table mode.
Attachments:
SW2-Data-Cat-Saved-Tables9.9.8.png (image/png)
SW2-SwitchDB9.9.8.png (image/png)
SuperWEB2-TableView-SavedTables1.png (image/png)
SuperWEB2-TableView-SavedTables2.png (image/png)
SW2-SharedTableFolders.png (image/png)
SW2-Selectdatabaseortopic.png (image/png)
SW2-SaveTableName.png (image/png)
SW2-SaveTable.png (image/png)
SW2-Saved-Tables.png (image/png)
SW2-Preferences.png (image/png)
SW2-Preferences-2.png (image/png)
SW2-ManageTablesMenuOption.png (image/png)
SW2-Data-Cat-Saved-Tables.png (image/png)
JQM-Saved-Tables.png (image/png)