Query Analyzer

Repository > Query analyzer tile

Purpose of the page

From this page, you can launch queries on data within the current database To see the tile and use this feature, the following function needs to be enabled in the user's role:

0002286 - Repository - Tools - Query Analyzer

0002287 - Repository - Tools - Tools - Query Analyzer (Restricted)

for the query analyzer on the Repository

The following functions

0002305 - Query Analyzer

0002306 - Query Analyzer (Restricted)

for the query analyzer on the application database

Users with Query analyzer (Restricted) functions will be able to use in the query the only function: Select, with read-only data

Users with Query analyzer functions, on the other hand, are enabled to edit the database and can use all functions: select, insert, delete, update.

Page fields

Please find below the most important fields.

Field	Description
SQL queries	text of the query to be run
Run	to run the query entered
Number of rows	specifies the number of rows to be returned by the query. By default, the system returns 50 rows;
Result	result returned by the query If the query execution fails due to SQL syntax errors, the system returns an error message.