Search Results

I note that your query includes: WHERE BI_UPDATE_DATE_MSD__c = 2014-09-01 which may be selective enough to allow your query to work. As Working with Very Large SOQL Queries describes, that term wou …

If you take an example of say 5, all your if(nextInvNum tests are true and each one does its assignment with the last one (that only adds a single '0') winning. One way to fix this is: if(nextInvNum …

headervalue="Quantity"> </apex:column> </apex:pageblocktable> </apex:pageblock> </apex:page> The error you were seeing was that you had not provided the alias name "quantity" in the aggregate …

If you mean you want to append the second set of records then this should do it: public List<CoverageTeamMember> getCoverageTeam() { Account a = getAccount(this.controller != null ? this.controll …

The problem is that multiple rows can be merged to create each AVG so you also need to find a way to combined the CreatedDate values of those multiple rows into a single value. I think the only choice …

The AggregateResult object is like a Map and so to access the values you need to use map syntax in the Visualforce: <apex:column value="{!s['total']}"></apex:column> PS Here is a working example o …

I don't understand the two parts of your question but the code below hopefully covers at least part of what you are looking for. Because count(fieldName) is available, some simple dynamic SOQL can be …

Your field/object naming is a little puzzling, but this outline illustrates a general approach to the problem where a single aggregate query is done grouped by the set of SKU values with a map used to …

Here is some (untested) code for one way to do this. Call this method somewhere in your controller to convert the data. It finds the unique origin and status values and adds up the counts for all the …

To add to dphil's answer, for your class it sounds like you want something like this: public class QLWrap implements Comparable { ... public Integer compareTo(Object o) { QLWrap tha …

The problem is probably that you re-initilaise the Summaries list every time round the loop to an empty list so you end up with only 1 item in the final list. This is probably what you want: Summ …

One solution is to modify the logic to also capture Servicer__r.Id in the aggregate queries and to store that in the CoverageTeamMember class (in a field called say servicerId). …

When you execute a query that includes a GROUP BY term it is always an array (list) of AggregateResult objects that is returned - see Working with SOQL Aggregate Functions. …

Surprising. It would be worth looking at the query in the Developer Console Query Plan Tool. (That article includes several links about how Salesforce queries are optimised.) In case it made a differ …