'Database Query' Action

enaio® 10.10

The automatic action 'Database query' allows you to send SQL queries to the enaio® database. The results can be saved to a file.

If the SQL statement contains exactly two integer columns, these may be identified as the object ID and object type and saved to the portfolio of a particular user. The combination of several queries and different users permits you to periodically query and distribute task packages.

By saving the results of the query to a file, it is possible to create regular reports on the data pool which are then stored in the file system for further processing. The results of such a database query are saved in the semicolon delimited file format (CSV).

To use this action, add the axacreq.dll library (see ''Additions' Tab').

Enter a configuration name when setting up this automatic action.

The database query is configured in the following dialog:

Navigation

Navigate through the help pages using the table of contents on the left. If it is not displayed when the window width is small, you can temporarily show it via the hamburger menu on the right.

Use the arrows on the toolbar to navigate to the next/previous page.

You can show hidden areas. Use the toolbar to show all hidden areas at once:

Clicking the product icon in the header returns you to the beginning of the current area. Use the toolbar to access the initial page: