I'm writing a trigger in which I need to test if a record already exists in sf before I can proceed.

currently I am using this method:

if([select count() from account where id = :trigger.new[i].ParentId] > 0) {}

however this is not very governer limit friendly.  In the past I've tried using the isNull method wrapped around a try{ } catch  but that returned a null pointer exception (or whatever the equiv. is called in sf, I forget at the moment.

i have tried to use

if([select count() from account where id in :accIds] > 0){}

but as I understand, this statement works like this:  it will return as many  account records as there are  matching acound id's in thet set.  I just want to know if ONE particular account is in the set.

I hope that was clear.  If you  need any further explanation from me just let me know and I'll do my best to provide!

Hi

My requirement is as follows

I have a master detail relationship between 2 objects. For 1 master record there can be multiple detail record. I need to find the highest detail record for a particular master record. If there are 3/4 detail for 1 master I need to find out the highest detail record.

The detail record has a field a auto number field which is listed under the standard fields.  How would I extract the highest auto number that was inserted (in a detail record) for a master record

Also the apex explorer does not list the auto number field . how would I view it?

Thanks much for all your time 

All,

I have had a request from a user, and I am struggling with how to accomodate it. 

My user works with Leads, and is frustrated that the address information input for the Leads is not transferred to the new Contact created when the Lead is converted.  I have looked into the standard functionality, and have found that this information is instead transferred to the Account which is created.  I can create a new set of custom fields for both the Lead and Contact records to transfer this information, but I don't feel this adequately meets my users' needs.

Instead, I am trying to determine if I can update the Contact information as it is being created by the 'Convert Lead' process, using an APEX trigger.  Unfortunately, I can find little information about how triggers relate to the 'Convert Lead' process.  I have looked at the discussion boards, blogs, and developer's guide, but cannot seem to find the information I need. 

I am aware that I may need to request that the 'Enforce Validation and Triggers from Lead Convert' functionality be enabled in my org, and that this will allow me to use the 'before create' trigger setting to create a trigger on the Contact object which will allow me to update the fields in the Contact record before it is saved.  However, how do I access the original Lead in the trigger to allow me to grab the address information stored in the Lead?

Any help would be greatly appreciated.

I downloaded the Quote Sale Line app from app excahnge written by salesforce.com. I have two scenarios:

• where if the user is not the admin and sales_discount is more then 30% then they can not edit the sales discount.
• Now if the reseller is on the reseller table and the discount follows through but if it is more then 30% that above rule applies and does not insert the record from the code below and it comes up with an error.

Here is the code I modified but do not know how to place in the correct parameters for a validation or a new trigger rule:

// copy lines from the oppportunity to this quote public void copyLineItemsFromOpptyToQuote() { // delete any existing quote lines OpportunityLineItem[] olist; olist = [Select Id, OpportunityId, SortOrder, PricebookEntryId, Quantity, TotalPrice, UnitPrice, ListPrice, ServiceDate, Description, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, IsDeleted , PricebookEntry.Name, PricebookEntry.Product2id From OpportunityLineItem where OpportunityId = :quote.Opportunity__c ]; // create new quote lines SFDC_520_QuoteLine__c[] qlines = new list<SFDC_520_QuoteLine__c>(); for ( OpportunityLineItem oitem : olist) { Reseller__c[] r =[Select Name, License__c from Reseller__c where Name=:quote.Partner_Direct__c]; if(r.isEmpty()){ SFDC_520_QuoteLine__c ql = new SFDC_520_QuoteLine__c( Quote__c = quote.id, Sales_Discount__c = 0.0, Qty_Ordered__c = oitem.Quantity, Unit_Price__c = oitem.UnitPrice, Description__c = oitem.Description, ServiceDate__c = oitem.ServiceDate, Product2__c = oitem.PricebookEntry.Product2id ); qlines.add(ql); } if(!r.isEmpty()){ SFDC_520_QuoteLine__c ql = new SFDC_520_QuoteLine__c( Quote__c = quote.id, Sales_Discount__c =r[0].License__c, Qty_Ordered__c = oitem.Quantity, Unit_Price__c = oitem.UnitPrice, Description__c = oitem.Description, ServiceDate__c = oitem.ServiceDate, Product2__c = oitem.PricebookEntry.Product2id ); qlines.add(ql); } } delete quote.Quote_Lines__r; if ( qlines.size() > 0 ) { insert qlines; } }

 Any help would be truly appreciated....

