I have a Content Type Event with the following fields, i want users to be able to filter with the fields like, Date, Activity, etc. But the filters dont work

Event Fields:
Screen-shot of all fields attached:Event Content Type Fields

  • Date
  • Location: Term Reference for Taxonomy Location
  • Activity : Term Reference for Taxonomy Location
  • Organiser: Entity Reference for Organizer node (as 1 event will have only 1 organizer)

I have setup a Page View named Experience, with Listing of Events with exposed filters.

I have managed to Expose the filter with BEF, however these filters don't give any result after changing value. Though they are set to Use Ajax: Yes.

You can check this at the link: http://dev.adventureex.com/experience (Currently set to Use AJAX:No and Autosubmit: No)

Also other filters like Organiser and Location are autocomplete fields, these fields do not show-up any value on entering text.

Later, i tried to set Autosubmit: No and Use AJAX: No, but the Views filters still dont work.

Here are the Views Settings, Event Page View Settings

Kindly help

UPDATE: Here's the SQL Query

SELECT node.nid AS nid, node.title AS node_title, node.created AS node_created, 'node' AS field_data_field_event_date_node_entity_type, 'node' AS field_data_field_event_image_node_entity_type, 'node' AS field_data_field_event_location_node_entity_type, 'node' AS field_data_field_event_amount_node_entity_type
FROM
{node} node
LEFT JOIN {field_data_field_event_club} field_data_field_event_club ON node.nid = field_data_field_event_club.entity_id AND (field_data_field_event_club.entity_type = 'node' AND field_data_field_event_club.deleted = '0')
WHERE (( (node.status = '1') AND (node.type IN  ('event')) AND (field_data_field_event_club.field_event_club_target_id IS NOT NULL ) ))
ORDER BY node_created DESC
LIMIT 12 OFFSET 0
Files: