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.
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'