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.

    •  
      request #44454 TQL "count" function
    Actions
    Infos
    #44454
    Tuleap PCC (tuleappcc)
    2025-08-27 18:03
    2025-08-26 20:44
    46157
    Details
    TQL "count" function

    As a: Tuleap user using the cross tracker search widget
    I want: query for count of artifacts
    So that: I can create meaningful aggregate queries

    As a: Tuleap user using the cross tracker search widget to get a "count"
    I want: to drill down into the count to get individual artifacts
    So that: I can pursue further detail when needed

    Empty
    16.10
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Tuleap PCC (tuleappcc)
    Stage
    Empty
    New
    Empty
    Attachments
    Empty
    References
    References list is empty
    Display settings

    Follow-ups

    User avatar
    Tuleap PCC (tuleappcc)2025-08-27 18:03

    Sure, something like this:

    SELECT COUNT(@pretty_title) FROM @project = MY_PROJECTS() WHERE @status = OPEN() GROUP BY @assigned_to

    This would return, for instance:

        assigned_to Count
    >    Kayla Robinson (krobinson) 5
    \/    Katie Gudmundsen (katieg)  3  
          task #1234 Do this thing   
      story #2345 Sort columns
    bug #3456 Error in report
    > Tom Astle (tom) 7
    User avatar
    Manuel Vacelet (vaceletm)2025-08-27 09:21

    Hello,

    Could you provide an example of query that you would like to write and the corresponding expected results ?