We are having a strange issue when exporting a very simple custom report. Records are being duplicated when there are over 200 records in the resultset.
For a very simple report with just the Order Number and the Create Date the grid view online shows the correct data (in this case 262 records). When I export that view to CSV the CSV also contains 262 records but 62 of those records are duplicates. (Note the same happens with Export to XLSX).
Looking at the SQL generated via the debug the query couldn’t be simpler. (Included below if helps).
There is an old issue here https://oroinc.com/orocrm/forums/topic/reports-generating-csv-with-duplicated-data which is similar but (a) has been resolved and (b) I am not including address fields in the report and there are no joins so it is different.
Any thoughts on where to start on this or if you have have come across this previously appreciated.
JoeMySQL12345678910SELECTo0_.increment_id AS increment_id_0,o0_.created_at AS created_at_1,o0_.id AS id_2,o0_.organization_id AS sclr_3,o0_.user_owner_id AS sclr_4FROM orocrm_magento_order o0_WHERE o0_.created_at >= '2017-01-01 00:00:00' AND o0_.created_at <= '2017-01-07 00:00:00' AND o0_.organization_id = 1ORDER BY o0_.id ASCLIMIT 25 OFFSET 0
You must be logged in to reply to this topic.