CiviCRM Community Forums (archive)

I made a custom data as a file type & uploaded images in it only.
Then I was trying to make a view from view type "Civicrm_event" in which after selecting fields as "civicrm_custom_upload" [or custom data field name] I was able to fetch only the uploaded file id not the file itself.
Like how can I access that "uri" field from civicrm_file table into that view?

SELECT civicrm_event.id AS id, civicrm_event.title AS civicrm_event_title, civicrm_value_image_upload_4.image_7 AS civicrm_value_image_upload_4_image_7 FROM civicrm_event civicrm_event  LEFT JOIN civicrm_value_image_upload_4 civicrm_value_image_upload_4 ON civicrm_event.id = civicrm_value_image_upload_4.entity_id

Currently this query is being run which fetch uploaded file id mapped with drupal event id . I like to show file in place of that file id then I have to fetch "uri" field from civicrm_file according to particular "event_id", then how can I do this ?
Hope I am clear enough!
Thanks!

But handler must have some query to achieve the existing thing & I am little confused about the relation between uri & the event id as what will be the sql query if you can help  or something?

You can customize your View templates and run your SQL that way. This tool also http://drupal.org/project/views_modify_query might help but it's not yet stable.

Quick solution to display the images uploaded by CiviCRM custom data in views, is to rewrite the output of the field with

Code: [Select]

<img src="<drupalpath>/civicrm/file?reset=1&id=[Field ID]&eid=[Entity ID]" />
Please see the attachment.

But definitely we need to modify the file field hander for views to display uploaded file.

Rajan

You must have modified too that handler on your installation to show images, id filed & respective uploaded data, if you can tell the code of that, then it would ease the work :-) [As I was not able to modify it properly.]
Thanks

yeah I got image working but a questions arises, how am I gonna give some default image. e.g . If some user didn't upload any image in the field then there should come some default image in place of image that is being fetched & wasn't found because user didn't upload it, then how can I do that? Using Drupal views arguments ? I tried a bit but wasn't successful .
If anyone can help regarding this too?