How to get Date of file uploaded in view ?

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
tejaspmehta's picture

Hello All,

I have used content_profile module and based on that i have created view which display username and related fields. Now in this there is one field of files. User can upload unlimited number of files. I wanted to know what settings i should do to get date of posted file. I tried -delta option but there is nothing possible it just duplicate records.

After that i found in database that there are few tables which may help.
1. content_field_profile_files
2. files

but problem is query of generated view just list me only list of users and their id. Here is query which is generated by view

SELECT users.name AS users_name,
users.uid AS users_uid,
node.type AS node_type,
node.nid AS nid,
node.vid AS node_vid
FROM node node
INNER JOIN users users ON node.uid = users.uid
WHERE (node.status = 1) AND (node.type in ('profile'))
   ORDER BY users_name ASC

In this view i have already added field of content : profile files but it is not listed in query. Can anyone let me know what exactly i have to do to get list of updated / uploaded date of file ?

Thank you
Tejas Mehta

Views Developers

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: