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 #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
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
#39685
Kevin Traini (ktraini)
2024-10-17 10:21
2024-09-16 10:05
41312

References
Artifact links
Empty
Referencing story #39685

Artifact Tracker v5

epic #37567 SuperTableau - Full TQL mode
rel #37898 16.0
request #40093 Organize reading / writing components

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
chore: @tuleap/prism-language-tql is now v1.1.0 22da10c346
User avatar Kevin Traini (ktraini) , 2024-10-04 17:20
fix: TQL accept NBSP as whitespace b0c5f2cb72
User avatar Kevin Traini (ktraini) , 2024-10-08 12:01
More explicit message when XTS keywords are used in Tracker Report eda752ee83
User avatar Clarck Robinson (robinsoc) , 2024-10-08 14:58
Display settings

Follow-ups

User avatar
Joris MASSON (jmasson)2024-10-17 10:14
  • Acceptance criteria
    Something went wrong, the follow up content couldn't be loaded
    Only formatting have been changed, you should switch to markup to see the changes
  • Is related to
    • Added is Covered by: