222-record report missing very last value
-
Hi –
My latest report I created outputs Lastname,Firstname. All looks great – except, in the CSV, TSV, and JSON downloads, the Firstname in the last record is missing all but the first letter. It does show up in the XML download.
222 records
The same happens in my Firstname,Lastname,Email report.
This is repeatable every time.
Any ideas?SELECT pm1.meta_value AS Lastname , pm2.meta_value AS Firstname FROM wp_k8hk02qrxa_posts LEFT JOIN wp_k8hk02qrxa_postmeta AS pm1 ON ID = pm1.post_id LEFT JOIN wp_k8hk02qrxa_postmeta AS pm2 ON ID = pm2.post_id WHERE (post_type = 'members' AND post_status = 'publish' AND pm1.meta_key = 'wpcf-last-name' AND pm2.meta_key ='wpcf-first-name') ORDER BY Lastname
Thx,
Jeff
- The topic ‘222-record report missing very last value’ is closed to new replies.