Schedule entry statuses in Reporter

We’ve improved the schedule_entries table in Reporter. This note describes this change in full, and as usual you can contact support or your Technical Account Manager for further clarification.

At its core BeBanjo is a scheduling tool and users spend a lot of their day in the schedule page where they’re able to perform sophisticated filtering to find the content that needs attention.

To make sure that you can do the same in Reporter we’ve added the metadata, publication, and workflow statuses to the schedule_entries table.

The new column names and possible values for each status are:

• schedule_entry_workflow_status
  • not_configured
  • no_workflow
  • pending
  • in_progress
  • completed
• schedule_entry_metadata_status
  • not_configured
  • calculating
  • valid
  • invalid
• schedule_entry_publication_status
  • not_configured
  • never_published
  • in_progress
  • not_in_sync
  • failed
  • failed_previously_published
  • published

And for consistency we also renamed the rights_status column to schedule_entry_rights_status. Happy SQLing!

References

• reporter#80 Add the metadata, publication, and workflow Schedule Entry statuses