Hi,
I'm very fond of the Rules module and have been using it in many useful ways. There is one task, though, that I havn't been able to accomplish and I would like to ask for some help on that one. I'm sure it can be done somehow.

On my website, there is always a long waitinglist of unpublished nodes. Every hour I want the oldest of these nodes to be published. Right now I have to do this manually every hour, or use the Scheduler module to manually assign a publishing time. I'm looking for a way to let Rules handle the publishing.

My idea is to use a view that arranges the unpublished nodes in descending order of creation time, and then have a repetitive rule that automatically publishes the first node of that view every hour.

Is there a way to make this work? Or does anybody have a better idea to solve that problem? Thanks.

Comments

Bilmar’s picture

Bilmar commented
Component: Module Integrations » Miscellaneous

subscribing

steven jones’s picture

steven jones commented

The Rules Executor module should solve your exact problem. It's still under heavy development mind you.

mitchell’s picture

mitchell commented
Title: Publish the first item of a view » Publish new nodes one hour after creation
Category: feature » support
Status: Active » Fixed

Rules scheduler seems appropriate for what you are trying to do. There's a tutorial that may help, Tutorial 2: Publish content exactly 24 hours after it was created. The current work to integrate views with rules is experimental, but the rules scheduler is stable and seems to fit exactly what you want. FYI, in addition to the very new rules executer module, this has been an ongoing issue for some time in #329500: support for looping and data lists, and fago is also working on building this magnificent feature into rules 2 for drupal 7.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.