I have some extra information stored at the users table in the "data column", when I use views I cant get it to select the data column from users table in the query, I know its saved as serialized data and I don't care I just need to get it's value.

please any help will be much appreciated.

Comments

dawehner’s picture

Category: bug » task

A non existent feature is a bug?

Someone could write a serialized field handler and add the user views data integration.

dawehner’s picture

Status: Active » Needs review
StatusFileSize
new3.18 KB

Here is a patch for it.

rawash’s picture

Thank you dereine for your effort.
the field user data now appears in the user list of fields but when I try to add it, it generates the following error
Error: handler for users > data doesn't exist!
I was looking at your patch and noticed that the file views.info don't contain the lines
files[] = handlers/views_handler_field_math.inc
files[] = handlers/views_handler_field_numeric.inc
files[] = handlers/views_handler_field_prerender_list.inc
+files[] = handlers/views_handler_field_serialized.inc
files[] = handlers/views_handler_field_url.inc
files[] = handlers/views_handler_filter.inc
files[] = handlers/views_handler_filter_group_by_numeric.inc

rawash’s picture

Issue tags: +views, +users data

FYI
am using the 6.x-2.12 version

dawehner’s picture

Status: Needs review » Needs work

Yeah, this path was against 7.x-3.x

rawash’s picture

:)
could you help me and create a patch for the 6.x-2.12 version, u will do for me a big favor.

dawehner’s picture

Status: Needs work » Fixed
StatusFileSize
new3.15 KB

Here is the patch against 6.x-3.x

This patch was commited already against 6.x-3.x and 7.x-3.x, but will not be commited to 6.x-2.x, because it's in a bug-fix only modus.

Status: Fixed » Closed (fixed)
Issue tags: -views, -data column, -users data

Automatically closed -- issue fixed for 2 weeks with no activity.