Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
Have a FullCalendar that is being generated of of Drupal Commerce product data with dates and a field list selector. Where the view is double displaying the returned results.
The query from views is:
SELECT DISTINCT commerce_product.product_id AS product_id, commerce_product.title AS commerce_product_title, 'commerce_product' AS field_data_field_grp_tour_trp_date_commerce_product_entity_t, 'commerce_product' AS field_data_field_tour_commerce_product_entity_type, COUNT(DISTINCT commerce_product.sku) AS commerce_product_sku
FROM
{commerce_product} commerce_product
LEFT JOIN {field_data_field_cruise_cabin_names} field_data_field_cruise_cabin_names ON commerce_product.product_id = field_data_field_cruise_cabin_names.entity_id AND (field_data_field_cruise_cabin_names.entity_type = 'commerce_product' AND field_data_field_cruise_cabin_names.deleted = '0')
LEFT JOIN {field_data_field_tour} field_data_field_tour ON commerce_product.product_id = field_data_field_tour.entity_id AND (field_data_field_tour.entity_type = 'commerce_product' AND field_data_field_tour.deleted = '0')
WHERE (( (field_data_field_tour.field_tour_nid = '892' ) )AND(( (field_data_field_cruise_cabin_names.field_cruise_cabin_names_value IN ('3', '6', '10', '21')) )))
GROUP BY product_id
When the query is run directly in mysql the results show each value uniquely. However when goto the FullCalendar View there are double entries. Similar to #1111008: Double Calendar postings after upgrade
I am running
FullCalendar 7.x-2.0-beta3
Date 7.x-2.0-rc2
Views 7.x-3.1
Thanks in advance for the help!
Comment | File | Size | Author |
---|---|---|---|
#1 | 2012-03-07 01.05.07 am.png | 34.65 KB | HyperGlide |
full-calendar-double.png | 45.63 KB | HyperGlide |
Comments
Comment #1
HyperGlide CreditAttribution: HyperGlide commentedA few notes to add about our view:
Did it work?
A few other things learned along the way:
Huge thanks to the rockstar support from @timplunkett and @aspilicious.
Comment #3
velpan CreditAttribution: velpan commentedIn case of somebody else has the same issue...
I solved the double view of events by
unchecking the checkbox "Display all values in the same row" inside the fieldset MULTIPLE FIELD SETTINGS
in the configuration of the Date field used for the event.
Comment #4
HyperGlide CreditAttribution: HyperGlide commented@velpan thanks -- but the issue I posted was only 1 instance per field value.
Comment #5
pramodga CreditAttribution: pramodga commentedI tried below solution and works fine for me. :)
Now you can check the view, it should stop showing duplicate events