Arsthbt

Finding quadratic residues without Legendre symbols

Skipping indices in a product

Inappropriate reference requests from Journal reviewers

Really confused on what inner tube would fit my BF’s new bike?

How do I go from 300 unfinished/half written blog posts, to published posts?

Is micro rebar a better way to reinforce concrete than rebar?

What does convergence in distribution "in the Gromov–Hausdorff" sense mean?

Can I equip Skullclamp on a creature I am sacrificing?

FBX seems to be empty when imported into Blender

Is it ever safe to open a suspicious html file (e.g. email attachment)?

How to count occurrences of text in a file?

On model categories where every object is bifibrant

How are problems classified in Complexity Theory?

Is there a difference between "Fahrstuhl" and "Aufzug"

Why do remote companies require working in the US?

Disadvantage of gaining multiple levels at once in a short milestone-XP game

Giving the same color to different shapefiles in QGIS

How to make a variable always equal to the result of some calculations?

How to prepend a string to only the lines of text which are numbers

At which OSI layer a user-generated data resides?

If the heap is initialized for security, then why is the stack uninitialized?

WOW air has ceased operation, can I get my tickets refunded?

Was a professor correct to chastise me for writing "Prof. X" rather than "Professor X"?

Would this house-rule that treats advantage as a +1 to the roll instead (and disadvantage as -1) and allows them to stack be balanced?

SOQL: Aggregate, Grouping By and WHERE Clauses not working

1

This query

SELECT Reason, COUNT(Id) 
FROM Case 
WHERE RecordType.DeveloperName = 'Problem' AND AccountId = 'xxxx' 
AND GROUP BY Reason

is giving me

Unknown parsing error:

But when I run the same query without the RecordType.DeveloperName = 'Problem' it works, whats the issue?

SELECT Reason, COUNT(Id) 
FROM Case 
WHERE AccountId = 'xxxx' AND GROUP BY Reason

Thank you

aggregate group-by count

share|improve this question

edited 3 hours ago

Jayant Das

17.4k21330

asked 3 hours ago

BoDiE2003BoDiE2003

231211

• 
  
  
  

  
  3
  

  
  
  
  
  
  

  
  
  Are you sure the other query works? You have AND before GROUP BY, that should not work either.
  
  – Jayant Das
  3 hours ago
  

  
  
  
  

add a comment | 

1

This query

SELECT Reason, COUNT(Id) 
FROM Case 
WHERE RecordType.DeveloperName = 'Problem' AND AccountId = 'xxxx' 
AND GROUP BY Reason

is giving me

Unknown parsing error:

But when I run the same query without the RecordType.DeveloperName = 'Problem' it works, whats the issue?

SELECT Reason, COUNT(Id) 
FROM Case 
WHERE AccountId = 'xxxx' AND GROUP BY Reason

Thank you

aggregate group-by count

share|improve this question

edited 3 hours ago

Jayant Das

17.4k21330

asked 3 hours ago

BoDiE2003BoDiE2003

231211

• 
  
  
  

  
  3
  

  
  
  
  
  
  

  
  
  Are you sure the other query works? You have AND before GROUP BY, that should not work either.
  
  – Jayant Das
  3 hours ago
  

  
  
  
  

add a comment | 

This query

SELECT Reason, COUNT(Id) 
FROM Case 
WHERE RecordType.DeveloperName = 'Problem' AND AccountId = 'xxxx' 
AND GROUP BY Reason

is giving me

Unknown parsing error:

But when I run the same query without the RecordType.DeveloperName = 'Problem' it works, whats the issue?

SELECT Reason, COUNT(Id) 
FROM Case 
WHERE AccountId = 'xxxx' AND GROUP BY Reason

Thank you

aggregate group-by count

share|improve this question

edited 3 hours ago

Jayant Das

17.4k21330

asked 3 hours ago

BoDiE2003BoDiE2003

231211

SELECT Reason, COUNT(Id) 
FROM Case 
WHERE RecordType.DeveloperName = 'Problem' AND AccountId = 'xxxx' 
AND GROUP BY Reason

SELECT Reason, COUNT(Id) 
FROM Case 
WHERE AccountId = 'xxxx' AND GROUP BY Reason

share|improve this question

edited 3 hours ago

Jayant Das

17.4k21330

asked 3 hours ago

BoDiE2003BoDiE2003

231211

share|improve this question

edited 3 hours ago

Jayant Das

17.4k21330

asked 3 hours ago

BoDiE2003BoDiE2003

231211

edited 3 hours ago

Jayant Das

17.4k21330

edited 3 hours ago

Jayant Das

17.4k21330

asked 3 hours ago

BoDiE2003BoDiE2003

231211

asked 3 hours ago

BoDiE2003BoDiE2003

231211

1 Answer
1

active

oldest

votes

4

Your problem is the last AND.

The right query is:

SELECT Reason, COUNT(Id) 
FROM Case 
WHERE RecordType.DeveloperName = 'Problem' AND AccountId = 'xxxx' 
GROUP BY Reason

share|improve this answer

answered 3 hours ago

Sebastian KesselSebastian Kessel

9,00862238

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Just found it too. Thank you!
  
  – BoDiE2003
  3 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Nice! If it helped, marked the answer as accepted so others can benefit as well
  
  – Sebastian Kessel
  3 hours ago
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "459"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f255875%2fsoql-aggregate-grouping-by-and-where-clauses-not-working%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

4

Your problem is the last AND.

The right query is:

SELECT Reason, COUNT(Id) 
FROM Case 
WHERE RecordType.DeveloperName = 'Problem' AND AccountId = 'xxxx' 
GROUP BY Reason

share|improve this answer

answered 3 hours ago

Sebastian KesselSebastian Kessel

9,00862238

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Just found it too. Thank you!
  
  – BoDiE2003
  3 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Nice! If it helped, marked the answer as accepted so others can benefit as well
  
  – Sebastian Kessel
  3 hours ago
  

  
  
  
  

add a comment | 

4

Your problem is the last AND.

The right query is:

SELECT Reason, COUNT(Id) 
FROM Case 
WHERE RecordType.DeveloperName = 'Problem' AND AccountId = 'xxxx' 
GROUP BY Reason

share|improve this answer

answered 3 hours ago

Sebastian KesselSebastian Kessel

9,00862238

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Just found it too. Thank you!
  
  – BoDiE2003
  3 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Nice! If it helped, marked the answer as accepted so others can benefit as well
  
  – Sebastian Kessel
  3 hours ago
  

  
  
  
  

add a comment | 

Your problem is the last AND.

The right query is:

SELECT Reason, COUNT(Id) 
FROM Case 
WHERE RecordType.DeveloperName = 'Problem' AND AccountId = 'xxxx' 
GROUP BY Reason

share|improve this answer

answered 3 hours ago

Sebastian KesselSebastian Kessel

9,00862238

SELECT Reason, COUNT(Id) 
FROM Case 
WHERE RecordType.DeveloperName = 'Problem' AND AccountId = 'xxxx' 
GROUP BY Reason

share|improve this answer

answered 3 hours ago

Sebastian KesselSebastian Kessel

9,00862238

answered 3 hours ago

Sebastian KesselSebastian Kessel

9,00862238

answered 3 hours ago

Sebastian KesselSebastian Kessel

9,00862238