Posted: March 2, 2021 at 1:07 pm
|
I created a previous support ticket on this https://eventespresso.com/topic/event-espresso-4-registrations-filtered-csv-report-showing-duplicate-records/ I deactivated custom code hooking into the CSV output to add/remove columns and I still get a bunch of duplicate records Please advise how I can resolve. |
|
|
Also, this is happening in the admin with the filter report showing more results than there actually are. |
|
|
Is there an issue with the EE filter query? |
|
|
Hi there,
Hmm, yeah that’s odd. I can’t reproduce that. Can you post the exact steps you are taking here? You’ve mentioned ‘filter query’ in your last reply, so I assume you are using the ‘Filtered CSV Report’ button? If you can post the full steps to get to the report you are using I’ll see if I can reproduce it.
100% sure you removed all custom code hooking into the CSV when testing this?
If this was an issue with the query itself I’d expect a lot more reports of this but this is the first I’ve heard of it iirc. When you click the export button, does the file download straight away, or do you see another page with a progress bar first? |
|
|
Thanks for the reply, Tony. When I go to EE > Registrations, select filter for Feb 2021 (for example), then click Filtered CSV Report, there is a new page with a download progress bar and then the file downloads. What I get in the CSV file are all the registrations for that period but 15-20 duplicate rows of the same records. So a report that should only have 300 rows of registration records ends up with 5000-6000 rows with duplicates. Do you now what might be causing this? |
|
|
This is the query that is being executed when a user runs the export with filtered results. When I run the query in MySQL I get the same number of results with duplicates. Can you check if something is not right or provide me with your query so we can see whats happening? BTW the found registrations inside the dashboard when I try to filter them is also matching the total rows found ( including duplicates ) SELECT Registration.REGID AS ‘Registration.REGID’, Registration.EVTID AS ‘Registration.EVTID’, Registration.ATTID AS ‘Registration.ATTID’, Registration.TXNID AS ‘Registration.TXNID’, Registration.TKTID AS ‘Registration.TKTID’, Registration.STSID AS ‘Registration.STSID’, Registration.REGdate AS ‘Registration.REGdate’, Registration.REGfinalprice AS ‘Registration.REGfinalprice’, Registration.REGpaid AS ‘Registration.REGpaid’, Registration.REGsession AS ‘Registration.REGsession’, Registration.REGcode AS ‘Registration.REGcode’, Registration.REGurllink AS ‘Registration.REGurllink’, Registration.REGcount AS ‘Registration.REGcount’, Registration.REGgroupsize AS ‘Registration.REGgroupsize’, Registration.REGattisgoing AS ‘Registration.REGattisgoing’, Registration.REGdeleted AS ‘Registration.REGdeleted’, EventCPT.ID AS ‘EventCPT.ID’, EventCPT.posttitle AS ‘EventCPT.posttitle’, EventCPT.postcontent AS ‘EventCPT.postcontent’, EventCPT.postname AS ‘EventCPT.postname’, EventCPT.postdate AS ‘EventCPT.postdate’, EventCPT.postexcerpt AS ‘EventCPT.postexcerpt’, EventCPT.postmodified AS ‘EventCPT.postmodified’, EventCPT.postauthor AS ‘EventCPT.postauthor’, EventCPT.postparent AS ‘EventCPT.postparent’, EventCPT.menuorder AS ‘EventCPT.menuorder’, EventCPT.poststatus AS ‘EventCPT.poststatus’, EventCPT.postpassword AS ‘EventCPT.postpassword’, EventCPT.commentstatus AS ‘EventCPT.commentstatus’, EventCPT.pingstatus AS ‘EventCPT.pingstatus’, EventMeta.EVTdisplaydesc AS ‘EventMeta.EVTdisplaydesc’, EventMeta.EVTdisplayticketselector AS ‘EventMeta.EVTdisplayticketselector’, EventMeta.EVTvisibleon AS ‘EventMeta.EVTvisibleon’, EventMeta.EVTadditionallimit AS ‘EventMeta.EVTadditionallimit’, EventMeta.EVTdefaultregistrationstatus AS ‘EventMeta.EVTdefaultregistrationstatus’, EventMeta.EVTmemberonly AS ‘EventMeta.EVTmemberonly’, EventMeta.EVTphone AS ‘EventMeta.EVTphone’, EventMeta.EVTallowoverflow AS ‘EventMeta.EVTallowoverflow’, EventMeta.EVTtimezonestring AS ‘EventMeta.EVTtimezonestring’, EventMeta.EVTexternalURL AS ‘EventMeta.EVTexternalURL’, EventMeta.EVTdonations AS ‘EventMeta.EVTdonations’, EventCPT.ID AS ‘EventCPT.ID’, EventMeta.EVTMID AS ‘EventMeta.EVTMID’, EventTermRelationship.object_id AS ‘EventTermRelationship.objectid’, EventTermRelationship.termtaxonomy_id AS ‘EventTermRelationship.termtaxonomyid’, EventTermRelationship.term_order AS ‘EventTermRelationship.termorder’, EventTermTaxonomy.termtaxonomy_id AS ‘EventTermTaxonomy.termtaxonomyid’, EventTermTaxonomy.term_id AS ‘EventTermTaxonomy.termid’, EventTerm_Taxonomy.taxonomy AS ‘EventTermTaxonomy.taxonomy’, EventTermTaxonomy.description AS ‘EventTermTaxonomy.description’, EventTermTaxonomy.parent AS ‘EventTermTaxonomy.parent’, EventTermTaxonomy.count AS ‘EventTermTaxonomy.count’, Answer.ANSID AS ‘Answer.ANSID’, Answer.REGID AS ‘Answer.REGID’, Answer.QSTID AS ‘Answer.QSTID’, Answer.ANSvalue AS ‘Answer.ANSvalue’ FROM wpespregistration AS Registration LEFT JOIN wpposts AS EventCPT ON EventCPT.ID=Registration.EVTID LEFT JOIN wpespeventmeta AS EventMeta ON EventCPT.ID = EventMeta.EVTID LEFT JOIN wptermrelationships AS EventTerm_Relationship ON EventTermRelationship.objectid=EventCPT.ID LEFT JOIN wptermtaxonomy AS EventTermTaxonomy ON EventTermTaxonomy.termtaxonomyid=EventTermRelationship.termtaxonomyid LEFT JOIN wpespanswer AS Answer ON Answer.REGID=Registration.REGID WHERE Registration.REG_deleted = 0 AND EventTermTaxonomy.termid = 241 AND Registration.STSID != ‘RIC’ AND (Answer.ANSvalue LIKE ‘{d7888fb4da55426dce4c4af0b3203008e81df2f8b90c2274bcd0fb17d1022321}{d7888fb4da55426dce4c4af0b3203008e81df2f8b90c2274bcd0fb17d1022321}’) ORDER BY Registration.REGdate DESC,Registration.REG_ID DESC LIMIT 0,100 |
|
|
That query doesn’t match the filter you mentioned above:
Your SQL does not filter based on date and looks like its based on Event Category and a registration form Answer? Can you post the steps you are taking for the above please? EE doesn’t run the registration report based on a specific question value like the above, it pulls all registrations for an event (or all registrations) the loops over them and pulls answers from there. Here is an example of a month filter query for me:
|
|
The support post ‘Event Espresso 4 – Registrations Filtered CSV Report Showing Duplicate Records’ is closed to new replies.
Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.
