I want to search for all contacts that have an attachment. How do I do this? I have looked under custom and advance searches. as well as searched all help documents for an answer.


I figured out how to create a custom search using 'search builder' and it has an option to search for attachments in the drop down.

Issue resolved

| improve this answer | |
  • That is good to hear :-). Still, do you not think it is worth a issue in the official CiviCRM issue tracker on issues.civicrm.org? – ErikH - CiviCooP Jul 7 '15 at 14:59
  • I think so because it should be a fairly simple task in my opinion. When i was doing my research, i saw many others asking for the same thing – Karen Jul 7 '15 at 15:06
  • Can you add the issue @Danielle? – ErikH - CiviCooP Jul 7 '15 at 15:51

That is not possible in the user interface strangely enough as far as I know :-( You can have a look in the tables if you are familiar with the database? The attachment location will be in table civicrm_file, and the link to the activity will be in table civicrm_enity_file. So getting the activities with attachments will be something like:

SELECT * FROM civicrm_entity_file WHERE entity_table='civicrm_activity'
| improve this answer | |
  • I don't think I'm that familiar. haha It seems like it would be a very simple thing to search for contacts with attachments. I would love to try your theory but can you give me a bit more direction? – Karen Jul 7 '15 at 14:00
  • If you are not that familiar it is going to be hard, and I also reckon you would not have direct access to your database? Have you ever done anything with phpmyadmin or tools like that? – ErikH - CiviCooP Jul 7 '15 at 14:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.