# Feature SPAR-58 - Add link from work / estimated work sum to detailed query view

Project: Stream Planning and Reporting
Status: closed
URL: https://community.openproject.org/work_packages/SPAR-58

## Planning

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Target versions | 13.3.0 |
| Votes |  |
| List |  |
| Roadmap |  |
| Relevance |  |

## OPEN POINTS / FEEDBACK

_No work packages_

## Features and Chunks

_No work packages_

## Bugs and other work packages

_No work packages_

## Technical Details

| Attribute | Value |
| --- | --- |
| Module |  |
| Feature Flag |  |
| Requires doc change | No |
| Enterprise plan |  |

## Details

| Attribute | Value |
| --- | --- |
| Pull preview |  |
| Mockups |  |
| Accessibility | No |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Estimates and progress

| Attribute | Value |
| --- | --- |
| PD (min) |  |
| PD (max) |  |
| Work |  |
| Labor costs |  |

## Description

Part of <mention class="mention" data-id="40867" data-type="work_package" data-text="##40867">##40867</mention>

<figure class="image op-uc-figure"><div class="op-uc-figure--content"><img class="op-uc-image" src="/api/v3/attachments/78898/content"></div><figcaption class="op-uc-figure--description">Child work packages filtered out</figcaption></figure>

The "Σ 60h" in "Work" and "Remaining work" fields are links. They open a detailed view showing the children to help understanding the computation.

  - The view is a work package query.
  - Filter is set to parent = work package having been clicked. 
      - Only the direct children are shown. This is enough as the user can drill down into each children sum.
  - The closed work packages are not filtered out: both open and closed work packages are listed.
  - Columns are id, subject, type, status, work, and remaining work.
      - Column % Complete will be added once <mention class="mention" data-id="51188" data-type="work_package" data-text="##51188">##51188</mention> is done and it displays two values.