Hi all, I need to write some code that will fetch all pages that were *released* (not necessarily modified) in the past 2 weeks. I'm using CMS v7.1 (soon to be v7.5), and as far as I can see, there's no RQL query for doing this, so I would have to return an excess number of pages and then loop through each one to find out which ones were released in that timespan.
Another idea is to get the workflow to produce a small XML file with every release action, and then extract the GUIDs from those files -- that would work. But I was thinking that the CMS must have a table somewhere holding all the pages, with a column for the released date. It would be great if I could just use a standard SQL query to pull back a load of page GUIDs. Has anyone tried this? Is it possible? Is it safe? Or is there a better method? Grateful for any thoughts on this. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/RedDot-CMS-Users?hl=en -~----------~----~----~----~------~----~------~--~---
