Hi,
I need to be able to sort the signup views by my custom fields for best results. I'll explain my usage to make it clear:
I provide signup for youth sailing events, so i have custom fields for boat class, sailnumber, sailing club. The goal is to be able to sort the view of signed up users by boat class and club, so that it is easy to see who in your class/club is signed up.

I cant find a way to do that presently, but is it possible?

My own thought is that to achieve that, the data needs to be saved in a table like
signupID
Label
Data
DataType

Is something like this on the TODO, or would work on it be appreciated?

CommentFileSizeAuthor
#3 signup_sort.091006.patch4.04 KBiva2k

Comments

dww’s picture

dww
we/he/they
commented
Status: Active » Closed (duplicate)

#29568: Flexible number and type of fields

It's a huge can of worms...

In D7, we should just use core fields and make signup objects fieldable.

In D6, here's the deal:

If you need only 1 "real" custom field, you can use signup_status.

There's talk of integration with webform, but that's still vaporware at this point.

There's also talk of partly rewriting signup_status into a more generic "signup_fields" module. Maybe that's the path towards D7 core fields, I dunno yet.

p.s. Re: your specific request: no, that's not possible, since these custom fields are a hack and stored in a rather insane way. There's no way to sort on them at all. So, either this issue is duplicate with #29568 or it's "won't fix" depending on your perspective. ;)

anders’s picture

anders commented

Thank you for commenting, I will have a look at signup_status.
I hope this can be fixed in the future.

iva2k’s picture

iva2k commented
StatusFileSize
new signup_sort.091006.patch4.04 KB

Signup_status.module does not cut it for me.

Attached is a patch that allows sorting signup views by custom field. The trick involves sorting the recordset in custom hook_views_pre_render() function after the query is executed. Notice: it supports only a single sort-by field, it will not work for click-sortable tables.

That solves the problem of signup lists and name badges being out of order on my website.