TDF does a great job of tracking file downloads and the Views integration is working nicely. I have created a View and a Views Data Export to periodically export reports of files downloads, but cannot filter the results by dates since the Time field is displayed as a Unix timestamp. The reports that are included with TDF display readable dates instead of the timestamp. Is it possible to format the timestamp as a readable date or otherwise be able to use the Time field to filter the views results by date?
| Comment | File | Size | Author |
|---|---|---|---|
| #11 | track_da_file-date_formatter_for_time_field_in_views-2442421-11-D7.patch | 912 bytes | oksana-c |
Comments
Comment #1
edodes commentedHi,
I solved this problem. That field in view is defined as numeric instead of date.
Edit the file track_da_files.views.in situated in track_da_files/includes/views folder.
Change views_handler_field_numeric with views_handler_field_date value :
// time.
$table['track_da_files']['time'] = array(
'title' => t('Time'),
'help' => t('Time'),
'field' => array(
'handler' => 'views_handler_field_numeric',
'help' => t('Time'),
'click sortable' => true,
),
'filter' => array(
'handler' => 'views_handler_filter_numeric',
'allow empty' => true,
'help' => t('Filter on Time'),
),
'argument' => array(
'handler' => 'views_handler_argument_numeric',
'help' => t('Time'),
),
with
// time.
$table['track_da_files']['time'] = array(
'title' => t('Time'),
'help' => t('Time'),
'field' => array(
'handler' => 'views_handler_field_date',
'help' => t('Time'),
'click sortable' => true,
),
'filter' => array(
'handler' => 'views_handler_filter_date',
'allow empty' => true,
'help' => t('Filter on Time'),
),
'argument' => array(
'handler' => 'views_handler_argument_date',
'help' => t('Time'),
),
Comment #2
edodes commentedComment #4
oksana-c commentedCreated a patch with edodes code.
Marking this as "Needs Review" because the patch is not yet committed in dev.
Comment #6
oksana-c commentedadjusted patch format
Comment #7
oksana-c commentedComment #9
oksana-c commentedok, learning on my own mistakes. This time should pass the test...
Comment #11
oksana-c commentedComment #13
federiko_ commentedThank you all for your contribution.
oksana-c , your last patch has been commited in stable release of the module.