Hello, the matomo connector doesn’t show the correct data from custom reports, it runs slowly and can fetch data from the previous period. These is the queries that we receive from the Matomo server, is there anything we can do about it? Here is the query: SELECT idsite, date1, date2,
GROUP_CONCAT(CONCAT(idarchive,‘|’,name,‘|’,value) ORDER BY idarchive DESC SEPARATOR ‘,’) AS archives
FROM matomo_archive_numeric_2023_10
WHERE idsite IN (6)
AND ((name IN (‘done90a5a511e1974bca37613b6daec137ba’,‘done90a5a511e1974bca37613b6daec137ba.CustomReports’)) AND (value IN (1,3,4,5)))
AND ts_archived IS NOT NULL
AND ((period = ‘1’ AND date1 = ‘2023-10-01’ AND date2 = ‘2023-10-01’) OR (period = ‘1’ AND date1 = ‘2023-10-02’ AND date2 = ‘2023-10-02’) OR (period = ‘1’ AND date1 = ‘2023-10-03’ AND date2 = ‘2023-10-03’) OR (period = ‘1’ AND date1 = ‘2023-10-04’ AND date2 = ‘2023-10-04’) OR (period = ‘1’ AND date1 = ‘2023-10-05’ AND date2 = ‘2023-10-05’) OR (period = ‘1’ AND date1 = ‘2023-10-06’ AND date2 = ‘2023-10-06’) OR (period = ‘1’ AND date1 = ‘2023-10-07’ AND date2 = ‘2023-10-07’) OR (period = ‘1’ AND date1 = ‘2023-10-08’ AND date2 = ‘2023-10-08’) OR (period = ‘1’ AND date1 = ‘2023-10-09’ AND date2 = ‘2023-10-09’) OR (period = ‘1’ AND date1 = ‘2023-10-10’ AND date2 = ‘2023-10-10’) OR (period = ‘1’ AND date1 = ‘2023-10-11’ AND date2 = ‘2023-10-11’) OR (period = ‘1’ AND date1 = ‘2023-10-12’ AND date2 = ‘2023-10-12’) OR (period = ‘1’ AND date1 = ‘2023-10-13’ AND date2 = ‘2023-10-13’) OR (period = ‘1’ AND date1 = ‘2023-10-14’ AND date2 = ‘2023-10-14’) OR (period = ‘1’ AND date1 = ‘2023-10-15’ AND date2 = ‘2023-10-15’) OR (period = ‘1’ AND date1 = ‘2023-10-16’ AND date2 = ‘2023-10-16’) OR (period = ‘1’ AND date1 = ‘2023-10-17’ AND date2 = ‘2023-10-17’) OR (period = ‘1’ AND date1 = ‘2023-10-18’ AND date2 = ‘2023-10-18’) OR (period = ‘1’ AND date1 = ‘2023-10-19’ AND date2 = ‘2023-10-19’) OR (period = ‘1’ AND date1 = ‘2023-10-20’ AND date2 = ‘2023-10-20’) OR (period = ‘1’ AND date1 = ‘2023-10-21’ AND date2 = ‘2023-10-21’) OR (period = ‘1’ AND date1 = ‘2023-10-22’ AND date2 = ‘2023-10-22’) OR (period = ‘1’ AND date1 = ‘2023-10-23’ AND date2 = ‘2023-10-23’) OR (period = ‘1’ AND date1 = ‘2023-10-24’ AND date2 = ‘2023-10-24’) OR (period = ‘1’ AND date1 = ‘2023-10-25’ AND date2 = ‘2023-10-25’) OR (period = ‘1’ AND date1 = ‘2023-10-26’ AND date2 = ‘2023-10-26’) OR (period = ‘1’ AND date1 = ‘2023-10-27’ AND date2 = ‘2023-10-27’) OR (period = ‘1’ AND date1 = ‘2023-10-28’ AND date2 = ‘2023-10-28’) OR (period = ‘1’ AND date1 = ‘2023-10-29’ AND date2 = ‘2023-10-29’) OR (period = ‘1’ AND date1 = ‘2023-10-30’ AND date2 = ‘2023-10-30’) OR (period = ‘1’ AND date1 = ‘2023-10-31’ AND date2 = ‘2023-10-31’))
GROUP BY idsite, date1, date2