The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
1answer
71 views

Most efficient way to transform AggregateResults to String, Object Maps

Question: What is the most efficient way to transform aggregate results to string object maps? Constraints: The keys of the aggregated results are unknown. The transformation has to be performed as ...
2
votes
3answers
36 views

Issue processing data from aggregate result query

I have a master-detail relation ship where I am updating the parent (lets call it Parent__c) based on its child records aggregated values (lets call the child, Child__c). The child has a relationship ...
0
votes
1answer
33 views

Help with Aggregate Result in Batch Apex

I received some help with this on the Salesforce forums but I can't get over the hump and get it working. The code below saves fine and I'm able to schedule it and it runs through all of the batches. ...
0
votes
1answer
53 views

Problem with AggregateResult

My Rolluputility: public class RollUpSummaryUtility { //the following class will be used to house the field names //and desired operations public class fieldDefinition { public String operation ...
0
votes
1answer
32 views

Better SOQL Query or Ability to Parse Results by Field

I have two objects: OBJECTA ID Description Cost Price SKU OBJECTB ID Qty SKU Essentially, the SQL version of my query would be: SELECT A.Description, A.Cost, A.Price, A.SKU, SUM(B.Qty) FROM A ...
1
vote
1answer
42 views

AggregateResult Count help

Sorry to bother you on a Saturday, but i need some help This is a two part question, so please be patient .I have created a fieldset on the account object called “HistoryTracking”. 1) I would like ...
-1
votes
1answer
36 views

Soql using MAX query [closed]

We are querying max value among certain field values of same data type from an object. we cant form perfect query . could anyone help to get perfect query.
2
votes
1answer
70 views

Remote Objects and Aggregate Function

Is it possible to call count() with remote objects?
4
votes
1answer
60 views

AggregateResult for a multi-select picklist

I am doing an AggregateResult SOQl query on different picklists on a Contact. List<AggregateResult> results = [select LeadSource, COUNT(id)cnt from Contact where LeadSource != null group by ...
2
votes
2answers
108 views

want to achieve rollup summary(SUM) using Aggregate functionss

Compile Error: Expression must be a list type: SOBJECT:AggregateResult at line 7 column 36 (this is line no7:manu.Total_Cost__c = Decimal.valueOf(ar[0].get('total'));) trigger rollupfldsonManuf on ...
6
votes
2answers
325 views

System.QueryException: Aggregate query does not support queryMore()

I am trying to deploy around 80 Components which include Apex Class,Trigger and Visualforce Pages. But it is failing due to below exception, MyTrigger: execution of BeforeInsert caused by: ...
0
votes
3answers
100 views

how to use logic with aggregate result

here i created one code which will retrieve record from "Account" object and create records in "abc" object based on selected fields. i used "AggregateResult" to add numbers with current year and ...
3
votes
1answer
101 views

activity aggregate relationships only allow security evaluation for non-admin users when a single parent record is evaluated

I am getting the following error when I run a Salesforce SOQL query with a standard account. Query: SELECT ( SELECT Id, Subject FROM OpenActivities ORDER BY ActivityDate ASC , LastModifiedDate DESC ...
1
vote
0answers
43 views

Aggregating Results: Not grouping properly

I have a query onto the OpportunityLineItem table. AggregateResult[] OppLineItemsPlays = [select OpportunityId, PricebookEntry.Product2.Play__c, COUNT(id) ...
2
votes
1answer
80 views

Aggregate SOQL with more than one 'group by'

I am using an aggregate SOQL query with more than one 'group by' I'm writing a class that fires on insert/update of a trigger on the OpportunityLineItem. This looks at a picklist field (Play__c) on ...
2
votes
2answers
288 views

Number of counts

I have one student object from that i am displaying values in visualforce page but i want to display number of males and females in that visualforce page i am not getting count of gender i am using ...
6
votes
1answer
373 views

Display the related aggregated value on a VF page

We have a custom VF page that we use in our Org for time entry, and on that page employees select a project, iteration, and enter their time for that week. Note: some employees might be working on ...
5
votes
3answers
2k views

How to use Count() in SOQL

I have a custom object. This custom object has a field Cabin_Type__c, which has values of Twin and Luxury. There is another field Deck_Type__c which is just the number of the deck such as 1,2,3,etc. ...
6
votes
1answer
802 views

Reference fields on parent object in aggregate query

I am trying to run a group by query in Apex where I am grouping by a field on a lookup object. For example: SELECT Account.Type, count(Id)FROM Opportunity GROUP BY Account.Type I can run this from ...
9
votes
2answers
1k views

Can I assign Aggregate SOQL Result directly to variable?

Salesforce documentation suggests that aggregrate soql results must first be assigned to an instance of the AggregateResult class, as shown below: AggregateResult[] groupedResults = [SELECT ...
3
votes
0answers
139 views

Echoing the Counts of each record through PHP using SOQL and GROUP BY

To start, this is the query: $query = "SELECT LeadSource, COUNT(id) Total FROM Lead WHERE CreatedDate > 2013-08-26T00:00:00Z AND CreatedDate < ...
1
vote
2answers
80 views

Aggregate information from multiple contacts into an account

is it possible to create a custom object which will take information from all contacts under an account and aggregate information into that account record? Here's what i'm trying to do specifically... ...
4
votes
1answer
195 views

Efficient way to perform grouping without using aggregate SOQL queries

I have an aggregate query that groups my custom object records by 4-5 fields and then returns a sum of currency fields in each grouping. I have multicurrency enabled so this sum of the currency field ...
2
votes
1answer
989 views

SOQL aggragated query for unique values

I have an object which captures searches made by users. It has a Searc_Phrase__c field. Each record captures one search attempt - the phrase, the use id and the date. I want to query how many times ...
5
votes
1answer
135 views

Aggregate query fails when MyField__c exits in both package (NS_MyField__c) and customer org (MyField__c)

This is really a strange bug. Inside my managed package I have a NAMESPACE_CustomObject__c with a NAMESPACE_CustomField__c. In one of my packaged classes I have an Aggregate Query String soql = ...
3
votes
1answer
977 views

Too many SOQL queries: 101 in apex class. How to count results?

List<tempcon1> listoftemp; CheckContactController chk = new CheckContactController(); public List<tempcon1> getconValues() { listoftemp = new List<tempcon1>(); for ...
4
votes
3answers
2k views

SOQL aggregate query limit

I'm trying to use aggregate queries to save work and script statements. The object has a field for each month representing energy usage for that month for a building. In situations where a building ...
3
votes
2answers
519 views

What makes a field not groupable

I'm trying to use an aggregate query, but one of the fields I want to group by is not groupable (saw it in the soql error and then verified groupable=false in the metadata). It's just a number field ...
1
vote
1answer
693 views

How can i get the id of the max record?

Here is a situation where i need to get the last date of apppointment for a contact and i also need the id of the last appointment date. All appointments are stored in custom object and has a lookup ...
3
votes
4answers
1k views

Non-selective query against large object type in trigger

The Alert__c object has a Rule ID field, which is just text, and a lookup to the Master__c object. I have a trigger on Alert__c, which when runs after insert, update or delete. It collects the Master ...