Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Cannot Reproduce
-
Affects Version/s: 4.3.0
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Documentation Required?:None
-
Funding Source:Needs Funding
Description
Hi Team,
I am using 4.3 Version of civicrm with Drupal 7.32.
I am listing the Civicrm Events based on the Custom Field Value in the front page of my website Using Views Module.
When i am logged in the listing is working correctly based on the filter, but if i am not logged in the listing is not properly separated. Please see the attached image for the issue.
I tried to create a simple views listing and it is working fine. Please
Please see the query which is showing in the Views interface below
SELECT civicrm_event.id AS id, civicrm_event.title AS civicrm_event_title, civicrm_event.start_date AS civicrm_event_start_date, civicrm_event.registration_end_date AS civicrm_event_registration_end_date FROM {civicrm_event} civicrm_event LEFT JOIN {civicrm_value_event_filter_informations_16} civicrm_value_event_filter_informations_16 ON civicrm_event.id = civicrm_value_event_filter_informations_16.entity_id WHERE (( (civicrm_event.is_public <> '0') AND (civicrm_event.start_date >= '2016-04-11 07:30:02') AND (civicrm_value_event_filter_informations_16.event_categories_129 IN ('HGS')) )) ORDER BY civicrm_event_start_date ASC LIMIT 7 OFFSET 0
Please let me know if this is a bug with views or civicrm.
