function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
farah sheriffarah sherif 

I need help with a trigger

the trigger should be on account to check the assets and if ALL Assets where product family = "bla bla "  and their status was "Canceled" the trigger should update bla bla Account stage (API Name = Account_Status__c )  to "Cancel".
Best Answer chosen by farah sherif
Abdul KhatriAbdul Khatri
Can you try the below
  
trigger AccountUpdateFromAssetProduct on Asset (after insert, after update) {
    
    List<Asset> assetList = Trigger.new;

	List<Id> idAccountList = new List<Id>();    
    for(Asset asset : assetList) {
        
        if(Trigger.isUpdate && asset.Product2.Family == Trigger.oldMap.get(asset.Id).Product2.Family && asset.Status == Trigger.oldMap.get(asset.Id).Status) continue;
        
        if(asset.AccountId == null) continue;
        
        idAccountList.add(asset.AccountId);
    }
    
    if(idAccountList.isEmpty()) return;
    
    List<Account> acctList = [SELECT Id, (SELECT Id FROM Assets WHERE Product2.Family = 'bla bla' AND Status = 'Canceled') FROM Account LIMIT 50];
    
    for(Account acct : acctList)
    {
        if(acct.Assets.isEmpty()) continue;
        
        acct.Account_Status__c = 'Cancel';
    }

    update acctList;
}

 

All Answers

Abdul KhatriAbdul Khatri
Can you try the below
  
trigger AccountUpdateFromAssetProduct on Asset (after insert, after update) {
    
    List<Asset> assetList = Trigger.new;

	List<Id> idAccountList = new List<Id>();    
    for(Asset asset : assetList) {
        
        if(Trigger.isUpdate && asset.Product2.Family == Trigger.oldMap.get(asset.Id).Product2.Family && asset.Status == Trigger.oldMap.get(asset.Id).Status) continue;
        
        if(asset.AccountId == null) continue;
        
        idAccountList.add(asset.AccountId);
    }
    
    if(idAccountList.isEmpty()) return;
    
    List<Account> acctList = [SELECT Id, (SELECT Id FROM Assets WHERE Product2.Family = 'bla bla' AND Status = 'Canceled') FROM Account LIMIT 50];
    
    for(Account acct : acctList)
    {
        if(acct.Assets.isEmpty()) continue;
        
        acct.Account_Status__c = 'Cancel';
    }

    update acctList;
}

 
This was selected as the best answer
farah sheriffarah sherif
thank you so much but I have a question

what does this line of code do ?  
 List<Asset> assetList = Trigger.new;


and can I have your email for more questions?
Abdul KhatriAbdul Khatri
Thanks Please remove that LIMIT 50 in the SOQL.
farah sheriffarah sherif
 what does this line of code do ?

if(Trigger.isUpdate && asset.Product2.Family == Trigger.oldMap.get(asset.Id).Product2.Family && asset.Status == Trigger.oldMap.get(asset.Id).Status) continue;
Abdul KhatriAbdul Khatri
It is preventing running the trigger even if you make updates apart from those fields on asset. You goal is to make the trigger run only in the cases you want.
beetv appbeetv app
Then what should be the limit if i remove LIMIT 50 in the SOQL? any update on this?
Thank you in advance.
Developer at https://beetvapp.com/
minion rolsenminion rolsen
so and i want see a answer  for  this  questen, nice questen
Plague inc download  
sunny ahujasunny ahuja

Well, You have helped me buy posting this question and I want to thank you for this!

