Administration queries ​
Using administration queries you can carry out queries concerning databases (user, user groups, model groups, and/or models).
In the window "<Library name> - Administration queries", the results of a query are displayed in the ADOxx browser.
You can use the following functions from the context menu (right mouse button):
| Functions | Description |
|---|---|
| Users | to manage users, |
| User groups | to manage user groups, |
| Model groups | to manage model groups, |
| Options | to change the settings for the content of the result browser. |
In addition to this, the results of the query can also be saved, printed or copied into the deposit station for data transfer.
Attention
Upon performing very extensive queries (e.g. with result sets of more than one million lines), determining the results can take a considerable amount of time and during scrolling or column width adjustments, busy times can occur. Thus we recommend to adapt the options, i.e. to reduce such queries to two or three colums and/or to delimitate the result using the filter options provided.
Administration queries - Settings ​
In the window "Administration analysis - settings" the user can define query composition, i.e. which columns and with what kind of information should be displayed.
If you click on the button "Set Filter", you can display the entries of each column by defining the search term.
Hint
After defining a search criteria (filter) the button is labeled with "Edit Filter" to indicate that a filter is activated.
If "Repeat query result values in each row" is checked, the result values will be shown in each line. Otherwise the result will be displayed as usual.