• Karthik Training
  • NEWBIE
  • 0 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 4
    Replies
User-added image 
like this type of attachment code by using jqury or javascript or html
please provide immediatly
I'm working on a visualforce email template. I'm trying to display a textarea only if a certain checkbox is unchecked, but I keep getting a syntax error.
Here is my code:

 <apex:outputText rendered="{!IF({!cx.Activity_Completed__c}= FALSE)}"><apex:param value="{!cx.Activity__c}" /></apex:outputText>
​Hi All,
 
I have a schedule class which invokes the batch class to insert / update records.
 
Due to this DML operations another apex class is getting called by Trigger.
In this apex class I have soql query (which is doing some aggregations) hitting the governor limit.
 
In debug log the aggregation query is returning 2270 rows, but salesforce is throwing an exception like System.LimitException: Too many query rows: 50001
My log is below
 
09:55:21.430 (42430723507)|SOQL_EXECUTE_BEGIN|[550]|Aggregations:0|SELECT SUM(Total__c) totalAmt, SUM(Total_Lifts__c) totalLifts, Service__c serviceId, Invoice_Start_Date_New__c invStartDate, Invoice_End_Date_New__c invEndDate FROM Purchase_Invoice_Line_Item__c WHERE (Service__c = :tmpVar1 AND Total__c != NULL AND Invoice_Date__c != NULL AND Invoice_Start_Date_New__c != NULL AND Invoice_End_Date_New__c != NULL) GROUP BY Service__c, Invoice_Start_Date_New__c, Invoice_End_Date_New__c
09:55:21.766 (42766218603)|SOQL_EXECUTE_END|[550]|Rows:2270
09:55:21.766 (42766286835)|EXCEPTION_THROWN|[550]|System.LimitException: Too many query rows: 50001
09:55:21.766 (42766462757)|METHOD_EXIT|[11]|01pw0000000FM3g|TGH_ILI_Helper.createInvoicePurchaseLineItem(List<Purchase_Invoice_Line_Item__c>, Boolean)
09:55:21.766 (42766563397)|FATAL_ERROR|System.LimitException: Too many query rows: 50001
 
Hope someone can help me to overcome this limit exception
 

Dear All,

 

I have the problem on SOQL to select past Event from below command but it does not compare the time , i tried system.now() but it did not work.

 

Could you please advise .

 

Select ActivityDateTime  From Event where whatid=:tsk.whatid and  
            what.type = 'Account' and ActivityDateTime <> null and    ActivityDateTime >=LAST_N_DAYS:0  

 

Thank you very much in advance for your help.

 

Best Regards

Anong         

  • January 04, 2011
  • Like
  • 1