User: Created date argument [#1090606]

Comment	File	Size	Author
#6	user_created_argument-1090606.patch	2.62 KB	bjalford

Comment #1

German

CreditAttribution: dawehner commented 13 March 2011 at 09:41

Version:	7.x-3.x-dev	» 6.x-3.x-dev
Category:	feature	» task

Someone would have to write "user: Created year + month" and some more.

This could be done in 6.x-3.x, too.
See #373615: Comment date not available as arguments for a similar issue with comments.

Log in or register to post comments

Comment #2

bjalford CreditAttribution: bjalford commented 13 March 2011 at 20:03

I tried adding to users.views.inc the same same data as the comments patch (replacing comments with users)
e.g.
$data [users]['timestamp_fulldate'] etc with the same handlers. The options appear under arguments in views UI but they produce an error...

Can you point me in the right direction?

Log in or register to post comments

Comment #3

dawehner

German

CreditAttribution: dawehner commented 13 March 2011 at 20:05

Status:

Active

» Postponed (maintainer needs more info)

Without the error?

Please post the error

Log in or register to post comments

Comment #4

bjalford CreditAttribution: bjalford commented 13 March 2011 at 20:36

Here is my user.view.inc (my bit at line 185) http://pastebin.com/ViDBQHB5.

Error:
An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: /?q=admin/structure/views/ajax/preview/users_per_month&render=overlay
StatusText: Service unavailable (with message)
ResponseText: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'users.timestamp' in 'field list': SELECT COUNT(*) AS expression
FROM
(SELECT DATE_FORMAT((DATE_ADD('19700101', INTERVAL users.timestamp SECOND) + INTERVAL 0 SECOND), '%Y%m') AS timestamp_year_month, 1 AS expression
FROM
{users} users
GROUP BY timestamp_year_month) subquery; Array
(
)
in views_plugin_pager->execute_count_query() (line 140 of /Applications/XAMPP/xamppfiles/htdocs/lot/sites/all/modules/views/plugins/views_plugin_pager.inc).