The TQL grammar is extended with a SELECT keyword that precedes the previously existing "filtering" conditions. I can write several field names (separated by commas ,) from the selected trackers.
SELECT is optional (to maintain backwards-compatibility of TQL language). When it is absent, the default set of columns is shown: Tracker badge and artifact title, Project label, Status, Last update date, Submitted by, Assigned to.
SELECT @id, @title WHERE @last_update_date > NOW() -1m
The previous example will show two columns @id and @title. Those columns will show the artifact values for always there field artifact id and semantic title.
Allowed semantics:
-
@title
-
@description
-
@status
-
@assigned_to
Allowed always there fields:
-
@submitted_on
-
@last_update_date
-
@submitted_by
-
@last_update_by
-
@id
A given field (for example @id) can only be selected once. For example SELECT @id, @title, @id will raise an error.
Figma mockup: https://www.figma.com/design/oDjT4tC3fDGP5P4JdKfkdE/Columns-choices---ST?node-id=67-21319