2022 Developer Survey is open! Take survey.

Questions tagged [group-by]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
39 views

SOQL check if unique value exists and throw error message

I want to check if all the records have the same values for "Group__c" field and throw a message if the values are different. Example data: If all the records are of the same group(Group-A ...
user avatar
  • 15
0 votes
0 answers
15 views

issue with dates when add dataset to dashboard and group by date

I have dashboard, which I built based on one dataset. Data is grouped by date (year-month), so measures are presented as 2021-01, 2021-02, 2021-03 etc. and all the history is available (2018-2021). ...
user avatar
  • 1
1 vote
0 answers
45 views

Visualforce table for aggregate result grouped by CreatedBy.Name

I'm trying to create a custom report table in Visualforce based on an aggregate result retrieved by the SOQL: SELECT CreatedBy.Name, Description, SUM(Value1), SUM(Value2), SUM(Value3) FROM Object__c ...
user avatar
  • 11
0 votes
1 answer
248 views

Group By in SOQL query using calendar week from Sunday to Saturday

I have a query that I'm working on where I need to group by in a calendar week that starts on Sunday and ends on Saturday. I was trying this: GROUP BY WEEK_IN_YEAR(Start_Time__c) This was close, but ...
user avatar
  • 2,325
0 votes
1 answer
458 views

Using SAQL to place total at bottom of results instead of alphabetically ordered

I have a SAQL Query which takes a list and attempts to display a total row at the bottom. However, the way that my code is written is causing the Total column to be alphabetically rearranged so that ...
user avatar
0 votes
1 answer
148 views

marketing cloud - how to join my audience with subscribers having a distinct value [closed]

I have an audience in a table called wtab which contains a column mail, and I want to join it with the subscribers data view without duplicates. when I have one 1 column I can use the DISTINCT keyword ...
user avatar
  • 271
0 votes
1 answer
700 views

How to include a row with subtotals by second level group in Einstein Analytics using SAQL?

I would like to add a subtotal row at the bottom of a compare table in an Einstein Analytics dashboard. The table is made up of sums of measures grouped by two dimensions. The subtotals needed are ...
user avatar
  • 1
0 votes
1 answer
93 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 ...
user avatar
  • 1,410
-1 votes
1 answer
38 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. ...
user avatar
0 votes
0 answers
229 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 ...
user avatar
  • 1
15 votes
1 answer
423 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 ...
user avatar
0 votes
1 answer
317 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 ...
user avatar
1 vote
1 answer
369 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 ...
user avatar
  • 405
1 vote
2 answers
2k 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 ...
user avatar
1 vote
2 answers
137 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'...
user avatar
5 votes
3 answers
3k 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 ...
user avatar
  • 86.2k
3 votes
1 answer
518 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 ...
user avatar
2 votes
1 answer
673 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 ...
user avatar
  • 932
0 votes
1 answer
76 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 ...
user avatar
1 vote
0 answers
92 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 ...
user avatar
1 vote
2 answers
6k 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 ...
user avatar
  • 185
2 votes
1 answer
1k 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: ...
user avatar
3 votes
2 answers
13k 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 ...
user avatar
2 votes
1 answer
78 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 ...
user avatar
1 vote
2 answers
816 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 ...
user avatar
0 votes
1 answer
36 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<...
user avatar
2 votes
1 answer
787 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 ...
user avatar
  • 101
5 votes
1 answer
172 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, ...
user avatar
1 vote
1 answer
611 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 ...
user avatar
  • 399
2 votes
1 answer
421 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 ...
user avatar
  • 145
0 votes
1 answer
632 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 ...
user avatar
1 vote
0 answers
37 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 ...
user avatar
1 vote
1 answer
99 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 ...
user avatar
0 votes
1 answer
2k 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, ...
user avatar
  • 902
2 votes
1 answer
1k 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 ...
user avatar
-1 votes
1 answer
318 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 ...
user avatar
  • 648
0 votes
2 answers
43 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, ...
user avatar
  • 67
1 vote
1 answer
6k 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 ...
user avatar
  • 187
1 vote
2 answers
2k 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 ...
user avatar
  • 13
1 vote
1 answer
63 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 ...
user avatar
  • 11
3 votes
1 answer
9k 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>...
user avatar
  • 1,420
0 votes
1 answer
619 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....
user avatar
  • 27
2 votes
2 answers
420 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 = '...
user avatar
  • 123
4 votes
3 answers
2k 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 ...
user avatar
  • 1,206
2 votes
1 answer
261 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 ...
user avatar
  • 3,954
5 votes
1 answer
1k 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 ...
user avatar
  • 2,146
0 votes
1 answer
87 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 ...
user avatar
  • 1,400
1 vote
1 answer
250 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 ...
user avatar
0 votes
2 answers
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/...
user avatar
  • 390
2 votes
0 answers
226 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 ...
user avatar
  • 534