Thread tagged as: Question, Api, Meta

Access content_items itemUpdated column in database


We're trying to access the itemUpdated column in the content_items table of the database within Perch. The reason being - one of our clients would like Revision Date field. Rather than having a date field they manually update every-time they save, it'd be much better to have a field we can automatically reference - and if we can use the one that already exists without much trouble - it'd be great!

I know we can probably grab it using direct queries to the database - but then matching it up with content regions may require a bit of work (unless we just grab the most recent date for the region). However a method of access using perch itself would be preferable.

Thanks in advance for any direction/assistance!

James Harrison

James Harrison 0 points

  • 3 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

That column is only intended for internal use so there's no way to access it.

I ended up creating a simple modified date field type for things like that. it’s on github if you would like it. My name there is montlewis