I’ve under content material sorts with following associated fields setup in a Drupal7 setup.
Exercise Fields: Identify, Physique and Picture.
Occasion Fields:
- Date
- Location: Time period Reference for Taxonomy Location
- Exercise : Time period Reference for Taxonomy Location
- Organiser: Entity Reference for Organizer node (as 1 occasion could have only one organizer)
Organiser Fields:
- Location: Time period reference for Location taxonomy
- Exercise: Entity Reference for node Exercise.
I’ve setup a Web page View named Expertise, with Itemizing of Occasions on proper sidebar and on left sidebar i wish to show Drupal Development Service Filters.
I’ve managed to Expose Drupal Development Service filter with BEF, nevertheless these filters do not give any outcome after altering worth. Although they’re set to Use Ajax.
Additionally different filters like Organiser and Location are autocomplete fields, these fields don’t show-up any worth on getting into textual content.
Kindly assist
UPDATE: This is Drupal Development Service SQL Question
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.standing = '1') AND (node.kind IN ('occasion')) AND (field_data_field_event_club.field_event_club_target_id IS NOT NULL ) )) ORDER BY node_created DESC LIMIT 12 OFFSET 0 
