HI,

I have a triger that creates new task when certain fields in opportunity are changed,

however ic annto deplaoy it because i have no test method.

I have been looking thru the posts here and to be honest i dont get it, in normal apex test method is withing he code, but for trigger its not?

in sll samples i saw there is no reffernce to the trigger or maybe i dont undestand how it suppose to be refferenced.

Here is my trigger below, cna anyone please help me out with a simpe test

trigger assignTask on Opportunity (after update) { List<Task> task = new List<Task>(); List<Opportunity> newOpportunity = new List<Opportunity>(); for (Integer i = 0; i < Trigger.new.size(); i++) { if ((Trigger.new[i].Type == 'New Business')&&(Trigger.new[i].CC_Co_ordinator__c !=null)&&(Trigger.new[i].Finance_Status__c =='Pre-Approved')&&(Trigger.new[i].Optimised_Date__c ==NULL)&& (Trigger.new[i].First_Contact_task_created__c != True)) { System.debug('triggerfire'); task.add(new Task( WhatId = Trigger.new[i].Id, OwnerId=Trigger.new[i].CC_Co_ordinator__c, Subject='First Contact ', ActivityDate = System.today() ) ); } } insert task; }

Can anyone tell me what is wrong with this simple trigger?  I'm sure I'm just missing something stupid, I'm just not seeing it.  Maybe I'm just completely off track.  I just need to update a single field on the triggering lead upon Insert or Update.

Eclipse doesn't give me any real error message, it just says that and unexpected error occured and to try again.

My code 

******************

trigger Calculate_Lead_Qualification_Score on Lead (before insert, before update)
{

    for(Lead theLead : trigger.new)  //loop through each lead that is being inserted or updated
        {

       
            //SFDC doesn't like the line below.  No error, it just won't save if this line is included       
            theLead.Lead_Qualification_Score__c = theLead.Application_Suitability_Score__c + theLead.Budget_Score__c + theLead.Role_Score__c + theLead.Timing_For_Purchase_Score__c;
           
            system.debug('Calculated Lead Qualification Score: ' + theLead.Lead_Qualification_Score__c);
        }
   
}

thanks

Jon

I'm just starting to work with the API in PHP and I have run into something odd.

Given this simple query, my results contain everything except the Id of the returned record.

Am I missing something, the Id field is there, but it contains a '0', not the Id of the returned record as expected.

    $query = 'Select UnitPrice, Quantity, PricebookEntryId, OpportunityId, Id From OpportunityLineItem WHERE OpportunityId = \'' . $opportunityId . '\' AND PricebookEntryId = \'' . $salesTaxPricebookEntryId .'\'';
     

      $response = $mySforceConnection->query($query);
      $queryResult = new QueryResult($response);

QueryResult Object
(
    [queryLocator] =>
    [done] => 1
    [records] => Array
        (
            [0] => SObject Object
                (
                    [type] =>
                    [fields] => stdClass Object
                        (
                            [OpportunityId] => 006S0000002pi1YIAQ
                            [PricebookEntryId] => 01uS0000000xeDiIAI
                            [Quantity] => 1.0
                            [UnitPrice] => 47.5
                        )

                    [Id] => 0
                )

        )

    [size] => 1
)

The Outbound Message contains a SessionId and a ServerURL, Is it possible  to use this SessionId and ServerURL to access Salesforce and avoid login/authentication?

Thanks

Jon

The APEX Language Reference and Force.com Developers Guides (among others) state that the New collection can be written to in a Before Insert trigger.   Unfortunately when I try to do so, I get a 'Collection is read-only' error.   What gives?

 Sample code:

trigger ProductKits on OpportunityLineItem (before insert)
{

//test, just add an opportunitylineitem to trigger.new
            OpportunityLineItem bLineItem = new OpportunityLineItem();
                    bLineItem.quantity = 1;
                    bLineItem.UnitPrice = 100.00;
                    bLineItem.Opportunityid = '006S0000002pi1Y';
                    bLineItem.pricebookentryid = '01u80000003LOTJAA4';
            trigger.new.add(bLineItem);

}

I have code in production that passes all unit tests and works fine in most cases but in some instances I am getting an Invalid Query Locator error and I can't figure out why.

