Table - based on a query
Display a table with two columns, name and number - one row for each card that has a property 'Priority' set to 'Critical' and a property 'Release' set to 'Release One.' As usual, quotes are used only when grouping words with spaces in them.
Macro markup is space sensitive and we advise you to stick to the indentation scheme specified in the example. If you add project as a parameter this needs to be added to a new line as shown in the markup below.
{{
table
query: SELECT name, number WHERE Priority = Critical AND Release = 'Release One'
project: project_one
}}
Preview
| Name | Meaning | Required | Default value |
|---|---|---|---|
| project | Any valid project identifier, specifying which project’s cards will be displayed. Authorization will be enforced upon view. That is, if a user does not have access to a project, that data series will not be included in the chart for that user. Default is the project to which the page or card containing the macro belongs. | No | Default is the project to which the page or card containing the macro belongs to. |
| query | A custom MQL query, the results of executing this query will be shown in the table. | One, and only one, of query or view is required. |