Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Query Builder allows you to write SQL statements like SELECT statements. While writing a query the query builder auto-suggest field names when the user inserts the table name and enters a dot (.), the field names of that tables are auto-suggest.

Info
iconfalse

Note: Custom Fields (of Requirements and Issue modules) which are mapped with Jira will not be displayed in QMetry Insight tables. Only QMetry Fields data and Jira System Fields data which are synced will be available for generating reports.



In case of a syntax error in a query, the query builder provides an ability to identify the error through the SQL Syntax Validator as shown in the below image.

...

  • SELECT *  clause is not allowed. Column names need to be specified in the select statement.
  • UPDATE and DELETE queries are not allowed.
  • GROUP BY on text column is restricted. QMetry reporting tables store custom/udf fields of type lookup & multi-lookup as text fields. Hence GROUP BY on these fields are not possible.
  • The gadgets other than table are generated on the 500 records.
  • While creating queries, during execution the query will return just the first 500 records. However all data is available in the reports export.


Info
iconfalse

Note: Custom Fields (of Requirements and Issue modules) which are mapped with Jira will not be displayed in QMetry Insight tables. Only QMetry Fields data and Jira System Fields data which are synced will be available for generating reports.


The test asset key will become clickable on the report if the column name contains the keyword (i.e. Entity Key), in any of the formats like -  "entity key" or "entityKey" or "entity-key" or "entity_key" in it.

...