My code is a custom rollup trigger that  triggers when a case is 'Closed'.  Rolling up data from cases to their parent accounts.

My code loops through trigger.new to collect the accountid associated with each case that has just closed.  It then loops through the list of accounts pulling and account record and any associated cases.  Finally it loops through the accounts, loops through each account's cases, and adds up all of the appropriate values depositing the result into fields within the Account then updates the account.  A simple rollup really.

This works fine most of the time but I have come across some accounts that fail this process, it doesn't matter which case is closed on the account, I always get the same error so the problem is with the account not with the case.  This account has roughly 340 closed cases, though I don't believe that is anywhere near any kind of limit.

To get to my point, I'm not sure what 'Invalid Query Locator' means in this particular case.  I have seen very little info about the Query Locator, all of it old, but it all suggests problems that occur when querys time out or have been 'garbage collected'.  In this case the error comes back immediately so timeout or memory cleanup should not be an issue.

Below is the relevant code, it's chopped to remove specific custom field names and such so it's pretty ugly.

Any help is greatly appreciated.

Many Thanks

Jon

//if the given trigger has just been closed then roll up the FQTD follup values

set<ID> FQTDAccountIDs = new set<ID>(); //list of Accounts involved with fqtd rollup calculations
map<ID, Account> AccountsToUpdate = new map<ID, Account>(); //the accounts that will be updated by this trigger


//prepare for FQTD rollup

Integer i = 0;
for(case theCase : trigger.new)//loop through all of the available records in the trigger
{
if((trigger.old[i].status != 'Closed') && (trigger.new[i].status == 'Closed'))
{
if(!FQTDAccountIDs.contains(trigger.new[i].accountid))
{
FQTDAccountIDs.add(trigger.new[i].accountid);
System.Debug('Adding Account to the FQTD List: ' + trigger.new[i].accountid);
}
}
i++;
}


//ok, so we may have a list of records to update, lets get to the action
if(FQTDAccountIDs.size() > 0) //do we have any records to update?
{

  //loop through all accounts and add them, with their cases, to a map for later looping

for(Account thisAccount : [Select Id, name, (Select casenumber, status From Cases where status = 'Closed') From Account where id in :FQTDAccountIDs])
{
AccountsToUpdate.put(thisAccount.id, thisAccount);
}


//loop through each specified account
for(Account currentAccount : AccountsToUpdate.values())
{




// ****** This next for loop is the apparent problem; System.Exception: invalid query locator ********

//loop through all cases associated with this account
for(Case theCase : currentAccount.Cases)
{

//calculate the fields and rollup the data
// currentAccount.rolledupfield += theCase.rollupfield1__c + theCase.rollupfield2__c
}



}


//update the Accounts with the new values
update AccountsToUpdate.values();



}

Can anyone give me some pointers on duplicating Hover Links for Events and Tasks? 

I have a method that uses VisualForce loading data into a pane, but it's just not what we are looking for.

Thanks

I have built a simple sort of mini-view to provide details of a record when a link is hovered over with the mouse.  It works fine in my dev environment but the onMouseOver doesn't seem to work in production.

Basicly I have a table of ActivityHistories with an OnMouseOver event on the subject field, when you hover over the subject the Activity loads into an output panel to the right.  It works fine, in dev.

In production I get the list of ActivityHistories but the OnMouseOver does not work.  I'm not getting any javascript errors or anything.

I'm not aware of any settings within Salesforce that turn Javascript on/off but maybe I'm just missing something.   Can anyone give me any idea what I'm missing?

Thanks

 Jon

The Code

