Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

General discussion
  1. OpenProject
  2. Forums
  3. General discussion
  4. Custom reporting

Custom reporting

Added by John Zurowski about 6 years ago

I'm in the process of evaluating several project management packages. Openproject is currently looking ideal for work tracking however there is a strict requirement on quarterly reporting. The reports need to be in a specific layout/format and will need to include descriptions of progress on individual tickets, gantts etc. Costs will also be included although they do not need to be automatically calculated as there will be many non work related costs. My question is  - are there examples of customised reports perhaps using the API to generate them?


Replies (2)

RE: Custom reporting - Added by Johan Bouduin almost 6 years ago

Hello John,

I am currently trying to build a custom time entry report using the API. I can tell you, it is quite painful and requires a large amount of API calls.
In order to build a tree with three levels (L1 Project - L2 Work package category - L3 Work package) I need:

  1.  a call to list all projects 
  2.  for every project: a call to fetch the categories of the project
  3.  several calls to retrieve the workpackages

In addition to that, it is -to my knowledge- not possible to build a project tree using the API (that is why my tree has only three levels)

Then, after the user selected the work packages.

  1. I have to make one or more calls to retrieve the time entries for the selected work packages. 
  2. The data I get back does not contain the work package id, so for every retrieved time entry, I have to fetch the corresponding link to the work package at least once (or quick and dirty: parse the href of the link to extract the id)

My personal conclusion: if you need even more complicated reports or larger amounts of data, consider searching for another solution than the provided API or participating in the development of OP and extend the API yourself. 

have fun

Johan

RE: Custom reporting - Added by André Landwehr almost 6 years ago

Hello Johan,

would you care to share your work? What you described sounds somewhat like the report I'm looking for...

Thanks in advance!

André

  • (1 - 2/2)
Loading...