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. Has anybody tried changing start_date and due_date to datetime instead of date?

Has anybody tried changing start_date and due_date to datetime instead of date?

Added by CS Wong over 10 years ago

Hi,

I’m trying to modify OpenProject to fit into a project deployment scenario where we have multiple tasks and milestones, each of the taking just minutes or hours instead of days. Due to that, the current column type date used for Work Packages doesn’t really fit my requirements.

Thus far, what I already know I have to do are (after a couple of hours reading and experimenting):

  1. Change the DB column types for start_date and due_date
  2. Change the datepicker UI widget to something that supports selection of time as well (http://xdsoft.net/jqplugins/datetimepicker/ seems promising)
  3. Modify the text input element for start and due dates to not validate against spaces
  4. I suppose I will need to change the timeline renderer to support hour based scale as well

Would just like to check if anyone had done this before and has any advice on this? I’m not a Ruby programmer by any means, but I suppose I have enough common sense to fumble my way around the source code. Right now, I’m having trouble locating where the start_date and due_date attribute is defined in the WorkPackage model. I’ve searched app/models/work_package.rb and I know that this is the correct class, there isn’t really an explicit definition for start_date / due_date in there. It doesn’t seem to be inherited from ActiveRecord either so I’m kinda confused where to find it.

Thanks for any help!
Wong


Loading...