I would be happy to write back latter with more support on a views query as those criteria should not be to bad but in the mean time you might want to look at http://www.drupalrooms.com.

-Steve 

On Monday, January 19, 2015, Lluís Forns <enboig@gmail.com> wrote:
I have a site with 2 content types: rooms and reservations. I want to list all the rooms without a reservation for an interval, and also for services, capacity, ....

I tried creating a view with a PHP filter to check free rooms, but then if the page lists 10 rooms, sometimes there are 7, 2, or 0; because the filter lists the 10 rooms and after remove the occupied ones.

I have tried to create a "subview" filter to select nodes "not in (view of occupied rooms); but I haven't find a way to do so.

Any idea of how to accomplish this?

thanks
--
*Ser freak no és imprescindible per ser informàtic, però ajuda.


--
Steve Kessler
Owner and Lead Consultant 
Denver DataMan, LLC 
303-587-4428