Hi buddy

I want to thank you first for this great sandbox.

I just one one issue when I tried to do a view with a expose filter by availability creating a condition with a empty NOT IN.

CommentFileSizeAuthor
#1 database_error_filter_a-2274681.patch1.02 KB-enzo-
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

-enzo-’s picture

-enzo- CreditAttribution: -enzo- commented
FileSize
database_error_filter_a-2274681.patch1.02 KB

Attached you can find my proposal for the reported error

ziomizar’s picture

ziomizar CreditAttribution: ziomizar commented

Hi -enzo-,

Tnx for the patch, this section of the rooms_node needs some review, i think that is better define an hook_views_data for mapping {rooms_availability_index} table, then working only on views.

The original ideia of this query was:
- select all nodes booked, or unavailable in a dates range
- exclude this node from the query

Your solution seems to doing only:
- exclude all nodes in selected range
But all nodes have a value in selected range, with a status 0,1,32,ecc..
So all nodes in this range are excluded from search result..

Can you include more information on the error, or can you explain me how your code improve the search?

ziomizar’s picture

ziomizar CreditAttribution: ziomizar commented
Status: Active » Closed (works as designed)