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

Development
  1. OpenProject
  2. Forums
  3. Development
  4. Creating reports using OpenProject Database

Creating reports using OpenProject Database

Added by Mohammed Siddiqui over 6 years ago

We have a requirement to develop reports using our Business Intelligence Tool and the OpenProject Database. They want to group by the tasks using custom flied. 

in the OpenProject DB it can be seen that the custom fields and work_package_ journals are not directly related. Hence i am not able to do a proper join.

Is there a direct relationship between the two?


Replies (2)

RE: Creating reports using OpenProject Database - Added by Wieland Lindenthal over 6 years ago

Hi Mohammed,

why would you go down to the DB when there is a proper API that helps you exactly to filter and group as you like? Things get pretty complicated when it comes to work packages and their relations on DB level.

RE: Creating reports using OpenProject Database - Added by Mohammed Siddiqui over 6 years ago

Hi Wieland,

Thank you for the response. Our version of  bi tool IBM Cognos which does not support API as a data source. That's why the DB level.

Is there no way to get the data from DB ?

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