SOQL: Aggregate, Grouping By and WHERE Clauses not working
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
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
edited Mar 29 at 16:27
Jayant Das
17.8k21330
asked Mar 29 at 16:25
BoDiE2003BoDiE2003
231211
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
edited Mar 29 at 16:27
Jayant Das
17.8k21330
asked Mar 29 at 16:25
BoDiE2003BoDiE2003
231211
3
Are you sure the other query works? You haveANDbeforeGROUP BY, that should not work either.
– Jayant Das
Mar 29 at 16:30
add a comment |
1
1
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
edited Mar 29 at 16:27
Jayant Das
17.8k21330
asked Mar 29 at 16:25
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 Mar 29 at 16:27
Jayant Das
17.8k21330
asked Mar 29 at 16:25
BoDiE2003BoDiE2003
231211
edited Mar 29 at 16:27
Jayant Das
17.8k21330
asked Mar 29 at 16:25
BoDiE2003BoDiE2003
231211
edited Mar 29 at 16:27
Jayant Das
17.8k21330
edited Mar 29 at 16:27
Jayant Das
17.8k21330
edited Mar 29 at 16:27
Jayant Das
17.8k21330
17.8k21330
asked Mar 29 at 16:25
BoDiE2003BoDiE2003
231211
asked Mar 29 at 16:25
BoDiE2003BoDiE2003
231211
asked Mar 29 at 16:25
BoDiE2003BoDiE2003
231211
231211
3
Are you sure the other query works? You haveANDbeforeGROUP BY, that should not work either.
– Jayant Das
Mar 29 at 16:30
add a comment |
3
Are you sure the other query works? You haveANDbeforeGROUP BY, that should not work either.
– Jayant Das
Mar 29 at 16:30
3
3
Are you sure the other query works? You have
AND before GROUP BY, that should not work either.– Jayant Das
Mar 29 at 16:30
Are you sure the other query works? You have
AND before GROUP BY, that should not work either.– Jayant Das
Mar 29 at 16:30
add a comment |
1 Answer
1
active
oldest
votes
5
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 Mar 29 at 16:28
Sebastian KesselSebastian Kessel
9,02862238
1
Just found it too. Thank you!
– BoDiE2003
Mar 29 at 16:30
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
Mar 29 at 16:31
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
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
5
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 Mar 29 at 16:28
Sebastian KesselSebastian Kessel
9,02862238
1
Just found it too. Thank you!
– BoDiE2003
Mar 29 at 16:30
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
Mar 29 at 16:31
add a comment |
5
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 Mar 29 at 16:28
Sebastian KesselSebastian Kessel
9,02862238
1
Just found it too. Thank you!
– BoDiE2003
Mar 29 at 16:30
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
Mar 29 at 16:31
add a comment |
5
5
5
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 Mar 29 at 16:28
Sebastian KesselSebastian Kessel
9,02862238
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 Mar 29 at 16:28
Sebastian KesselSebastian Kessel
9,02862238
answered Mar 29 at 16:28
Sebastian KesselSebastian Kessel
9,02862238
answered Mar 29 at 16:28
Sebastian KesselSebastian Kessel
9,02862238
answered Mar 29 at 16:28
Sebastian KesselSebastian Kessel
9,02862238
9,02862238
1
Just found it too. Thank you!
– BoDiE2003
Mar 29 at 16:30
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
Mar 29 at 16:31
add a comment |
1
Just found it too. Thank you!
– BoDiE2003
Mar 29 at 16:30
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
Mar 29 at 16:31
1
1
Just found it too. Thank you!
– BoDiE2003
Mar 29 at 16:30
Just found it too. Thank you!
– BoDiE2003
Mar 29 at 16:30
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
Mar 29 at 16:31
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
Mar 29 at 16:31
add a comment |
draft saved
draft discarded
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.
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
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
Mar 29 at 16:30