SOQL: Aggregate, Grouping By and WHERE Clauses not working The Next CEO of Stack Overflow2019 Community Moderator ElectionReference fields on parent object in aggregate queryAggregate SOQL with more than one 'group by'Aggregating Results: Not grouping properlyWhy am I getting group by aggregate errors in this querySalesforce group byAggregate Values with Limits and OrdersGroup By in SoqlSalesforce google charts group by aggregate query not pulling appropriate resultsSOQL Conditional Counting?Do custom metadata types not support COUNT(fieldName) with a GROUP BY?
If the heap is initialized for security, then why is the stack uninitialized?
Non-deterministic sum of floats
Would a galaxy be visible from outside, but nearby?
What is ( CFMCC ) on ILS approach chart?
How are problems classified in Complexity Theory?
Novel about a guy who is possessed by the divine essence and the world ends?
Are there any limitations on attacking while grappling?
Why do we use the plural of movies in this phrase "We went to the movies last night."?
MessageLevel in QGIS3
Rotate a column
On model categories where every object is bifibrant
Can I equip Skullclamp on a creature I am sacrificing?
A "random" question: usage of "random" as adjective in Spanish
At which OSI layer a user-generated data resides?
In excess I'm lethal
What's the best way to handle refactoring a big file?
Written every which way
Why do professional authors make "consistency" mistakes? And how to avoid them?
How do I go from 300 unfinished/half written blog posts, to published posts?
How does the mv command work with external drives?
How to start emacs in "nothing" mode (`fundamental-mode`)
"and that skill is always a class skill for you" - does "always" have any meaning in Pathfinder?
What exact does MIB represent in SNMP? How is it different from OID?
Bold, vivid family
SOQL: Aggregate, Grouping By and WHERE Clauses not working
The Next CEO of Stack Overflow2019 Community Moderator ElectionReference fields on parent object in aggregate queryAggregate SOQL with more than one 'group by'Aggregating Results: Not grouping properlyWhy am I getting group by aggregate errors in this querySalesforce group byAggregate Values with Limits and OrdersGroup By in SoqlSalesforce google charts group by aggregate query not pulling appropriate resultsSOQL Conditional Counting?Do custom metadata types not support COUNT(fieldName) with a GROUP BY?
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
edited 4 hours ago
Jayant Das
17.4k21330
asked 4 hours ago
BoDiE2003BoDiE2003
231211
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
edited 4 hours ago
Jayant Das
17.4k21330
asked 4 hours ago
BoDiE2003BoDiE2003
231211
3
Are you sure the other query works? You haveANDbeforeGROUP BY, that should not work either.
– Jayant Das
4 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
edited 4 hours ago
Jayant Das
17.4k21330
asked 4 hours ago
BoDiE2003BoDiE2003
231211
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
aggregate group-by count
edited 4 hours ago
Jayant Das
17.4k21330
asked 4 hours ago
BoDiE2003BoDiE2003
231211
edited 4 hours ago
Jayant Das
17.4k21330
asked 4 hours ago
BoDiE2003BoDiE2003
231211
edited 4 hours ago
Jayant Das
17.4k21330
edited 4 hours ago
Jayant Das
17.4k21330
edited 4 hours ago
Jayant Das
17.4k21330
17.4k21330
asked 4 hours ago
BoDiE2003BoDiE2003
231211
asked 4 hours ago
BoDiE2003BoDiE2003
231211
asked 4 hours ago
BoDiE2003BoDiE2003
231211
231211
3
Are you sure the other query works? You haveANDbeforeGROUP BY, that should not work either.
– Jayant Das
4 hours ago
add a comment |
3
Are you sure the other query works? You haveANDbeforeGROUP BY, that should not work either.
– Jayant Das
4 hours ago
3
3
Are you sure the other query works? You have
AND before GROUP BY, that should not work either.– Jayant Das
4 hours ago
Are you sure the other query works? You have
AND before GROUP BY, that should not work either.– Jayant Das
4 hours ago
add a comment |
1 Answer
1
active
oldest
votes
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
answered 4 hours ago
Sebastian KesselSebastian Kessel
9,00862238
1
Just found it too. Thank you!
– BoDiE2003
4 hours ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
4 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
);
);
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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
answered 4 hours ago
Sebastian KesselSebastian Kessel
9,00862238
1
Just found it too. Thank you!
– BoDiE2003
4 hours ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
4 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
answered 4 hours ago
Sebastian KesselSebastian Kessel
9,00862238
1
Just found it too. Thank you!
– BoDiE2003
4 hours ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
4 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
answered 4 hours ago
Sebastian KesselSebastian Kessel
9,00862238
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
answered 4 hours ago
Sebastian KesselSebastian Kessel
9,00862238
answered 4 hours ago
Sebastian KesselSebastian Kessel
9,00862238
answered 4 hours ago
Sebastian KesselSebastian Kessel
9,00862238
answered 4 hours ago
Sebastian KesselSebastian Kessel
9,00862238
9,00862238
1
Just found it too. Thank you!
– BoDiE2003
4 hours ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
4 hours ago
add a comment |
1
Just found it too. Thank you!
– BoDiE2003
4 hours ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
4 hours ago
1
1
Just found it too. Thank you!
– BoDiE2003
4 hours ago
Just found it too. Thank you!
– BoDiE2003
4 hours ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
4 hours ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
4 hours ago
add a comment |
Thanks for contributing an answer to Salesforce Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
3
Are you sure the other query works? You have
ANDbeforeGROUP BY, that should not work either.– Jayant Das
4 hours ago