Thanks

The page will not be loaded from a link/button on the User page, so I cant add a User Id parameter to the link/button, i.e.

/apex/myPage?id={!User.id} where t.User__r.id = :ApexPages.currentPage().getParameters().get('Id')

I would like to be able to place the link anywhere but have the page only display the record for the current user viewing the page.

My Class:

public class tobExtension { private final Time_Off_Info__c tob; public tobExtension(ApexPages.StandardController stdController) { this.tob = (Time_Off_Info__c)stdController.getRecord(); } List<Time_Off_Info__c> tobRecords; public List<Time_Off_Info__c> getTobRecords() { if( tobrecords == null) tobrecords = [Select t.User__c, t.Total_Time_Off_Available_Hours__c, t.Total_Pending_PTO_Requests__c, t.Total_PTO_Hours_Accrued_2__c, t.Total_PTO_Available__c, t.Total_PTO_Accrued__c, t.Pending_PTO_Balance_Hours__c, t.Payroll_System__c, t.PTO_Balance_Hours__c, t.PTO_Balance_Days__c, t.PTO_Available_current_as_of__c, t.Name, t.Id, t.Employee_Number__c From Time_Off_Info__c t where t.User__r.id = '$User.id']; return tobrecords; } }

My Page:

<apex:page standardcontroller="Time_Off_Info__c" extensions="tobExtension"> <apex:sectionHeader title="My Time Off Balance"/> <apex:pageBlock title="Current User: {!$User.Username}"> <apex:pageBlockTable value="{!tobrecords}" var="tob"> <apex:column value="{!tob.Employee_Number__c}" /> <apex:column value="{!tob.User__c}"/> <apex:column value="{!tob.Total_PTO_Accrued__c}"/> <apex:column value="{!tob.PTO_Available_current_as_of__c}"/> <apex:column value="{!tob.Total_Pending_PTO_Requests__c}"/> <apex:column value="{!tob.Total_PTO_Available__c}"/> </apex:pageBlockTable> </apex:pageBlock> </apex:page>

Hi all,

I call an external web service and I would like to write the answer into an account's field.

By now I'm able to do the callout and I get the response and to edit account's field I use a query. But I'm forced to use a particular name of the account.

The cose is the following:

String r = np.GetPrimeNumbers(8);

               String varName = 'Test triggerB';         

               Account[] la = [select Name, Phone, Fax, Account_Credit_Check__c from Account where name = :varName];

I'm forced to use Test triggerB as account name. How can I call the field account name, instead of its value?

Hi all I have the following code:

How do I move it to next record when the SFD_WEEK_No__c changes...

Basically I have two recordsets of data performing the same thing twice.. but I needed to get totals by week..

This kind of works but it does not sum up the records if the week no is the same.. it just keeps it the same as the first record...

