Work report Job configuration

You can automate Work Reports by configuring a scheduled job to run them. This section documents the report parameters and provides an example configuration.

The job is configured in .polarion/jobs/schedule.xml (Access this using the Repository Browser).

Job Parameters

  • Scale: day, week, or month

  • Grouping: comma-separated list of available groupings:

    • project

    • projectGroup

    • category

    • user

    • workItem

    • type

  • periodStart, periodFinish - date specification in one of the following formats:

    • date:yyyy-MM-dd

    • timePoint:TIMEPOINT_ID

    • firstTimePoint

    • lastTimePoint

    • projectStart

    • projectFinish

Configuration example

<job name="Work Report" id="tracker.workreport" cronExpression="0 0 0 ? * *" scope="system">
    <fileName>scheduled_work_report_{yyyy-MM-dd}.xls</fileName>
    <overwrite>true</overwrite>
    <title>Work Report</title>
    <scale>week</scale>
    <grouping>project,user</grouping>
    <query></query>
    <periodStart></periodStart>
    <periodFinish></periodFinish>
</job>

  • fileName can be specified with date-time format. For example: work_report_{yyyy-MM-dd}.xls. The format can be any Java SimpleDateFormat. The actual file name will be created replacing the {FORMAT} part with the formatted current date.

  • If overwrite attribute is False, and a work report with the same file name already exists, the job will fail.

  • Only work records from Work Items matching the query and dated within the specified period are exported

  • If query is not specified, both periodFinish and periodStart must be specified