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
ChandChand 

Want to find out the count of number of attachments

 

Hi All,

 

My requirement is on a custom page to set a "attachment present" field to Yes if there is any attachment exists or to No  if no attachment exists .

 

in a way find the count of the attachments and set this filed value. Can i write a trigger on attachment object using force.IDE or is there any alternate way? Please suggest. The attachments will be uploaded using standard notes and attachment related list.

 

I can find some threads on the same but i want to cross check whether there is way to do this

 

Thanks in advance

Chand

bob_buzzardbob_buzzard

I've done this in the past by using a trigger on the attachment object.  When an attachment is created, I increment a counter field on the parent object, and when an attachment is deleted I decrement the count.  

 

If you are in a custom page that is backed by an object instance, you should be able to do this via SOQL.  

 

Integer numAtts=[select count() from attachment where parentid=:recId];

 where recId is the id of the record being managed by the page.
ChandChand

Thanks a lot