Can anyone help me for implementing this requirement .    

• Search all Chatter posts for Open Opportunities and identify the most recent that contains “#nextstep”.
• If a Chatter post is found, strip out the text of that post and update the Opportunity Next Step field with the Chatter text.

It's urgent ....i have tried this but i have not understood what is the meaning for text of that Chatter post

Please help...

Thanks in advanced

Hello,

I have a simple trigger on the Opportunity object that fires when an Opportunity is edited and forces an edit/save on the OpportunityLineItems associated with the Opportunity.  When I try to Data Load some bulk changes, I get the following error:

System.LimitException: Too many SOQL queries: 101

I'm fairly new to Apex code.  I believe the problem is that I am running SOQL inside a FOR loop, but I'm not quite sure how to resolve it.  My trigger is below.  Any help would be appreciated.  Thanks.

trigger UpdateDeliverables on Opportunity (after insert, after update) {
   // Forces Edit/Save on Deliverables in order to fire Workflow field Update to update quantity field with Q__c value    

FOR(Opportunity opp : Trigger.new)  {

    LIST<OpportunityLineItem> oppLine = [SELECT Id
    FROM OpportunityLineItem
    WHERE OpportunityId = :opp.Id
    AND Flat_Price__c != TRUE];
    
    IF(oppLine.size() > 0)
    update oppLine;
    }

}

i Created the Trigger for Lead Conversion to Custom object. Now i Need BulkTrigger for Lead Conversion. i can try but still i am not completed how to  create the BulkTrigger. in this Trigger i am using Two custom objects.i.e Agency and Broker once Lead is converted Lead Name goes to Broker and Company goes to Agency object.This code working fine but this not Bulk Process. i need BulkProcess for this Trigger.Please help me.................

Trigger

=======

trigger ConvertLead on Lead (after insert, after update) {

if (Trigger.new.size()> 0){

if(Trigger.new[0].isConverted == true && Trigger.new[0].Lead_type_picklist__c =='Broker') {
   

   if (Trigger.new[0].ConvertedAccountId != null){

for(Account a :[Select a.Id,a.Name,a.Description,a.BillingStreet,a.BillingState, a.BillingPostalCode, a.BillingCountry, a.BillingCity,a.county__c,a.phone From Account a Where a.Id =:Trigger.new[0].ConvertedAccountId]){
ag = new Agency__c();
ag.Name = a.Name;
ag.Mailing_Address__c = a.BillingStreet;
ag.City__c =a.BillingCity;
ag.State__c = a.BillingState;
ag.County__c = a.County__c;
ag.Zip_Code__c = a.BillingPostalCode;
ag.Account__c = Trigger.new[0].ConvertedAccountId;
ag.Phone__c = a.Phone;
}
insert ag;
}
List<Contact> con = new List<Contact>();
List<Broker__c> brokers = new List<Broker__c>();

if(Trigger.new[0].ConvertedContactId != null){

for(Contact c :[Select id,Name,Description,AccountId from Contact where Id = :Trigger.new[0].ConvertedContactId]){
Broker__c b = new Broker__c();
b.Name = c.Name;
b.Agency__c = ag.id;
b.Contact_ID__c = c.Id;
brokers.add(b);
}
insert brokers;
}
}
}
}

how can i created BulkProcess for this Trigger pls help................

Hi Everyone,

I want to copy approval histroy from one object to another object. Could anyone help me on this. Does anyone know how to copy 

this using apex.

Regards,

Rajiv

Could anyone help me on this, I am getting very strange error in  the Sandbox.

For example if I am trying to write below code an error appears  Variable  does not exist :Id

trigger demo on Opportunity (after insert) {

List<Id> oppIds = new List<Id>();
    for(Opportunity opp : Trigger.new){

        oppIds.add(opp.Id);
    }

}

I don't understand why this strange error is coming that Id does not exist.

Id is a standard  field of opportunity, could any one help me to resolve this issue or anyone knows why this error is coming. 

It will be really appreciated. Thanks !!

Regards,

Rajiv Roy

Can anyone help me for implementing this requirement .    

• Search all Chatter posts for Open Opportunities and identify the most recent that contains “#nextstep”.
• If a Chatter post is found, strip out the text of that post and update the Opportunity Next Step field with the Chatter text.

It's urgent ....i have tried this but i have not understood what is the meaning for text of that Chatter post

Please help...

Thanks in advanced

Hi Guys,

I am sending a mail where image gets attached to it. Its working fine but due to hard code now its creating problem. It's trigger which sends email to customer along with image. We need to make this URL dynamic can anybody no how can we implement this or make this URL dynamic. I want to show the image along with the mail.   String htmlbody = '<img src="http://na1.salesforce.com/img/response_peops.jpg"/> 

When I remove img tag then only link displays. I want that image to be appears in the email.Can anybody know how can we do this. It's really appreciated.

Thanks,

Hello,

I have a simple trigger on the Opportunity object that fires when an Opportunity is edited and forces an edit/save on the OpportunityLineItems associated with the Opportunity.  When I try to Data Load some bulk changes, I get the following error:

