<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">How are you associating the rooms
content type to the reservations one? If you're using entity
reference, then you would want to create a relationship with the
reservations content type through that reference field. Make sure
you don't check "require this relationship" then add a filter so
that the related node (reservations) nid is NULL. <br>
<br>
The other option is in a custom module, using
hook_views_query_alter. Load the reserved room nids, through a
normal DB query, then add a NOT IN condition to the list of nids.
Here's the documentation on that hook:<br>
<br>
<a class="moz-txt-link-freetext" href="https://api.drupal.org/api/views/views.api.php/function/hook_views_query_alter/7">https://api.drupal.org/api/views/views.api.php/function/hook_views_query_alter/7</a><br>
<br>
<pre class="moz-signature" cols="72">Jamie Holly
<a class="moz-txt-link-freetext" href="http://hollyit.net">http://hollyit.net</a></pre>
On 1/19/2015 9:37 AM, Lluís Forns wrote:<br>
</div>
<blockquote
cite="mid:CAGTZhB7iYtSAhP0Y1826eYxKmFmiA4qZnL3DU87vsY2MQrgugw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>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, ....<br>
</div>
<div><br>
</div>
<div>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.<br clear="all">
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Any idea of how to accomplish this?</div>
<div><br>
</div>
<div>thanks</div>
-- <br>
<div class="gmail_signature">*Ser freak no és imprescindible
per ser informàtic, però ajuda.<br>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
</body>
</html>