1. Tempo Avatar Tempo
  2. Prime
  3. servertimesheet
  4. Issues

Report not showing all filter results

Issue #1007 resolved
Former user created an issue

Hello Andriy,

I have a report that groups by EPIC. The EPIC has 6 "Issues in Epic". The filter used includes all 6 issues in the epic but the timeshee report only includes 1 issue (SCS-2), which is the one that has Time Spent reported. The report configuration has the "Show Empty Rows" select. Therefore, I would expect all 6 issues to be included in the report but that is not heppening. Can you take a look at this please?

Below is the data sample: |Key|Status|Resolution|Created Date|Estimaged|Remaining|Time Spent |SCS-2|Accepted|Unresolved|31-Oct-16|3d|2d 48m|7h 12m |SCS-3|New|Unresolved|31-Oct-16|1w|1w|N/A |SCS-4|New|Unresolved|31-Oct-16|2w|2w|N/A |SCS-5|New|Unresolved|31-Oct-16|1w|1w|N/A |SCS-6|New|Unresolved|31-Oct-16|2w|2w|N/A |SCS-7|New|Unresolved|31-Oct-16|2w|2w|N/A

Below the report configuration: ConfigureReport.jspa?startDate=3%2FOct%2F16&endDate=9%2FNov%2F16&targetUser=&targetGroup=&excludeTargetGroup=&projectRoleId=&projectid=15748&filterid=19663&priority=&weekends=true&showDetails=true&sum=week&sumSubTasks=true&showEmptyRows=true&groupByField=customfield_12541(EPIC LINK)&moreFields=&moreFields=timeoriginalestimate&moreFields=timeestimate&moreFields=timespent&moreFields=timetracking&selectedProjectId=15748&reportKey=jira-timesheet-plugin%3Areport&Next=Next

JIRA v6.3.12 Timesheet v2.9.7.3

Comments (18)

  3. Andriy Zhdanov
    • changed status to open

    Hi Zahira,

    I'm not sure why it's not showing you empty issues in report, but have found a problem in case of gadget though.

    Also I'd like to notice that it might be better to group by Epic Name, if it works for you.

    If you find it reasonable, please reopen.

    Thank you.

  4. Former user Account Deleted reporter
    • changed status to new

    We tried the report again with Epic Name and still it just showing one issue in the epic.

  5. Andriy Zhdanov

    Hi Zahira,

    Could you please clarify if you're using report or gadget? May be add screenshot also.

    Thank you.

  6. Former user Account Deleted reporter

    Hello,

    I am using the report. See the report URL in the original posting. Attached you can see that the filter includes the 6 issues in the epic and then the report only shows 1 issue

  8. Andriy Zhdanov

    And what if you don't group by Epic Link or Epic Name? Do all issues from the filter appear in the report?

  9. Former user Account Deleted reporter

    If I remove the grouping, it behaves the same way, ie. only 1 issue displays.

    I added a work log to the ticket SCS-3838 and it showed up in report so it seems like it the selection to "show empty rows" is not being applied.

  10. Andriy Zhdanov

    Ah, it must be because of Sum Sub-tasks! I will check if empty parent issues are shown in this case, but apparently your epic issues are summed up into Epic itself, but it's excluded by the filter.

    You might also check if you have configured Parent Issue Field in Administration - Add-ons - Timesheet Configuration. When unset, epic issues should not be summed up into Epic also.

  13. Former user Account Deleted reporter

    Report still not showing all issues: (1) switched off Sum Subtasks (2) Group by Field=None (3) Show Empty Rows is ON

  14. Andriy Zhdanov

    That's strange. Did Show Empty Rows ever work for you? Does it work with other filter or just project selected in report configuration? Or if you unselect all Additional Fields.

  15. Former user Account Deleted reporter

    Yes, we have seen empty rows before. I removed the Additional Fields and the filter, and started using the project but it still doesn't work.

    I tried another project using the same configuration and that other project shows the empty rows. But I noticed that the display of the issues is different. For the project that doesn't show the empty rows, the issues are group by the epic and a total line is added per epic section. Report shows 388 issues. For the project that shows the empty rows, the issues are NOT grouped; its just one list of issues. The report shows 20 issues.

    Would the type of display make it work differently or the quantity of issues?

  16. Andriy Zhdanov

    Hi Zahira,

    I see it now. However I observe an opposite behaviour. Anyway, it happens because of Worklog Limit setting in Administration - Add-ons - Timesheet Configuration, as designed, due to issue#811.

    Report refuses to add empty issues if the number of issues is bigger than Worklog Limit / 10, or 500 if Worklog Limit=0.

    And also report switches off 'Show Details' option, if the number of worklogs is bigger than Worklog Limit. Thus it does not break down data by grouped field.

    So, you can set Worklog Limit to 0 to switch off, and it will work up to 500 issues in Project.

    I will also fix report to honour Worklog Limit=0, so that it would not have 500 issues limit.

    Or you can increase Worklog Limit as desired.

    However, you may still have different problem, because the logic I've described should not show empty rows and should not not group by the epic in this case.

    Thank you.

  19. Log in to comment
Assignee
–
Type
bug
Priority
major
Status
resolved
Component
–
Version
2.9
Votes
0
Watchers
1