The aggregate tag has no wiki summary.
0
votes
1answer
66 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
197 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
53 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 ...
0
votes
1answer
72 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
515 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 ...
