I'm using the query below to try and pull a raw file of attendees at an event we hosted earlier this month. This same query has worked fine for me in the past, but when I run it, I'm not getting any information (i.e., query finishes running and there is nothing listed in the raw data panel or the CSV file I export). I see the event was indeed logged in HubSpot as happening on 9/18/19. Could someone please review the query and let me know if I'm doing something wrong or if something has changed? Best, Melissa
SELECT c."First Name" as "FirstName", c."Last Name" as "LastName",c."Email" as "email",
e."timestamp" as "Activity Date", e."Metadata_Body" as "Meeting Body"
FROM Contacts AS c, Engagements AS e
INNER JOIN Engagements ON e.Associations_ContactIds like ('%' || c.Id || '%')
WHERE e.timestamp >='09/18/2019 00:00:00'
AND e.timestamp <='09/18/2019 23:59:59'
AND e.Type in ('Meeting')
And e.activityType = 'University-Wide Event (e.g., Symposium)'
GROUP by c."First Name" , c."Last Name",c."Email", e."timestamp", e."Metadata_Body"
ORDER BY c."First Name" , c."Last Name"