<apex:page standardController="Account" sidebar="false" showHeader="false">
   
    <apex:pageBlock title="Activity History">
        <apex:form >
        <table border="0" cellspacing="4">
        <tr>
        <td valign="top" width="375">
            <apex:dataTable value="{!account.ActivityHistories}" var="open" cellPadding="1" cellspacing="4" border="0">
               
               
               
                <apex:column width="200">
                    <apex:facet name="header"><b>Subject</b></apex:facet>
                    <apex:outputPanel >
                        <apex:actionSupport status="requesting" event="onmouseover" rerender="detail" >
                            <apex:param name="cid" value="{!open.id}" />
                        </apex:actionSupport>
                          <b>{!open.Subject}</b>
                    </apex:outputPanel>
                </apex:column>
 
            
               
                <apex:column >
                    <apex:facet name="header"><b>Status</b></apex:facet>
                    {!open.Status}
                </apex:column>

               

            </apex:dataTable>
            </td>
            <td>
           
     <apex:outputPanel id="detail">
        <apex:actionStatus id="requesting" >
            <apex:facet name="start">
                <apex:outputPanel >  <!-- Using a panel to make the facet work - only allows one child... -->
                    <apex:image url="{!$Resource.AjaxRoller}" alt="loading..."/>
                    <apex:outputText > ... Loading ... </apex:outputText>
                </apex:outputPanel>
            </apex:facet>
            <apex:facet name="stop">
                <apex:detail subject="{!$CurrentPage.parameters.cid}" relatedList="false" title="false" />
            </apex:facet>
        </apex:actionStatus>
    </apex:outputPanel>
           
           
            </td>
           
            </tr>
            </table>
           
        </apex:form>
    </apex:pageBlock>
   
   
</apex:page>

Hi,

I'm trying to develop a very simple trigger that essentially creates a contact and a few contact share records when a User record is created.  

In my dev environment the trigger and all of the unit tests work flawlessly, when I transfer to production the trigger doesn't even fire and as a result my unit tests fail. 

When I run the tests I get no indication that the Trigger even attempted to run, let alone some error to tell me why it might be failing.  Also, System.Debug within the Trigger doesn't show in my test output.

The trigger itself is below.  I can post the support class code if needed but it doesn't seem to be getting that far so I don't know if it will help.

Any help is greatly appreciated.

Thanks

Jon

{

// User Create ContactShareing Trigger

//get the user data and pass to the function in our support class

User[] theUsers = [select id,name,firstname,lastname,companyname, email, phone, defaultcurrencyisocode from User where id in :trigger.new];

//loop through all new users

{

User_Contact_Trigger_Class.User_Create_Trigger(newUser);

}

}

I'm trying to create a trigger on Asset, after Undelete.

I simply want to set a flag to denote that the record has been undeleted.

 I expect that I should be able to do something like the following, but I get an "Attempt to de-reference a null object" error on the for loop line.

{

    for(Asset undeletedAsset : trigger.old)

  {

     Asset theAsset = [select undeleted__c from Asset where id in :trigger.old];

     theAsset.undeleted__c = true;

     update theAsset;

  } 

}

Any help or pointers are greatly appreciated.

Thanks

Jon

private Opportunity[] GetUpdatedClosedOpportunities(SqlDateTime startTime, SqlDateTime endTime)
		{
			Opportunity[] thegoods = null;

			QueryResult qr = null;  //storage location for returned data
			binding.QueryOptionsValue = new sforce.QueryOptions();  //define the query specifications
			binding.QueryOptionsValue.batchSize = 450; //number of records to return.
			binding.QueryOptionsValue.batchSizeSpecified = true;  //specify that the above item is supplied

			string startTimeString = "2005-12-15T21:43:31.000Z";  //temporarily hard coded for testing
			string sqlStatement = "SELECT id, name FROM Opportunity WHERE isclosed = TRUE AND lastmodifieddate > " + startTimeString; 
			try 
			{
				qr = binding.query(sqlStatement);
				thegoods = (Opportunity[]) qr.records;   //Cast Invalid error here!!

				return thegoods;
			}
			catch (Exception ex)
			{
				Console.WriteLine ("Failed to get Opportunity: " + ex.Message);
			}
			return thegoods;
		}

Message Edited by JonSimmons on 01-05-2006 07:20 AM

Can anyone tell me what is wrong with this simple trigger?  I'm sure I'm just missing something stupid, I'm just not seeing it.  Maybe I'm just completely off track.  I just need to update a single field on the triggering lead upon Insert or Update.

Eclipse doesn't give me any real error message, it just says that and unexpected error occured and to try again.

My code 

******************

trigger Calculate_Lead_Qualification_Score on Lead (before insert, before update)
{

    for(Lead theLead : trigger.new)  //loop through each lead that is being inserted or updated
        {

       
            //SFDC doesn't like the line below.  No error, it just won't save if this line is included       
            theLead.Lead_Qualification_Score__c = theLead.Application_Suitability_Score__c + theLead.Budget_Score__c + theLead.Role_Score__c + theLead.Timing_For_Purchase_Score__c;
           
            system.debug('Calculated Lead Qualification Score: ' + theLead.Lead_Qualification_Score__c);
        }
   
}

