Questions tagged [group-by]
The group-by tag has no usage guidance.
61
questions
0
votes
1answer
28 views
another GROUP and ORDER SOQL question
Honestly, I have never understood how the GROUP keyword works, I actually read many articles in the salesforce site; however, I still cannot really use this keyword properly, especially when it comes ...
-1
votes
1answer
31 views
Apex TOP 20 Accounts grouped by text field
I would need support with my Apex Code.
I want to get the TOP 20 Accounts ordered by a Number field "Total Quantity" grouped by a text field "Country".
I need to get all the IDs of those accounts. ...
0
votes
0answers
13 views
For Each Month, summarize Interest Payments
Objective
Summarize weekly, Customer interest payments that are occurring each month. I am using Salesforce Lightning.
Background
Each Customer has a "Start Date" and a "Maturity Date" on a "Loan",...
0
votes
0answers
59 views
SOQL count number of grouped rows
Here's the gist of my query:
Select count(Id) from OBJECT where (yada yada) GROUP By Field1, Field2
It's returning 43 rows of Count(Id). Instead, I need it to return 43. I've seen others answer ...
15
votes
1answer
269 views
Is Salesforce SOQL GROUP BY case sensitive for different locales?
Lets say I have records with values like 'TEST DATA' and 'test data' in some field. When I run SOQL (in Developer Console or from Apex) by user with EN locale, it arranges records with 'TEST DATA' and ...
0
votes
1answer
59 views
Can you include only top 10 records in SOQL group?
I have the following Query
[Select Supplier__c, Avg(Total_Sales__c) from Submittal group by Supplier__c order by Purchase_Date__c DESC]
The issue is that I only want to include the latest 10 records ...
1
vote
1answer
128 views
SOQL: Aggregate, Grouping By and WHERE Clauses not working
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 ...
1
vote
2answers
560 views
Marketing Cloud -SQL Group BY
I have a table and I need to run some calculations on it for reporting purposes.
I want to add a row that measures counts by that month. And I'm attempting to use the following statement:
SELECT
...
1
vote
2answers
60 views
Access SOQL results by grouped field
I'm attempting to aggregate all ObjectPermissions at the user level for a user access review (audit) application. This application's central function is to show an end-user (a reviewer) their reviewee'...
1
vote
2answers
1k views
What types of fields are groupable in a SOQL `GROUP BY` clause?
The Salesforce documentation is notably terse in describing Considerations When Using GROUP BY. The guidance provided for determining which fields can be grouped is simply:
The Field object ...
3
votes
1answer
272 views
error thrown while trying to do a group by
I'm trying to write a query that gives me the name of users and the total number of ids assigned to them.
Here I've Daily_Task__c a custom object with a lot of fields, here I'm trying to get the ...
2
votes
1answer
275 views
Do custom metadata types not support COUNT(fieldName) with a GROUP BY?
Question title covers most of it. Here's a sample query and the error I receive in response:
SELECT COUNT(Id) FROM MyCustom__mdt GROUP BY MyField__c
field Id does not support aggregate operator ...
0
votes
1answer
34 views
How do I create a chart with two lines, using grouping?
What I have: revenue data, summarized by calendar month. I have created a custom summary formula that totals the revenue for that month.
Over all data, I have created a second grouping, based on a ...
1
vote
0answers
72 views
Group by, Complex query
I am trying to do a query that engloves two different querys, the idea is spend just one soql query instead two but I don´t find the way.
AggregateResult[] results = [
SELECT ...
1
vote
2answers
3k views
Formula field cannot be grouped in SOQL GROUP BY query call
I have a Pipeline__c object with fields Segment__c, Status__c, and Sales_Date__c (among many other fields).
I also have a Sub_Pipeline__c object which is related to Pipeline__c. Inside I have the ...
1
vote
1answer
652 views
SOQL aggregate functions do not work with Task.ActivityDate
When I try the following in the Query Editor of the Developer Console:
SELECT WhoID, COUNT(Id), MIN(ActivityDate), MAX(ActivityDate)
FROM Task
GROUP BY WhoID
LIMIT 1000
I get the following error:
...
2
votes
2answers
5k views
How to read field values from AggregateResult
I need to use group by cube to display the count of added services for each group for each package. I get an error on line 18: method does not exist or incorrect signature: void get(String) from the ...
2
votes
1answer
60 views
Group By Cube on Related List
I need to do a group by cube on a related list. What I want is to display a list of added services groups and the distinct count across all completed inspections by package, and the matrix should have ...
1
vote
2answers
518 views
CPQ - Template Section - Group Field - Sorting
I am in the process of using the Group Field in the Template Section object to Group a Line Items section, and am hitting an issue.
It seems to be grouping in alphabetical order of the picklist ...
0
votes
1answer
26 views
List has more than 1 row for assignment to SObject error
Help please, I test the SOQL query in developer Console, and work as expected But, i get error message in the VF
My Controller is:
public class InventoryReport {
public List<...
2
votes
1answer
433 views
Use SOQL aggregation result to count number of related objects
I have a fun puzzle here, and would like to see if anyone has a better solution. There are 3 objects: Account, Infusion__c, Patient__c. Infusion__c is a child of Accounts, and Infusion__c has a ...
5
votes
1answer
123 views
Group By Child Objects
I'm facing some trouble to GROUP BY a SELECT with 2 Child Objects.
This is the following SELECT:
[SELECT
Id AtendId, BI_BR_Adabas__c, BI_BR_Adabas__r.BI_BR_Parceiro__c, BI_BR_Cliente__c,
...
1
vote
1answer
300 views
SOQL record with highest value, GROUP BY not working
We have an object called "Compensation__c". This object contains the compensation a partner receives for selling a "Product2".
"Compensation__c" has a start date. Before this date this compensation ...
2
votes
1answer
270 views
Group by part of string in SOQL
Is there any way to Group By part of string in SOQL.
For example something like:
Select Id, Name from Object__c group by Name.substringBetween('.','.')
So query by part of a string field and not ...
0
votes
1answer
401 views
SOQL Group By Query
I am trying to include an additional currency field in the below Group By query, but receive SOQL error.
"Field must be grouped or aggregated".
Is it possible to add a Currency Field to a Group By ...
1
vote
0answers
35 views
Salesforce google charts group by aggregate query not pulling appropriate results
Set<Id> realBy = new Set<Id>();
for (Projects__c vP1 : [SELECT Id,Name,(SELECT Id, Total_Value__c FROM Proj_Upd__r
WHERE ...
1
vote
1answer
44 views
Report Grouping by Date
I'm relatively new to SF but gaining steam quickly. I've got Opportunities that include a contract start date and contact end date and I am trying to create a report that summarizes who we have ...
0
votes
1answer
1k views
Group By in Soql
I need to group data on the basis of two fields "description" and "createdDate" in soql.
Select Subject, WhatId, what.name, Owner.name, Owner.Id, IsVisibleInSelfService, ActivityDate, ...
2
votes
1answer
443 views
SOQL: Get most recent amount grouped by a parent and a type
Should be simple had it been SQL. But. I would like to get the amount field value that belongs to the most recent month available for that parent and that type.
Data:
Parent_Id__c Type__c ...
-1
votes
1answer
232 views
Too Many Records in salesforce
I have More amount of Records in salesforce, i have created field as not Unique.So for account Records is created with duplicate Records also,I want to check how many Records contain dulplicate ...
0
votes
2answers
41 views
Query error when use group by
can anyone explain it to me, why my query is error?
here my query :
PYEMPELEMENT__c[] VFLDLSTEmpSeparated = [SELECT Employee_No__c, Period__c FROM PYEMPELEMENT__c GROUP BY Employee_No__c, ...
1
vote
1answer
3k views
How to get unique values of two fields in one SOQL?
I have a custom object named "Performance" in which there are two text fields named "Main Category" and "Sub Category". Here, I would like to first extract the unique values of Main Category from all ...
1
vote
2answers
1k views
Displaying month/year from createdDate in SOQL query
I am very new to Salesforce and struggling to get a query to return the data in the format I require - i.e pushing the results through Conga composer to feed a chart in a powerpoint template. The ...
1
vote
1answer
58 views
StandardSetConnector Aggregate query grouping
I have a pageblock table with the following columns:
Company, Package, Type, Revenue, Age, Users, Total Usage Actions, Top 3 Modules.
All of the fields apart from "Total usage actions" and "Top 3 ...
2
votes
1answer
5k views
how to use group by in soql with lists
Hi friends i'm new to sfdc development I wrote a sample query to fetch opportunities related to account with some conditions try to group i getting error.
my code is:
List<Opportunity_Trial__c>...
0
votes
1answer
324 views
Open rate by domain over time - SQL
I'm trying to figure out open rate over time based on domain however, it seems to error or timeout every time I run it. I've limited it to just gmail, yahoo, and AOL for now.
SELECT
o.domain
, s....
2
votes
2answers
270 views
Salesforce group by
I want to use group by from salesforce query :
SELECT Candidat__c, Commande__c,Statut__c,IsDeleted, TypeContrat__c
FROM Candidature__c
WHERE Candidat__c = '0032000001GAPoXAAX'
AND Statut__c = '...
4
votes
3answers
981 views
Why am I getting group by aggregate errors in this query
I need to count the total number of orgs. Why won't this query work? I get errors not matter what I group or not group. I only put in Group by to try to placate the compiler but he's in a very bad ...
2
votes
1answer
223 views
split before GROUP BY soql
I have a field which has the values in the format [5 digits-3 digits]
12345-123
34646-345
12345-133
I want to Group BY this field with the just the 5 digit number only (not the complete field). How ...
5
votes
1answer
740 views
group by soql query
I have records with same values in custom field, Unique_Name__c. On a Visualforce Page, I have to display records grouped by Unique_Name__c.
Unique_Name__c is custom field on OpportunityLineItem ...
0
votes
1answer
64 views
Consideration of fields to be used in SOQL Group By [duplicate]
I have come to know that a few fields in Salesforce.com are not groupable and that we can make sure whether field is group-able or not with getDescribeSObject.
I would like to know what are the ...
1
vote
1answer
170 views
SOQL query aggregation
I need to provide statistics to the users in my VF Page, showing the total of records they own where the status is New, In progress, Approved, Pending, Converted
I have tried the below query in my ...
0
votes
2answers
1k views
Grouping a VisualForce list by Account
I have created a list in visualforce but it's quite boring. I would like to group by Account so it would look like
HgCapital
Month Subject Activity Date
Feb blah blah blah 01/02/...
1
vote
0answers
167 views
GROUP BY Clause in SOSL (FIND instead of SELECT)
I am looking for the equivalent of the GROUP BY statement but then for a FIND query.
I want to do a search on all fields of ContentVersion by a keyword and I want it to return a list of all values in ...
13
votes
1answer
327 views
Aggregate SOQL - How Many Fields Can Be Grouped?
As stated in the title, is there any maximum on the number of fields that can be passed into a GROUP BY clause? I can't find any documentation on it. For example, if I had the following query:
SELECT ...
-1
votes
1answer
447 views
Use group by and limit at the same time in Salesforce report
Good day everyone, I have question about salesforce Report. Suppose I have a product object with field product_name and quantity. Now I want to create a report that will get the total quantity of ...
3
votes
1answer
1k views
Querying distinct logins using LoginHistory and COUNT_DISTINCT
I seem to have run in to a SOQL error that I'm hoping someone has solved before.
I am creating a dashboard for UserLogins using the LoginHistory object
The query I am trying to run is:
SELECT ...
0
votes
1answer
133 views
Grouping StageName history by CreatedDate
I am struggling with this query I am trying to do. I want to count how many times we went to a specific stage grouped by weeks. There is something very strange though, I can select count(stagename) ...
1
vote
1answer
65 views
Group by: Combining two groups
I need help with this query. It returns me with 3 groups: Closed, Waiting and In progress. However I want to combine the Waiting and In progress groups to see the Closed vs not closed. How can I do ...
3
votes
3answers
806 views
How to parse the returned value of a query using a GROUP BY and Force.com-Toolkit-for-PHP
I'm selecting custom fields from an object and using GROUP BY to return those fields without repeating them.
Something like this:
SELECT
Produto__r.Name,
Produto__r.Id,
...
