Questions tagged [group-by]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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
58 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
222 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
25 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
102 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
221 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
41 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
528 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 ...
2
votes
1answer
163 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
146 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
31 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
65 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
2k 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
468 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
3k 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
53 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
393 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
312 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
106 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
190 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
220 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
296 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
33 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
36 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
963 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
230 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
222 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
36 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
2k 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
908 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 ...
1
vote
1answer
3k 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
278 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
245 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
673 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
196 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 ...
5
votes
1answer
545 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
56 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
141 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
148 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
316 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
388 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
940 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
118 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
61 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
767 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, ...
2
votes
1answer
58 views

Limit results from list

I have a helper class in which I'm trying to create a new record using information from various other related records that are gathered using maps and lists. My problem is that I'm trying to build a ...
3
votes
3answers
1k views

SOQL: Recent date grouped by AccountId

OBJECTIVE I am simply trying to return the most recent activity for a given list of accounts: List<Id>. I just want 1 row for each Account ID that gets passed. For each row I need the ...