Report to show all pages that have a "ReviewDate" custom field set
I have added a custom field for my pages called "ReviewDate" which is a date picker and I want to create a report that the editors can use to review the pages that the current date matches or is past the "ReviewDate".
It could be done as a page with templates to get this data back but that doesn't really seem like the best place especially as we wouldn't want that viewable externally.
I could do the report in sql but I don't know the database well enough to do this (currently running 6.1.5)
What would be the best way to deal with this scenario?
Report to show all pages that have a "ReviewDate" custom field set
I have added a custom field for my pages called "ReviewDate" which is a date picker and I want to create a report that the editors can use to review the pages that the current date matches or is past the "ReviewDate".
It could be done as a page with templates to get this data back but that doesn't really seem like the best place especially as we wouldn't want that viewable externally.
I could do the report in sql but I don't know the database well enough to do this (currently running 6.1.5)
What would be the best way to deal with this scenario?
Hi Steve,
Take a look at this 24 Days article - I'd go with something like that, where it makes sense to put that info in the backoffice.
/Chriztian
is working on a reply...