Plague inc download (https://love4apk.com/plague-inc-apk/)
John kevin 1John kevin 1
bigg boss voting (https://bigg-boss-vote.in) This the very first reality show of Sony entertainment television call Bigg Boss was hosted by Arshad Warsi. Bigg Boss was started on Sony entertainment television but now it is being streamed on Colors TV. You can say that Bigg Boss follows the Big Brother format, which watches first developed by Endemol in the Netherlands. bigg boss tamil vote (https://bigg-boss-vote.in/bigg-boss-tamil-vote)
Cash DavidsonCash Davidson
Thank you a lot for the solution! My details of dealing can be found here - apknature.com
Cash DavidsonCash Davidson
This also can be used in such games like plague inc on android (https://appmirror.net/games/strategy/plague-inc/) devices
Khakan KhanKhakan Khan
I have seen these informations and the method is really working.
Advanced pens with 3d technology (https://techypes.com/best-3d-pens/" target="_blank) helps in achieving best creativity
Khakan KhanKhakan Khan
We should also control the way Nursing Laptops (https://besticious.com/best-laptops-for-nursing-students/) are being effected.
bernard dalebernard dale
.I just wanted to thank you for this, its much helpful for my site, it helped me build my pokemon go spoofer pokemon go mod apk (https://gameorbiter.com/pokemon-go-mod-apk/)


 
Cash DavidsonCash Davidson
Just be sure to include this (http://www.supportduweb.com/profile-105033.html)person on your list!
Sujo MathewSujo Mathew
This is really helpful from abdul khatri. i was facing tha same problem as farah but found the answer at this discussion. For your info i was having problems at https://biggbosstvshow.com/bigg-boss-voting-hindi/
Martin Luther 10Martin Luther 10
I have downloaded Damon PS2 Pro APK (https://www.apkguru.net/damon-ps2-pro-apk/) and this was the actual thing for me that worked.
education wateducation wat
Just be sure to include this .then i'll give my review Rojgar Bazaar Portal Delhi Govt. Job (https://karnatakastateopenuniversity.in/delhi-rojgar-bazaar-portal.html) Portal via sources : https://karnatakastateopenuniversity.in/rrb-ntpc-admit-card.html
Martin Luther 10Martin Luther 10
Yes, This is one of the top notch things that are mentioned by coders above. Meanwhile I am also seeking for the same as per below.
User-added image
Queenie LuvQueenie Luv
The good news is that the masters live (https://themastersgolftv.com/) 2021 will be live on both CBS and ESPN. Therefore, if you prefer watching it on TV, you can set a due date for the stipulated dates of the tournament to watch it. Each round of the tournament will be aired on both CBS and ESPN https://themastersgolftv.com/
Neeraj Kumawat 22Neeraj Kumawat 22
Everything is very open http://www.baexamresult.in/ba-2nd-year-ka-result/ with a precise clarification of the issues.
Paintball NationPaintball Nation
It is a very informative post, however, it never easy to buy an idea Paintball Tanks (https://paintballgod.com/best-paintball-tank) but you can jump here to enjoy so best reviews
Emily JasonEmily Jason
Quick List of the Top 10 Hoverboards in the US. Best Hoverboard for the Money 2021: Hover-1 Hoverboard with Water Resistance and Bluetooth Best Hoverboards Under 300 (https://hoverboardes.com/best-hoverboard-under-300/). Read More: Visit: https://hoverboardes.com (https://hoverboardes.com/)
Emily JasonEmily Jason
The Brabantia Standard Sized Ironing Board is not only our best all-around choice but also one of Amazon's Choice products for the best Ironing Boards. Best steam Iron 2021 (https://sanoosh.online/best-steam-generator-iron-2021/" target="_blank) Read More at: http://sanoosh.online/
Emily JasonEmily Jason
KineMaster Pro Mod APK (v4.16.5) Download 2021. Download Kinemaster Mod Apk Latest Version 2021 (Full Unlocked + No Watermark). It is very easy and simple to use. https://thekinemaster.com/
Bob Michael 8Bob Michael 8
Thank you for the update, I tried using the one that has this LIMIT 50 in the SOQL but didn't go well.

 tubi tv activate (https://www.techbmc.com/tubi-tv-activate-free-shows-movies/)
Utpal Konwar 9Utpal Konwar 9
I really enjoyed reading the post you shared. I hope you will get to read such an article in future also.
https://www.assamsakori.org
Cecelia S LiraCecelia S Lira
Free Fire Max 50000 Diamond Hack https://flizzyy.com/free-fire-max-50000-diamond-hack/
sophia carlbergsophia carlberg
(API Name = Account_Status__c )  to "Cancel".

https://apkgameapps.com/action/gta-5-for-android
Alberto DelrioAlberto Delrio
Is there any sports API to live stream champions league online (http://uclfootballmag.com)?
Jenni QueenJenni Queen
I think this may not work everytimes, however you can visit (https://ausopenschedule.com/) for more information!