thanks

Jon

I'm just starting to work with the API in PHP and I have run into something odd.

Given this simple query, my results contain everything except the Id of the returned record.

Am I missing something, the Id field is there, but it contains a '0', not the Id of the returned record as expected.

    $query = 'Select UnitPrice, Quantity, PricebookEntryId, OpportunityId, Id From OpportunityLineItem WHERE OpportunityId = \'' . $opportunityId . '\' AND PricebookEntryId = \'' . $salesTaxPricebookEntryId .'\'';
     

      $response = $mySforceConnection->query($query);
      $queryResult = new QueryResult($response);

QueryResult Object
(
    [queryLocator] =>
    [done] => 1
    [records] => Array
        (
            [0] => SObject Object
                (
                    [type] =>
                    [fields] => stdClass Object
                        (
                            [OpportunityId] => 006S0000002pi1YIAQ
                            [PricebookEntryId] => 01uS0000000xeDiIAI
                            [Quantity] => 1.0
                            [UnitPrice] => 47.5
                        )

                    [Id] => 0
                )

        )

    [size] => 1
)

The Outbound Message contains a SessionId and a ServerURL, Is it possible  to use this SessionId and ServerURL to access Salesforce and avoid login/authentication?

Thanks

Jon

The APEX Language Reference and Force.com Developers Guides (among others) state that the New collection can be written to in a Before Insert trigger.   Unfortunately when I try to do so, I get a 'Collection is read-only' error.   What gives?

 Sample code:

trigger ProductKits on OpportunityLineItem (before insert)
{

//test, just add an opportunitylineitem to trigger.new
            OpportunityLineItem bLineItem = new OpportunityLineItem();
                    bLineItem.quantity = 1;
                    bLineItem.UnitPrice = 100.00;
                    bLineItem.Opportunityid = '006S0000002pi1Y';
                    bLineItem.pricebookentryid = '01u80000003LOTJAA4';
            trigger.new.add(bLineItem);

}

Hi,

Scenario : I have custom object called SFDC_Project__c which has look up to cases through Case__c field.

When i create case and through same detail page through related list if i click New Project, i want to copy value of Trigger_Value field  from cases to project Cases_Trigger_Value__c after clicking save.

I have written trigger on project:

trigger SetPrimaryContact on SFDC_Project__c (before insert) 
{    
   
    for (SFDC_Project__c o : Trigger.new)  
    {   
       List<Case> contactRole = new List<Case>();
       contactRole = [select ID, Trigger_Value__c from Case where Id = :o.Case__r.id limit 1];    
       o.Cases_Trigger_Value__c = contactRole[0].Trigger_Value__c; 
        
       insert o;       
        
    }
}

  Once i save i get error :

 Error: Invalid Data. Review all error messages below to correct your data.
Apex trigger SetPrimaryContact caused an unexpected exception, contact your administrator: SetPrimaryContact: execution of BeforeInsert caused by: System.ListException: List index out of bounds: 0: Trigger.SetPrimaryContact: line 8, column 47

Any help will be appriciated .

Thanks & Regards,

Abhijit

I have a very simple web controller that I need to write test code for:

public class web_controller_testimonial_list {

public list<Testimonial__c> listResults = new list<Testimonial__c>();

public list<Testimonial__c> getTestimonials() {
listResults = [SELECT quote__c, contact_name__c, contact_title__c, account_name__c FROM Testimonial__c WHERE Status__c = 'Published' ORDER BY Quote_Date__c desc];
return listResults;
}

public list<Testimonial__c> fetchTestimonials() {
getTestimonials();
return null;
}

}

 And really, I suppose it could be scaled down to something a little more simple, for the sake of this post:

public class web_controller_testimonial_list {

public list<Testimonial__c> getTestimonials() {
listResults = [SELECT quote__c, contact_name__c, contact_title__c, account_name__c FROM Testimonial__c WHERE Status__c = 'Published' ORDER BY Quote_Date__c desc];
return listResults;
}

}

 ... actually, I don't even know where to start.  I've been learning as I go, and I'm stumped.  How would I write a test case for something like this?

