I am attempting to use workbench to run a query:

select count(id), Response_CD__c, DAY_ONLY(createddate) from outreach_phone_detail_pd__c where createddate > 2019-10-10T00:00:00Z group by Response_CD__c,DAY_ONLY(createddate)

Unfortunately, this query only returns 2 rows so it shows without the "DAY_ONLY(createddate)"

this leaves the data unreadable as it IS seperated by day but you don't know which line is which day.

This query shows no errors or execution failures

results picture: enter image description here

  • What's the actual output look like? What are you expecting? Please edit your question so we can assist you. – sfdcfox Oct 15 '19 at 19:23
  • Please do not use put-downs or direct sarcasm at users in your posts. Respectful communication is part of the core Stack Exchange ethos. – David Reed Oct 15 '19 at 20:53
  • 1
    I'm almost wondering if this is a bug with Workbench. Running a very similar query in developer console, I was able to get the expected 3-column result. – Drew Kennedy Oct 15 '19 at 20:59
  • @DrewKennedy in salesforce dev console i am also getting 3 columns, any idea how to export it in a readable manner for a report? – Tim Willis Oct 15 '19 at 21:00
  • 1
    Not cleanly, but I have done this before. Just note it does require FireFox. – Drew Kennedy Oct 15 '19 at 21:03

It looks like this may just be a bug in workbench or is not supported,

Drew Kennedy posted a comment which is the solution I ended up going with, using a plugin to pull from Dev console. Export Results from Developer Console - Query Editor?

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.