for(SFDCFEDFLE__c o:[Select SFD_WEEK_NO__c,SFD_MOFR_NET_AVG__c,True_Draw_MOFR__c,amount__c from SFDCFEDFLE__c where User__c ='00550000000mLBs']) { if(o.SFD_WEEK_NO__c != a.SFD_WEEK_NO__c) total.SFD_MOFR_NET_AVG__c+= o.SFD_MOFR_NET_AVG__c; tot.amount__c += o.True_Draw_MOFR__c;

 Hi,

  Please help me to resolve the query error. :smileysad:

 String purgeType = String.valueOf(bs.Purging_Type__c);
            if(bs.Purging_Type__c == 'LAST_N_DAYS') {
                 Integer nDays = Integer.valueOf(bs.Last_n_days__c);
            }
     if (purgeType == 'LAST_N_DAYS') {
                 List<ConnectCompiere_Log__c> lastNDays = new List<ConnectCompiere_Log__c>([SELECT Id FROM ConnectCompiere_Log__c WHERE CreatedDate = LAST_N_DAYS : nDays]);
                 for(ConnectCompiere_Log__c rec:lastNDays) {
                      delete rec;
                 }

I am getting Error: Compile Error: expecting a number, found 'nDays' at above marked line.

How i can use custom varaiable(like nDays) instaed of using some number in place of nDays. Values for nDay, I will be getting from front end as Integer values.

Please help me. 

Thnks in advance.

I have a picklist field called "Operational Status" on my Account Object.  When "Operational" is picked from the picklist I want to require that an associated custom object called "Entity Account" is in place before the user can save.

The Entity Account object has a master-detail relationship with the Account object. 

So if I have account ABC and I want to change its Operational Status to "Operational" I first need to create an Entity Account where account ABC is its master. 

I am attempting to write a trigger to make an error pop-up if an account entity associated to the account is not created first. If an entity account is already exising then all is good.

I just cant figure out how to check if an Entity Account object is already created for the account or not.  Is there a way to relate two objects like this and how would I go about doing it?

Thanks in advance!

global without sharing class TicketPortal
{
    Id AccountId;
    // Assume in this sample code that AccountId has been populated

    a = [SELECT
                   Id, Name,             
                   (SELECT 
                       Id, CaseNumber, Subject, Status, RecordType.Name, CreatedDate, IsClosed, OwnerId, Owner.Name, Owner.Email, Owner.Phone, Contact.Name 
                    FROM Cases
                    WHERE 
                        RecordType.Name in ('Issue Record Type','Premium Plus Record Type')
                        AND ( ContactId != null OR SuppliedEmail != null )
                        AND Origin in ('Phone','Email','Customer Portal')
                        
                    ORDER BY CreatedDate DESC
                   )
     
                 FROM Account
                 WHERE Id = :AccountId ];                           
        }
}

A follow up to more questions regarding the Guest User.

We have a customer portal that allows customers to manage their licenses via Sites ( an iframe in our product that passes very specific parameters to our Site VisualForce page that allows us to determine the customer we are dealing with ) so that customers can manage their licenses to our product ( adding or renewing ).

When a customer has made a purchase to add/renew, one of the things that happens is that an Opportunity is created from it. This doesn't cause any problems since we can grant permission to Guest Users to create specific objects under the Guest User Profile.

However, in addition to creating an Opportunity, it initiates an Opportunity trigger (BEFORE INSERT) that tries to:

• Update the End Date (custom field) of an Opportunity, based on the Contract that it is associated to, and recalculate prorated months (custom field) on the Opportunity
• Update the Contract Months (custom field) of the related Opportunity Line Items.

Understanding that Salesforce is going to soon be enforcing Guest User Record Access to be limited to Create and Read-Only, I am assuming that Salesforce will not allow the Guest User to perform these kinds of updates.

What would be the best practice to allow the Guest User to perform these actions?

The development best practices state:
https://www.learncommunitycloud.com/s/news/guest-user-record-access-development-best-practices-20Y1U000000UkITUA0

which suggests that the update action should be moved into a "without sharing" class.

But considering that this is a trigger, the updates to the fields happen prior to the insertion (is that a problem for the Opportunity since it hasn't been technically inserted yet),

But the trigger does have to query the Opportunity Line Items and perform updates on those, and I suppose that based on best practices, I would now have to move that functionality into a "without sharing" class?

@IsTest(SeeAllData=true)
static testMethod void PortalTest()
{
    Account a = new Account( Name = 'test', BillingCountry = 'United States', Type = 'Prospect', CurrencyISOCode = 'USD' );

    insert a;

    User PortalGuest = [SELECT Id FROM User WHERE Name = 'Portal Site Guest User'][0];

    System.RunAs( PortalGuest )
    {
        List< Account> accList = [SELECT Id FROM Account WHERE Id = :a.Id];
        System.assert( accList.size() == 1, 'Unable to retrieve created record; accList.size() = ' + accList.size() );
    }
}

The System.Assert flags and indicates that the accList.size() = 0.

I have set up Account Sharing Rules for "Portal Site Guest User" to include Account Type = 'Prospect'.

Not sure if I'm missing anything else to be able to access the record from the Guest User. Help?

<aura:component                 implements="force:lightningQuickActionWithoutHeader,force:appHostable,flexipage:availableForAllPageTypes,flexipage:availableForRecordHome,force:hasRecordId,forceCommunity:availableForAllPageTypes" 
				access="global" >
	
    <!-- Include Static Resources - if any -->
    <aura:handler name="init" value="{!this}" action="{!c.doInit}" />

</aura:component>

doInit: function( cmp, event, helper )
{
  // Obtain Parameters for URL
  var OpportunityId = cmp.get("v.recordId");
  var CustomerId = [??]; // Used to be {!Account.CustomerID__c}
  var API_Session_ID = [??]; // Used to be {!API.Session_ID}
  var API_Partner_Server_URL = [??]; // Used to be {!API_Partner_Server_URL_70}
  var User_Company_Id = [??]; // Used to be {!User.Company_Id__c}

  // Navigate to URL
  var urlEvent = $A.get("e.force:navigateToURL");
  urlEvent.setParams({
      "url": 'https://www.[website].com/action?" + [Parameters=Values List above]
   });

  // Confirm prior to navigation
  if ( confirm ("You are about to initiate a transaction on [website], please ensure you examine all necessary fields as per documentation" ))
  {
    urlEvent.fire();
  }
  
}

Is it possible to do any reflective calls on custom classes?

I have something like

public class CustomTaskObject { public Boolean isSelected {get;set;} public String Id {get;set;} public String Subject {get;set;} public String AccountName {get;set;} public WhatName {get;set;} public WhatStatus {get;set} public Double Timezone {get;set} ... }

Basically I populate a list of this CustomTaskObject, and do a very special sort done by Timezone (10 hours ahead of the current user's Timezone, desc), and then by "WhatStatus" priority (which is all done in code as there is no way to do this in SOQL) and throw it into a VisualForce pageBlockTable.

Users want to have the functionality to sort by other columns, such as AccountName, or WhatStatus, and I would like to have a way to make it so that I can call

object.getField('WhatStatus')

to simplify the sorting routine. Otherwise I would have to write a sort procedure to handle each field that is available for sorting.

Is reflection possible?

I have seen in other threads where people are dealing with sObjects which do have reflection, but I'm guessing that this is not possible with custom classes?

Thanks!

Hi everyone,

Does anyone know how to create slightly more complex headers using VisualForce and dataTables and columns?.

I'm trying to create a table that looks something like this:

Table Caption
Header Grouping 1			Header Grouping 2
Header 1-a	Header 1-b	Header 1-c	Header 2-a	Header 2-b	Header 2-c
data	data	data	data	data	data
data	data	data	data	data	data
data	data	data	data	data	data

Sorry it seems like in the preview that it cannot generate any lines on the table. I tried to increase the spacing so that people can see the general idea that I want.

I've been working on a pretty large project in which there were a lot of changes done in Salesforce, such as, new custom objects and fields, validation rules, apex classes and triggers, buttons and custom links, page layours, etc.

Some of these changes were made directly into my Sandbox account, such as new custom objects/fields/validation rules/buttons/custom links/page layouts, etc, while all apex related stuff was done in Eclipse.

When I first started the project, I started with an empty package, so now only my apex code exists in it. I want to know if there is any documentation on how to add other components to the package? I'm using version 3.3.2, so I don't have the GUI that I've read about in some of the other threads to manage my package, and so far I've been manipulating the package.xml to add the other components by creating different types such as CustomField and CustomObject and adding the appropriate members required for our production instance. Can someone point to me where I can get information on how to add other components such as page layouts, validation rules, buttons, custom links, etc?

Hi everyone,

I have a button on a custom object that runs the following javascript

{!REQUIRESCRIPT("/soap/ajax/14.0/connection.js")} {!REQUIRESCRIPT("/soap/ajax/14.0/apex.js")} try { document.getElementById("errorDiv_ep").style.display = "none"; document.getElementById("errorDiv_ep").style.textAlign = "center"; var id = sforce.apex.execute( "InvoiceWebService","CreateInvoiceFromProductUsagePlan",{ProductUsagePlanId:"{!ASP_Product_Usage_Plan__c.Id}" } ); window.location = "/" + id; } catch (e) { document.getElementById("errorDiv_ep").style.display = ""; document.getElementById("errorDiv_ep").innerHTML = "<table style='text-Align:left'><tr><td><font color=red>" + e.faultstring.replace(/\n/g,"<br />").replace( /:/g, ":<br />" ) + "</font></td></tr></table>"; }

Essentially what it is doing is calling an APEX class/method, and checking to see if the call is going to return an error via try/catch.

In my try/catch statement, I take the error returned and display it in the errorDiv_ep element that is standard on each Salesforce page.

I know this isn't the most elegant solution for displaying errors on screen, but I'm wondering if there is a better method (without the use of VisualForce). Is it also possible to return confirmation messages rather than error messages as well?

1. The original record loads from the database or initializes for an insert operation
2. The new values load from the incoming request and overwrite the old values in the record buffer. The old values are saved in the old context variable for update triggers.
3. Before triggers run.
...
5. The record is saved to the database, but the record is not committed.
6. After triggers run.
...
8. Workflow rules execute. If field updates are specified, the record updates again, and before and after triggers for the update fire.
...
10. All data manipulation operations are committed to the database.

I believe step 8 is causing my trigger to fire again. Is there anyway to prevent triggers from doing a repeat action if step 8 causes your trigger to fire again?

Here is my apex trigger code:

trigger LeadStatusHistoryTrigger on Lead (before update) 
{
 // Declare a list of Lead_Status_History__c to be insertedin Salesforce
 List<Lead_Status_History__c> LeadStatusHistoryObjects = new List<Lead_Status_History__c>();
 
 // If the trigger is an update trigger insert all the new status changes
 if ( Trigger.isUpdate )
 {
  for ( Lead l_new: Trigger.new )
  {
    // Check to see if the status of the old and new lead values are the same.
    // If they are different then we create a new entry in the lead_status_history custom object
    if ( l_new.Status != Trigger.oldMap.get( l_new.Id ).Status )
    {
     LeadStatusHistoryObjects.add( new Lead_Status_History__c ( Lead__c = l_new.Id, Lead_Status_New__c = l_new.Status, Lead_Status_Old__c = Trigger.oldMap.get( l_new.Id ).Status ) ); 
    }
  }
  
  // After all the new Lead Status History items have been added, now insert them into Salesforce
  try
  {
   insert LeadStatusHistoryObjects;
  }
  catch (DmlException de)
  {
   for ( integer i = 0; i < de.getNumDml(); i++ )
   {
    System.debug('LeadStatusHistoryTrigger Error Inserting Lead Status History Objects: ' + de.getDmlMessage(i));
   } 
  }
  
 }
}

• when the lead is updated (if the lead status has changed, then add a new entry to Lead_Status_History__c, I do not care about recording the initial insert)
• when the lead is deleted (all associated Lead_Status_History__c objects related to the Lead are to be deleted)

The only other situation I do not know how to handle is when a Lead is being merged.

if ( Trigger.isDelete )
{
 // Trigger.old returns an array/list of old values (only available during deleting) 
 // Need to delete all instances of Lead Status History pertaining to this lead
 // If this is a merge statement, how do you determine which leads are being merged?
 List<Lead_Status_History__c> LeadStatusHistoryDelete = [Select Id From Lead_Status_History__c Where Lead__c in :Trigger.oldMap.keySet()];
 
 // Go throught each Lead_Status_History__c 
 for( Lead_Status_History__c LeadStatusHistoryObject: LeadStatusHistoryDelete )
 {
  // Compare to each Lead Object?
  for ( Lead LeadObject: Trigger.old )
  {
   // How to determine which leads are being merged??
   // Determine which leads are being merged then update the Lead_Status_History__c object with the Trigger.old.MasterRecordLeadId
   // Unsure about the condition statement or how to write it???
   if ( LeadStatusHistoryObject.Lead__c == LeadObject.Id && LeadObject.Id != LeadObject.MasterRecordId )
   {

    // Update the Lead_Status_History__c record to point to the new master Lead





   }
   else
   {
    // Delete the lead
   }
  }
 } 
}

Does anyone have any APEX experience handling merges with triggers?

Please help!
 

@IsTest(SeeAllData=true)
static testMethod void PortalTest()
{
    Account a = new Account( Name = 'test', BillingCountry = 'United States', Type = 'Prospect', CurrencyISOCode = 'USD' );

    insert a;

    User PortalGuest = [SELECT Id FROM User WHERE Name = 'Portal Site Guest User'][0];

    System.RunAs( PortalGuest )
    {
        List< Account> accList = [SELECT Id FROM Account WHERE Id = :a.Id];
        System.assert( accList.size() == 1, 'Unable to retrieve created record; accList.size() = ' + accList.size() );
    }
}

The System.Assert flags and indicates that the accList.size() = 0.

I have set up Account Sharing Rules for "Portal Site Guest User" to include Account Type = 'Prospect'.

Not sure if I'm missing anything else to be able to access the record from the Guest User. Help?

<aura:component                 implements="force:lightningQuickActionWithoutHeader,force:appHostable,flexipage:availableForAllPageTypes,flexipage:availableForRecordHome,force:hasRecordId,forceCommunity:availableForAllPageTypes" 
				access="global" >
	
    <!-- Include Static Resources - if any -->
    <aura:handler name="init" value="{!this}" action="{!c.doInit}" />

</aura:component>

doInit: function( cmp, event, helper )
{
  // Obtain Parameters for URL
  var OpportunityId = cmp.get("v.recordId");
  var CustomerId = [??]; // Used to be {!Account.CustomerID__c}
  var API_Session_ID = [??]; // Used to be {!API.Session_ID}
  var API_Partner_Server_URL = [??]; // Used to be {!API_Partner_Server_URL_70}
  var User_Company_Id = [??]; // Used to be {!User.Company_Id__c}

  // Navigate to URL
  var urlEvent = $A.get("e.force:navigateToURL");
  urlEvent.setParams({
      "url": 'https://www.[website].com/action?" + [Parameters=Values List above]
   });

  // Confirm prior to navigation
  if ( confirm ("You are about to initiate a transaction on [website], please ensure you examine all necessary fields as per documentation" ))
  {
    urlEvent.fire();
  }
  
}

This may not be the appropriate place to ask this question but I don't know if there is a discussion board about the force.com IDE. The problem I'm having is that the force.com IDE I just downloaded and installed is missing the Run Tests option. The docs I find about running tests all say to right click on a test class and then go to Force.com > Run Tests. Unfortunately the Run Tests option is missing.

Does have any suggestions for fixing this problem?

Thank you

Hi all,

Major problem.  We have overridden the opportunity new, view and edit controls and visualforced all opportunity view and edit pages.  In the visualforce I have added the [change] link next to the Record Type on the view page.

When I click the change link next to the record type and choose a type from the drop down then click continue, it takes me back to the view page (which I would expect) but the record type has not changed:

Also on another page I'm just using the detail tag (thereby not writing the [change] link manually) and it still doesnt work.  Seems to me the problem is caused because the Edit  function is overwritten with a visualforce page.  The record type change page is managed by a jsp page but it would seem the owner isnt actually changed here and somehow it is passed somewhere else once the Continue button is clicked but because we have overridden view and edit, whatever process that would normally handle the record type change is now no longer being called.

Seems strange that salesforce would give me the option to override these pages when it clearly leads to a problem of this kind, can anyone offer a suggsetion?

Thanks

Steven

Hi everyone,

Does anyone know how to create slightly more complex headers using VisualForce and dataTables and columns?.

I'm trying to create a table that looks something like this:

Table Caption
Header Grouping 1			Header Grouping 2
Header 1-a	Header 1-b	Header 1-c	Header 2-a	Header 2-b	Header 2-c
data	data	data	data	data	data
data	data	data	data	data	data
data	data	data	data	data	data

Sorry it seems like in the preview that it cannot generate any lines on the table. I tried to increase the spacing so that people can see the general idea that I want.

I'm trying to test a trigger that sets a value in a custom field on the OpportunityLineItem object after it's inserted based on details in the OpportunityLineItemSchedule records added. The trigger's working fine, but for some reason, my unit test isn't.

The unit test code is below, but it's failing on the second assertion (at the very bottom). "Contract_duration__c" is set by the trigger to "schedule.size()" where schedule is:

List<OpportunityLineItemSchedule> schedule = [select ScheduleDate from OpportunityLineItemSchedule where OpportunityLineItemId = :LI.Id];

I expect that the number of OpportunityLineItemSchedule records will be 12 because that's what I've defined on the instantiated Product2 object (NumberofRevenueInstallments=12). But it's actually coming out with zero records. I'm sure the problem is with my assumptions -- any help?

Test Method

static testMethod void testScheduledProduct() {
Account account = new Account(name='Unit Test Account',BillingState='CA');
insert account;

Opportunity opportunity = new Opportunity(
AccountId=account.Id,
name='Unit Test Opportunity',
CloseDate=date.today(),
StageName='Decision Maker Interested'
);
insert opportunity;

Product2 product = new Product2(
Name='Unit Test Product',
isActive=true,
CanUseRevenueSchedule=true,
// default scheduling settings
RevenueScheduleType='Repeat',
NumberofRevenueInstallments=12,
RevenueInstallmentPeriod='Monthly'
);
insert product;

Pricebook2 pricebook = [SELECT Id, Name FROM Pricebook2 WHERE isStandard=true AND isDeleted=false AND isActive=true];

PricebookEntry pbentry = new PricebookEntry(
Pricebook2Id=pricebook.Id,
Product2Id=product.Id,
isActive=true,
UnitPrice=0,
UseStandardPrice=false
);
insert pbentry;

OpportunityLineItem opp_product = new OpportunityLineItem(
OpportunityId=opportunity.Id,
PriceBookEntryId=pbentry.Id,
Quantity=1,
UnitPrice=200
);
insert opp_product;

// Setup complete
// Test that the Monthly amount and Contract duration were set correctly
opp_product = [SELECT Monthly_amount__c, Contract_duration__c FROM OpportunityLineItem WHERE Id = :opp_product.Id];

System.assert(opp_product.Monthly_amount__c==200);
System.assert(opp_product.Contract_duration__c==12);
}

trigger setMonthlyAmountAndDuration on OpportunityLineItem (after insert, after update) {
if(!SetMonthlyAmountHelper.hasAlreadySetMonthlyAmount()) {
for (OpportunityLineItem LI : trigger.new) {
PricebookEntry pbentry = [select Product2Id from PricebookEntry where Id = :LI.PriceBookEntryId];
Product2 prod = [select CanUseRevenueSchedule, NumberOfRevenueInstallments from Product2 where Id = :pbentry.Product2Id];

if (prod.CanUseRevenueSchedule==true && prod.NumberofRevenueInstallments>0) {
OpportunityLineItem opp_prod = [select Monthly_amount__c, Contract_duration__c from OpportunityLineItem where Id = :LI.Id];
List<OpportunityLineItemSchedule> schedule = [select ScheduleDate from OpportunityLineItemSchedule where OpportunityLineItemId = :LI.Id];

if (schedule.size()==0)
opp_prod.Monthly_amount__c = LI.UnitPrice;
else
opp_prod.Monthly_amount__c = LI.UnitPrice / schedule.size();

opp_prod.Contract_duration__c = schedule.size();

SetMonthlyAmountHelper.setAlreadySetMonthlyAmount();
Update opp_prod;
}
}
}
}

Hello All,

I'm receiving a compile error -

(Error: Compile Error: Initial term of field expression must be a concrete SObject: LIST:SOBJECT:Lead at line 21 column 29)

for the following trigger code which I found in the salesforce wiki.  I'm unsure what is wrong with the "Initial term", can anyone help with this?

/* * Simple round robbin lead assignment, * trigger assumes the following custom fields on the User object * User. * Receiving_Leads__c -- are they open for new leads at this time * Open_Leads_Owned__c -- how many leads do they have right now * * if no matching new owner is found the default for the org is the new owner */ trigger triggerLeadRoundRobin on Lead ( before insert , after insert, after update , after delete) { if (Trigger.isBefore && Trigger.isInsert) { // find the user who can accept leads and which has the fewest at the moment Double least = 99999; // start with large number, find which user has least for ( User u : [select id,lastname,Open_Leads_Owned__c from User where isActive = true and Receiving_Leads__c = true]) { if ( u.Open_Leads_Owned__c == null || u.Open_Leads_Owned__c < least) { Trigger.new.ownerid = u.id; // this user will own the new lead least = u.Open_Leads_Owned__c; // changes owner before record is inserted } } } /* remaining code will keep the (summary field) Open_Leads_Owned__c * uptodate on each user record adjusts the value on insert, delete and transfer */ if (Trigger.isAfter) { if (Trigger.isInsert) { System.assert(Trigger.old == null,' old data row cannot exist at insert?'); System.assert(Trigger.new != null,' expected new object row in isInsert'); leadOwnerRelation.updateOpenLeadCount( Trigger.new.ownerid ); // call to a package } else if (Trigger.isUpdate ) { // as in change owner // here we have to recalc both the old owner and new owner System.assert(Trigger.old != null,' old data row must exist at update'); System.assert(Trigger.new != null,' what, no new in Trigger data in update'); if (Trigger.old.ownerid != Trigger.new.ownerid ) { // update includes a transfer owner leadOwnerRelation.updateOpenLeadCount( Trigger.old.ownerid ); leadOwnerRelation.updateOpenLeadCount( Trigger.new.ownerid ); } } else if (Trigger.isDelete) { System.assert(Trigger.old != null,' old data row must exist at delete time'); System.assert(Trigger.new == null,' cant have new object in isDelete'); leadOwnerRelation.updateOpenLeadCount( Trigger.old.ownerid ); } } } // end of trigger

Hi,

I will have to write the Apex class for associating master object with the chile object. How I can achieve this scenario.

Please help me........

Thanks in advance.

 :smileymad: :smileymad:

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);

}

}