Hi Simon,
Did you try the RQL:
<IODATA sessionkey="<%info_sessionKey%>">
<PAGE action="xsearch" pagesize="-1">
<SEARCHITEMS>
<SEARCHITEM key="pagestate" value="released" users="all"
operator="eq" />
</SEARCHITEMS>
</PAGE>
</IODATA>
You will get Release date of the page as a floating-point number from
<RELEASE> element in the server response.
I found this while browsing the RQL manual. I am not sure whether this
will work in CMS V7.1 or not, but you can give a try on this :)
Regards,
Jills
On Jul 28, 3:16 pm, "Simon Lewis, UK" <[email protected]>
wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
