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