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 #10312 No longer possible to sort on Computed value field in a tracker report
    Actions
    Infos
    #10312
    Patricia Carrasco (pcar)
    2017-06-13 17:47
    2017-06-12 15:30
    10559
    Details
    No longer possible to sort on Computed value field in a tracker report
    Seem like this functionality was broken in one of the previous Tuleap releases. According to https://tuleap.net/plugins/tracker/?aid=6594 it was merged into Tuleap 6.12.99.4
    Trackers
    Empty
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Emilio Palmiero (empa), Stephan Bill (stephanbill)
    Stage
    Empty
    Declined
    2017-06-13
    Attachments
    Empty
    References
    Referenced by request #10312

    Artifact Tracker v5

    request #6594 Sort a computed field in tracker report raise an error
    Display settings

    Follow-ups

    User avatar
    Thomas Gerbet (tgerbet)2017-06-13 17:47
    We can not sort artifacts on this field directly in the database due to the complexity of the involved calculation. So to be able to sort the artifacts we would need to retrieve all the artifacts that match your report from the database then sort them manually. It would be slow because a report can potentially matches a lot of artifacts and we would not have the same optimizations that are possible in the database at our disposal.
    • Status changed from New to Declined
    • Close date set to 2017-06-13
    User avatar
    Patricia Carrasco (pcar)2017-06-13 17:17
    Ok, you can cancel this request then. Is the performance issue related to the fact the compute value is generated once the user clicks on an action, for example in the report view it is calculating this data on the fly.
    User avatar
    Thomas Gerbet (tgerbet)2017-06-12 16:00
    Hello,

    The functionality is not broken, the request #6594 you have linked disable the sort of a report using a computed field. Prior to Tuleap 6.12.99.4 it was indeed broken and was generating a fatal error.

    Unless I miss something, I'm bit surprised that you say it is no longer possible to sort using a computed field since it is not possible since Tuleap 6.12.99.4 and was broken before that.

    Due to the way the computed fields fields are currently managed, sorting on them would result on a huge performance issue.