Thank you,

~ Nick

What is the Best approach if we want to Calculate SUM of ChildRelationship records (through LookUp relationship) NOT Mast-Detail Relationship.

My scenerio is this:

Contact: Name, Balance

Bill:         Name, Amount, Contact__c (Lookup Field)

So I want to Fire a trigger on Bill such that whenever a Bill is updated I can Update Contact.Balance value with SUM of Amount for ALL Bills Where Contact__c = current_saving_bill.Contact__c.

Also I'm not able to work this approach with this case: Say If I change Contact__c value in bill so I now Want to Update Contact.Balance value for current edited bill's OLD Contact__c and NEW Contact__c value. :( can anyone help me devise a solution for this ...

code:

trigger LeadConvertoContact on Lead (after update) {
    for(Lead l :Trigger.new)
    {
        if(l.IsConverted==true)
        {
            List<UsageLog__c> uls=[select id,Contact__c,OwnerId from UsageLog__c where leadname__c=:l.Id and Contact__c=:''];
            for(UsageLog__c uc:uls)
            {
                uc.Contact__c=l.ConvertedContactId;       
                //uc.OwnerId=l.OwnerId;                   
            }

            //If I comment out this line of code  can be saved to the server    ....... why?           

           update uls;                 

        }
    }
}

THanks!

I have code in production that passes all unit tests and works fine in most cases but in some instances I am getting an Invalid Query Locator error and I can't figure out why.

My code is a custom rollup trigger that  triggers when a case is 'Closed'.  Rolling up data from cases to their parent accounts.

My code loops through trigger.new to collect the accountid associated with each case that has just closed.  It then loops through the list of accounts pulling and account record and any associated cases.  Finally it loops through the accounts, loops through each account's cases, and adds up all of the appropriate values depositing the result into fields within the Account then updates the account.  A simple rollup really.

This works fine most of the time but I have come across some accounts that fail this process, it doesn't matter which case is closed on the account, I always get the same error so the problem is with the account not with the case.  This account has roughly 340 closed cases, though I don't believe that is anywhere near any kind of limit.

To get to my point, I'm not sure what 'Invalid Query Locator' means in this particular case.  I have seen very little info about the Query Locator, all of it old, but it all suggests problems that occur when querys time out or have been 'garbage collected'.  In this case the error comes back immediately so timeout or memory cleanup should not be an issue.

Below is the relevant code, it's chopped to remove specific custom field names and such so it's pretty ugly.

Any help is greatly appreciated.

Many Thanks

Jon

//if the given trigger has just been closed then roll up the FQTD follup values

set<ID> FQTDAccountIDs = new set<ID>(); //list of Accounts involved with fqtd rollup calculations
map<ID, Account> AccountsToUpdate = new map<ID, Account>(); //the accounts that will be updated by this trigger


//prepare for FQTD rollup

Integer i = 0;
for(case theCase : trigger.new)//loop through all of the available records in the trigger
{
if((trigger.old[i].status != 'Closed') && (trigger.new[i].status == 'Closed'))
{
if(!FQTDAccountIDs.contains(trigger.new[i].accountid))
{
FQTDAccountIDs.add(trigger.new[i].accountid);
System.Debug('Adding Account to the FQTD List: ' + trigger.new[i].accountid);
}
}
i++;
}


//ok, so we may have a list of records to update, lets get to the action
if(FQTDAccountIDs.size() > 0) //do we have any records to update?
{

  //loop through all accounts and add them, with their cases, to a map for later looping

for(Account thisAccount : [Select Id, name, (Select casenumber, status From Cases where status = 'Closed') From Account where id in :FQTDAccountIDs])
{
AccountsToUpdate.put(thisAccount.id, thisAccount);
}


//loop through each specified account
for(Account currentAccount : AccountsToUpdate.values())
{




// ****** This next for loop is the apparent problem; System.Exception: invalid query locator ********

//loop through all cases associated with this account
for(Case theCase : currentAccount.Cases)
{

//calculate the fields and rollup the data
// currentAccount.rolledupfield += theCase.rollupfield1__c + theCase.rollupfield2__c
}



}


//update the Accounts with the new values
update AccountsToUpdate.values();



}