System.LimitException: Too many SOQL queries: 101

I'm fairly new to Apex code.  I believe the problem is that I am running SOQL inside a FOR loop, but I'm not quite sure how to resolve it.  My trigger is below.  Any help would be appreciated.  Thanks.

trigger UpdateDeliverables on Opportunity (after insert, after update) {
   // Forces Edit/Save on Deliverables in order to fire Workflow field Update to update quantity field with Q__c value    

FOR(Opportunity opp : Trigger.new)  {

    LIST<OpportunityLineItem> oppLine = [SELECT Id
    FROM OpportunityLineItem
    WHERE OpportunityId = :opp.Id
    AND Flat_Price__c != TRUE];
    
    IF(oppLine.size() > 0)
    update oppLine;
    }

}

I am facing this issue.Can anybody help me out?

"

Update error code CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY: ReconcileOrder: execution of BeforeUpdate caused by: System.Exception: Apex heap size too large: 5218807

"

i Created the Trigger for Lead Conversion to Custom object. Now i Need BulkTrigger for Lead Conversion. i can try but still i am not completed how to  create the BulkTrigger. in this Trigger i am using Two custom objects.i.e Agency and Broker once Lead is converted Lead Name goes to Broker and Company goes to Agency object.This code working fine but this not Bulk Process. i need BulkProcess for this Trigger.Please help me.................

Trigger

=======

trigger ConvertLead on Lead (after insert, after update) {

if (Trigger.new.size()> 0){

if(Trigger.new[0].isConverted == true && Trigger.new[0].Lead_type_picklist__c =='Broker') {
   

   if (Trigger.new[0].ConvertedAccountId != null){

for(Account a :[Select a.Id,a.Name,a.Description,a.BillingStreet,a.BillingState, a.BillingPostalCode, a.BillingCountry, a.BillingCity,a.county__c,a.phone From Account a Where a.Id =:Trigger.new[0].ConvertedAccountId]){
ag = new Agency__c();
ag.Name = a.Name;
ag.Mailing_Address__c = a.BillingStreet;
ag.City__c =a.BillingCity;
ag.State__c = a.BillingState;
ag.County__c = a.County__c;
ag.Zip_Code__c = a.BillingPostalCode;
ag.Account__c = Trigger.new[0].ConvertedAccountId;
ag.Phone__c = a.Phone;
}
insert ag;
}
List<Contact> con = new List<Contact>();
List<Broker__c> brokers = new List<Broker__c>();

if(Trigger.new[0].ConvertedContactId != null){

for(Contact c :[Select id,Name,Description,AccountId from Contact where Id = :Trigger.new[0].ConvertedContactId]){
Broker__c b = new Broker__c();
b.Name = c.Name;
b.Agency__c = ag.id;
b.Contact_ID__c = c.Id;
brokers.add(b);
}
insert brokers;
}
}
}
}

how can i created BulkProcess for this Trigger pls help................

Hi all, apex n00b here...

I am trying to modify this lovely VF example from Jeff Doyglas (http://blog.jeffdouglas.com/2009/05/08/inline-visualforce-pages-with-standard-page-layouts/) to enable Activity History searching for my users. Everything goes great until actually attempting to search, where I receive this error:

System.QueryException: entity type ActivityHistory does not support query 

Class.ActivitySearchController.search: line 39, column 1

Can anyone offer a suggestion for modifying the class below to make this work? I know that ActivityHistory querying requires a relationship query, but I am not sure how to achieve this in the following scenario:

public class ActivitySearchController {
 
    //added an instance varaible for the standard controller
    private ApexPages.StandardController controller {get; set;}
    // the actual account
    private Account a;
    // the results from the search. do not init the results or a blank rows show up initially on page load
    public List<ActivityHistory> searchResults {get;set;}
 
    // the text in the search box
    public string searchText {
        get {
            if (searchText == null) searchText = 'Enter keywords'; // prefill the search box for ease of use
            return searchText;
        }
        set;
    }
 
    public ActivitySearchController(ApexPages.StandardController controller) {
 
        //initialize the stanrdard controller
        this.controller = controller;
        this.a = (Account)controller.getRecord();
 
    }
 
    // fired when the search button is clicked
    public PageReference search() {
        if (searchResults == null) {
            searchResults = new List<ActivityHistory>(); // init the list if it is null
        } else {
            searchResults.clear(); // clear out the current results if they exist
        }
        // Note: you could have achieved the same results as above by just using:
        // searchResults = new List<categoryWrapper>();
     
        // use some dynamic soql to find the related activities by subject
        String qry = 'Select ah.Id, ah.subject, ah.whoid, ah.whatid, ah.accountid, ah.ownerid, ah.activitydate, ah.description from ActivityHistory ah Where AccountId = \''+a.Id+'\' And ah.Subject LIKE \'%'+searchText+'%\' Order By ah.Subject';
        searchResults = Database.query(qry);
        return null;
    }
 
}