← Back to team overview

openlp-core team mailing list archive

[Bug 815313] [NEW] Add created_date and updated_date fields to all tables

 

Public bug reported:

I was just asked to produce a report showing which songs have been added
to OpenLP in the past six months. Unfortunately, however, there's no
easy way to do this, as the data simply isn't available in the database.
What I would propose is the addition of two fields to most (all?) tables
in the "songs" db, to track the timestamps for insertion and last
update.

Yes, there is the "songusage" database, but that solves a slightly
different problem, although admittedly with some cross-over. (I was able
to get useful data out of it to satisfy the request.)

** Affects: openlp
     Importance: Wishlist
         Status: New

-- 
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/815313

Title:
  Add created_date and updated_date fields to all tables

Status in OpenLP - Worship Presentation Software:
  New

Bug description:
  I was just asked to produce a report showing which songs have been
  added to OpenLP in the past six months. Unfortunately, however,
  there's no easy way to do this, as the data simply isn't available in
  the database. What I would propose is the addition of two fields to
  most (all?) tables in the "songs" db, to track the timestamps for
  insertion and last update.

  Yes, there is the "songusage" database, but that solves a slightly
  different problem, although admittedly with some cross-over. (I was
  able to get useful data out of it to satisfy the request.)

To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/815313/+subscriptions


Follow ups

References