Table

 1. Click Create work report at the top-left corner and then click Table tab at the top-right.

Open

2. Configure search criteria

(1) Choose a range of days to report on from the calendar.

Open

Click “…“ to quickly select a pre-defined reporting period such as a Week/Month/Quater.

(2) Select a filter, this is required by default.

(3) Define the display hierarchy.

Drag the item from the right section to the left section.

3.1 Initial structure

3.2 When the global configuration, the report level setting is turned on, the selected custom field will be used as a level of the report, and it can be freely combined with other levels to query report data

The hierarchy will be displayed:

(4) Select  Columns to be displayed in the report, this is required by default.

First, select the issue type.

Then select the Columns you would like to display in the report.

Drag the item from the right section to the left section.

When selecting “Issue Type”“Work Type”“Fixed Versions”“Components“, the "Optional List" can be searched for:

（4.1）Question type extension function

• All

  • The types of parent tasks and subtasks are displayed.

• Parent task

  • Only the parent task type is displayed.

  • The working hours of the child task will be added to the parent task.

• Subtask

  • Only subtask types are displayed.

（4.2）Fixed version, Components and custom field extension function

• When the check box is checked, the version and module field information bound to the subtask will not be considered, and the work hours of the subtask will be merged into the work hours of the parent task.

（4.3）Custom Fields

Count working hours based on options in custom fields

Search result

• None (unselected)

  • The field exists in the issue but the value is not selected.

• Yes, No:

  • options for the field.

• Statistical rules

  • If you select "Yes" in the issue field, you will count all the working hours in the problem to "Yes", and if you select "No", you will count to "No".

3. Display All/Plan/Log

 You can filter the report to only see the Plan or Worklog data.

4. Sorting

(1) When you choose an item for grouping, you will now be able to sort your report results.

(2) Click the colunm name to change the sort order.

5. Column merge

1. merge
   Drag the column header to the column header to be merged to complete the merge.

1. restore

Double-click the merged title to restore.

6. Query optimization in the case of a large amount of data（Quarterly, Annual）

When the total log data volume of the query range is greater than "50,000 entries", a progress bar information and a termination button will appear on the interface during the query.

Progress bar: display the current progress
Terminate: Click to terminate the current query.

When the "issue" grouping operation is selected, the interface will display the following prompt

“You are currently performing a query for a very large amount of data, and the issue grouping option is selected. In this case, the returned results will be quite large, thus the data may not be displayed correctly. We strongly recommend you to Terminate the query, remove issue from the grouping list and try the searching again.”