Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with aggregate
Search options answers only
not deleted
user 3277
6
votes
1
vote
Aggregate information from multiple contacts into an account
This could be done either by a trigger or a batch job, depending on if you need to the account information to be updated in real time or if its something that could be daily, weekly, etc.
I would l …
- 24.3k
3
votes
Accepted
Number of counts
}
public Integer getFemaleCount(){
return genderCountMap.get('Female');
}
}
Notice I added a property in the controller to hold the countMap, a constructor that uses an aggregate …
- 24.3k
4
votes
Accepted
SOQL Query to count only Accounts with Opps in both this year and last year?
Question 1:
You can just adjust your Where to clause to limit the result to only accounts that have children that match your criteria like this.
Accounts This Year
SELECT ID,
(SELECT Stage …
- 24.3k
18
votes
Accepted
How to use Count() in SOQL
Each aggregate result object retruned by this query will look something like this
{myCount=2, Cabin_Type__c=Twin, Deck_Type__c=2}
Depending on how you plan to use the results would affect how I would …
- 24.3k