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?
Does Germany produce more waste than the US?
Is it correct to say moon starry nights?
Can I calculate next year's exemptions based on this year's refund/amount owed?
Aggressive Under-Indexing and no data for missing index
Defamation due to breach of confidentiality
Reshaping json / reparing json inside shell script (remove trailing comma)
Help understanding this unsettling image of Titan, Epimetheus, and Saturn's rings?
(How) Could a medieval fantasy world survive a magic-induced "nuclear winter"?
In the "Harry Potter and the Order of the Phoenix" videogame, what potion is used to sabotage Umbridge's speakers?
What CSS properties can the br tag have?
What day is it again?
How to use ReplaceAll on an expression that contains a rule
Is it okay to majorly distort historical facts while writing a fiction story?
Is there a reasonable and studied concept of reduction between regular languages?
How to explain the utility of binomial logistic regression when the predictors are purely categorical
Reference request: Grassmannian and Plucker coordinates in type B, C, D
Is there an equivalent of cd - for cp or mv
Is French Guiana a (hard) EU border?
Why don't programming languages automatically manage the synchronous/asynchronous problem?
Calculate the Mean mean of two numbers
How did some of my text get highlighted with a magenta background?
"Eavesdropping" vs "Listen in on"
What is the difference between "hamstring tendon" and "common hamstring tendon"?
IC has pull-down resistors on SMBus lines?
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 2 days ago
Jayant Das
17.4k21330
asked 2 days 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 2 days ago
Jayant Das
17.4k21330
asked 2 days ago
BoDiE2003BoDiE2003
231211
3
Are you sure the other query works? You haveANDbeforeGROUP BY, that should not work either.
– Jayant Das
2 days 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 2 days ago
Jayant Das
17.4k21330
asked 2 days 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 2 days ago
Jayant Das
17.4k21330
asked 2 days ago
BoDiE2003BoDiE2003
231211
edited 2 days ago
Jayant Das
17.4k21330
asked 2 days ago
BoDiE2003BoDiE2003
231211
edited 2 days ago
Jayant Das
17.4k21330
edited 2 days ago
Jayant Das
17.4k21330
edited 2 days ago
Jayant Das
17.4k21330
17.4k21330
asked 2 days ago
BoDiE2003BoDiE2003
231211
asked 2 days ago
BoDiE2003BoDiE2003
231211
asked 2 days ago
BoDiE2003BoDiE2003
231211
231211
3
Are you sure the other query works? You haveANDbeforeGROUP BY, that should not work either.
– Jayant Das
2 days ago
add a comment |
3
Are you sure the other query works? You haveANDbeforeGROUP BY, that should not work either.
– Jayant Das
2 days ago
3
3
Are you sure the other query works? You have
AND before GROUP BY, that should not work either.– Jayant Das
2 days ago
Are you sure the other query works? You have
AND before GROUP BY, that should not work either.– Jayant Das
2 days 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 2 days ago
Sebastian KesselSebastian Kessel
9,02862238
1
Just found it too. Thank you!
– BoDiE2003
2 days ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
2 days ago
add a comment |
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 2 days ago
Sebastian KesselSebastian Kessel
9,02862238
1
Just found it too. Thank you!
– BoDiE2003
2 days ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
2 days 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 2 days ago
Sebastian KesselSebastian Kessel
9,02862238
1
Just found it too. Thank you!
– BoDiE2003
2 days ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
2 days 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 2 days ago
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 2 days ago
Sebastian KesselSebastian Kessel
9,02862238
answered 2 days ago
Sebastian KesselSebastian Kessel
9,02862238
answered 2 days ago
Sebastian KesselSebastian Kessel
9,02862238
answered 2 days ago
Sebastian KesselSebastian Kessel
9,02862238
9,02862238
1
Just found it too. Thank you!
– BoDiE2003
2 days ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
2 days ago
add a comment |
1
Just found it too. Thank you!
– BoDiE2003
2 days ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
2 days ago
1
1
Just found it too. Thank you!
– BoDiE2003
2 days ago
Just found it too. Thank you!
– BoDiE2003
2 days ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
2 days ago
Nice! If it helped, marked the answer as accepted so others can benefit as well
– Sebastian Kessel
2 days 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
2 days ago