Skip to main content

Tuleap 16 est là ! Assistez à l'événement virtuel le 17 octobre à 10h30. Inscrivez-vous ici !

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 #39685 Order artifact according to a field
Actions
Summary
Empty
Order artifact according to a field
Empty

Example: @status = OPEN() ORDER BY @last_update_date DESC: will return all open artifacts, the newest first

Rules:

  • Sort can be on any field that is present in all involved tracker (displayed or not, while it's un common to sort on a criteria not displayed with a Table rendering, it's quite common for Kanban rendering)
  • Sort is possible only on one field at time
  • It's possible to choose the order: ASC (aka ascending) or DESC (aka descending)
Empty
Empty
Status
Empty
On going
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
#39685
Kevin Traini (ktraini)
2024-09-16 17:15
2024-09-16 10:05
41299

References
Artifact links
Empty
Referencing story #39685

Artifact Tracker v5

epic #37567 SuperTableau - Full TQL mode
rel #37898 16.0

Git commit

tuleap/tuleap/stable

feat: Add TQL grammar for ORDER BY 9e9ade1bca
User avatar Kevin Traini (ktraini) , 2024-09-16 16:14
feat: Base structure to validate ORDER BY 40f2f8f410
User avatar Kevin Traini (ktraini) , 2024-09-17 11:47
feat: Show the same empty state for default reports 28d823d4e5
User avatar Joris MASSON (jmasson) , 2024-09-17 17:43
feat: Validate ORDER BY @metadata 3b913156b6
User avatar Kevin Traini (ktraini) , 2024-09-18 13:52
fix: e2e test does not find empty state 2b1520456c
User avatar Joris MASSON (jmasson) , 2024-09-19 09:57
feat: Validate ORDER BY field a97fc43da9
User avatar Kevin Traini (ktraini) , 2024-09-20 11:40
feat: Base structure to build ORDER BY SQL d123d5a0cd
User avatar Kevin Traini (ktraini) , 2024-09-23 10:22
feat: SQL for ORDER BY simple @ATF 4424646c27
User avatar Kevin Traini (ktraini) , 2024-09-23 10:53
fix: Order by is ran only on one page 8c5e862c0f
User avatar Kevin Traini (ktraini) , 2024-09-23 15:18
feat: SQL for ORDER BY date[time] field 351c5b149d
User avatar Kevin Traini (ktraini) , 2024-09-24 16:03
feat: SQL for ORDER BY numeric field 276c4ab068
User avatar Kevin Traini (ktraini) , 2024-09-26 10:34
refacto: stop repeating ourself when we retrieve field that user can 7e26e1a741
User avatar Clarck Robinson (robinsoc) , 2024-09-26 17:31
feat: SQL for ORDER BY text field 42e420bd48
User avatar Kevin Traini (ktraini) , 2024-09-26 16:43
feat: Build ORDER BY @title/@description fc708dcbf4
User avatar Kevin Traini (ktraini) , 2024-09-27 16:40
feat: Build SQL for ORDER BY static list field 846d62a391
User avatar Kevin Traini (ktraini) , 2024-09-30 08:46
feat: Build SQL for ORDER BY user group list field 250f99918e
User avatar Kevin Traini (ktraini) , 2024-10-01 11:50
feat: Build SQL for ORDER BY user list field 6dd1041997
User avatar Kevin Traini (ktraini) , 2024-10-03 15:41
fix: do not retrieve always there field when the field has changeset value 42c471334d
User avatar Clarck Robinson (robinsoc) , 2024-10-03 17:24
feat: Add syntax highlighting for ORDER BY 1d706573af
User avatar Kevin Traini (ktraini) , 2024-10-04 09:06
feat: Correct reading mode weird behaviours 376a2a0d90
User avatar Joris MASSON (jmasson) , 2024-10-04 15:32
Display settings

Follow-ups