Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

Archiving should accommodate Parent-Child relationships

BOAUnited

Please add a column for Priority (int) to the ttTemplateArchive table in the cMass database to allow template developers to control the order that data is archived.

Business Rationale:

When building a template, it is possible to add a child table to the data model for that template.  It is also possible to register the child table for archiving.  However, the delivered System is susceptible to failure whenever it attempts to archive the child table before the parent.  The current system does not give the developer any way to control the behavior because the procedure for archiving the data pulls the list of tables in database order and may therefore attempt to write child records to archive before writing the necessary parent record.  This could be solved easily with the proposed solution.

  • Chris Bermingham
  • Jan 31 2017
  • Likely to Implement
  • Attach files
  • +1