The actual SQL query to generate the data for the report is entered into the SQL Query area.
There is a checkbox below the Query area that allows you toggle between a simple text entry and a more robust editor. This editor has options for full screen mode, undo/redo, and go to line #. It is useful when writing more complex queries.
Basic Querying
SQL is a very powerful and complex programming language that can produce virtually any result desired. Constructing an SQL query requires considerable knowledge of SQL and of the data to be reported on.
An SQL query for an RMTrack custom report must produce a single result set, i.e. the SQL must return the results of a single SQL SELECT statement.
The regular RMTrack user interface provides a high level security in terms of which users can access which issues. When writing an SQL query for a custom report it is strongly recommended that the queries provide the same level of security. Please see Issue Row Level Security for more information.
For an overview of the basis RMTrack tables and fields, please the RMTrack Data Diagram.
We have included some example reports that might be of assistance as examples of SQL queries.
