Answers.Body: <p>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. </p>
  
  <p>Issue resolved</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-07T14:59:46.320Z
Answers.Text: That is good to hear :-). Still, do you not think it is worth a issue in the official CiviCRM issue tracker on http://issues.civicrm.org?
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-07T15:06:30.873Z
Answers.Text: 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
Answers.UserDisplayName: Karen
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-07T15:51:46.693Z
Answers.Text: Can you add the issue @Danielle?
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-07T14:07:44.507Z
Answers.LastActivityDate: 2015-07-07T14:07:44.507Z
Answers.UserDisplayName: Karen
Answers.Body: <p>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:</p>
  
  <pre><code>SELECT * FROM civicrm_entity_file WHERE entity_table='civicrm_activity'
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-07T14:00:47.290Z
Answers.Text: 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?
Answers.UserDisplayName: Karen
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-07T14:41:10.933Z
Answers.Text: 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?
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-07T13:50:17.297Z
Answers.LastActivityDate: 2015-07-07T13:50:17.297Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>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.</p>
  
Tags: <search>
Title: Search contacts with attachments
ThreadText: # Search contacts with attachments
  
  (Asked by: username_0 on 2015-07-07)
  
  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.
  
  **Tags:** search
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2015-07-07. Score: 4
  
  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
  
  > **Comments:**
  > **username_1**: That is good to hear :-). Still, do you not think it is worth a issue in the official CiviCRM issue tracker on http://issues.civicrm.org?  
  > **username_0**: 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  
  > **username_1**: Can you add the issue @Danielle?  
  
  ---
  
  ### Answer by username_1 on 2015-07-07. Score: 0
  
  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'
  
  ```
  
  > **Comments:**
  > **username_0**: 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?  
  > **username_1**: 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?  
  
  ---
  
  