Skip to main content

Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

  •  
     
    story #38648 Choose my own columns based on semantics and always there fields
Actions
Summary
Empty
Choose my own columns based on semantics and always there fields
Empty

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

Empty
Empty
Status
Cross tracker search
Done
Development
  • [ ] Does it involves User Interface? 
  • [ ] Are there any mockups?
  • [ ] Are permissions checked?
  • [ ] Does it need Javascript development?
  • [ ] Does it need a forge upgrade bucket?
  • [ ] Does it need to execute things in system events?
  • [ ] Does it impact project creation (templates)?
  • [ ] Is it exploratory?
Empty
Details
#38648
Kevin Traini (ktraini)
2024-08-08 16:34
2024-06-27 15:51
40260

References
Artifact links
Empty
Referencing story #38648

Artifact Tracker v5

epic #37567 SuperTableau - Full TQL mode
rel #37896 15.12

Git commit

tuleap/tuleap/stable

feat: Validate selected metadata 059b8d354b
User avatar Kevin Traini (ktraini) , 2024-07-03 14:54
feat: Add select builder for title semantic 9cfb962f07
User avatar Kevin Traini (ktraini) , 2024-07-04 08:58
feat: Add select builder for description semantic 4fc52350f4
User avatar Kevin Traini (ktraini) , 2024-07-04 15:41
feat: Add select builder for status semantic 96639771e0
User avatar Kevin Traini (ktraini) , 2024-07-05 09:13
feat: Add select builder for assigned to semantic e42f2789ab
User avatar Kevin Traini (ktraini) , 2024-07-08 09:00
feat: Add select builder for always there fields 88a4e5cc94
User avatar Kevin Traini (ktraini) , 2024-07-08 15:56
fix: Empty XTS query should returns empty result c48d3311c8
User avatar Kevin Traini (ktraini) , 2024-07-10 15:20
feat: Build @title and @description API return d04d3151b6
User avatar Kevin Traini (ktraini) , 2024-07-11 10:47
feat: Build @status API return b547a84e69
User avatar Kevin Traini (ktraini) , 2024-07-12 11:07
feat: Build @assigned_to API return 1282e47f95
User avatar Kevin Traini (ktraini) , 2024-07-15 10:38
feat: Build @submitted_on and @last_update_date API return e90c33d183
User avatar Kevin Traini (ktraini) , 2024-07-16 08:53
feat: Build @submitted_by and @last_update_by API return 7f0fe5e3c0
User avatar Kevin Traini (ktraini) , 2024-07-22 12:08
feat: Build @id API return f377000499
User avatar Kevin Traini (ktraini) , 2024-07-22 12:20
refacto: Move all representation class to the same place 94e22d1fc1
User avatar Kevin Traini (ktraini) , 2024-07-22 12:21
feat: Show translated column names for semantics 71b62976a5
User avatar Joris MASSON (jmasson) , 2024-08-06 16:01
feat: Display User columns: Submitted by, Last update by 081cae31e9
User avatar Joris MASSON (jmasson) , 2024-08-07 12:31
feat: Display user list columns 68ae97f5cd
User avatar Joris MASSON (jmasson) , 2024-08-08 15:53
Display settings

Follow-ups