0

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

Improve this question
5
  • What's the actual output look like? What are you expecting? Please edit your question so we can assist you.
    – sfdcfox ♦
    Commented Oct 15, 2019 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
    Commented Oct 15, 2019 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
    Commented Oct 15, 2019 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
    Commented Oct 15, 2019 at 21:00
  • 1
    Not cleanly, but I have done this before. Just note it does require FireFox.
    – Drew Kennedy
    Commented Oct 15, 2019 at 21:03

1 Answer 1

Reset to default
0

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .