Table editors

For the data selected in the main window the table editors offer a direct access to the tables of the database. Underneath the menu Grid  select one of the Table editors. A window with the content of the table will open. Columns with a gray background can not be edited here. Columns with a light gray background are linked to the contents of lookup tables where you can change according to the contents of these tables. The following tables are included for direct access:

Depending on the edit mode the following options are available in the Table editors menue:

 

As an example see below the table editor window for projects.

 

Read-only

If for parts of the query result no write access exists, the table editor will be opened in read-only mode. Especially for descriptors you should keep in mind that they may belong to more than one project. Therefore the table editors for descriptors, categorical states and their resources or resource variants may be opened for read-only, if you have not write permissions for all projects in the database. 

 

Editing

You can either edit the contents of the table directly or perform changes to any number of marked fields. To mark a whole column use the  button. Once you have selected the contents to change, select one of the modes of change that appear in the upper left corner. The modes of change are:

After selecting the change mode, enter the text in the field where necessary and click on the corresponding button to perform the changes.

If you want to delete a line in the database, select it by clicking in the space before the line and press the button. Take care that an undo of that action is not possible.

 

Filtering

To filter the content of the table, click in the column that should be used for filtering. Then choose the mode of comparision:

If you want the filtering to be case sensitive, choose the a<>A option. After all parameters are set, click on the button. To undo the filtering, click on the button. This will reset the data to the last saved version. If you want your changes to be saved, click the button before you reset the filtering. If you close the window all changes so far will be saved automatically. If you do not want to save your changes, click on the button to close the window without saving.

 

Export

To export the data as a tab separated text file, click on the button. The file will be automatically saved in the client-folder.