Thread Details

Count function

Post by Bradley Tompkins
Joined 1/25/2021

Posted 2/16/2021 11:10 PM

The count (FieldName) function does not appear to work in SOQL Studio. For example, from the SOQL manual, this search fails:

SELECT LeadSource, COUNT(Name)
FROM Lead
GROUP BY LeadSource

In another product, the result looks like this:

LeadSource	COUNT(Name)
DSM	190
SPEC Manager	37
PDS	1
Designworx	5
Tech Services	273
RSD	70
IMR	43
RSM	2


Only count() appears to work.

Post by Administrator
Visual Software Systems
Joined 1/01/2016

Posted 2/17/2021 12:58 PM

Hi Bradley,

Thanks for the report. I am able to recreate the issue and this appears to be an issue introduced in the current build. We are finalizing a major new release and will include the fix for this in it.

Post by Administrator
Visual Software Systems
Joined 1/01/2016

Posted 2/18/2021 12:11 PM

We found and corrected the issue. The fix is included in the next release, due out in March.

Post by Bradley Tompkins
Joined 1/25/2021

Posted 2/18/2021 4:43 PM

Great, thank you!

Post by Administrator
Visual Software Systems
Joined 1/01/2016

Solved

Posted 3/15/2021 6:23 PM

This issue has been resolved in SOQL Studio 2021.1.290, released Monday, 3/15/2021