Apex Code Development You need to sign in to do that
Don't have an account?
Query by Product Family?
I wrote a trigger that adds schedule items to opportunity products when they're created, based on which product they are, how many are purchased, and for what duration. Our company has two different types of products right now: enterprise products and services. In my trigger, I need to handle the services differently than the enterprise products. They way I have been handling that is with an if statement that catches them by ID:
ID OnboardingPBE = [select id from PricebookEntry where product2.name='Onboarding' LIMIT 1].id;
ID TrainingPBE = [select id from PricebookEntry where product2.name='Training' LIMIT 1].id;
if(oli.PricebookEntryId == OnboardingPBE || oli.PricebookEntryId == TrainingPBE)
This logic is broken for some reason, and the above if statement never runs. Furthermore, it would be more efficient if I could figure out a way to just enter the if statement based on whether product family == 'services'...Is there a way I can do this?
If you need to see my whole trigger, I can upload it here.
Thanks
ID OnboardingPBE = [select id from PricebookEntry where product2.name='Onboarding' LIMIT 1].id;
ID TrainingPBE = [select id from PricebookEntry where product2.name='Training' LIMIT 1].id;
if(oli.PricebookEntryId == OnboardingPBE || oli.PricebookEntryId == TrainingPBE)
This logic is broken for some reason, and the above if statement never runs. Furthermore, it would be more efficient if I could figure out a way to just enter the if statement based on whether product family == 'services'...Is there a way I can do this?
If you need to see my whole trigger, I can upload it here.
Thanks
oli is an OpportunityLineItem
if(oli.Product2.Family == 'Services'){
do something
}