Well, I have 2 days left before I officially declare NH District Court Website is complete and move on to Probation (their website). I had my dog and pony show yesterday, which went pretty well. I think we all agreed that I met expectations. I do however, have a list of "it'd be nice if you could...." items.
One thing I really want to figure out is with the registrations module. Out of the box you can list registrants with the standard columns. If you add custom fields, such as LastName, FirstName to your registration type, you can list them here (with work). I ran into trouble when I tried to make LastName sortable. What's weird is it will sort once (and spew out errors).
Delving further..... registration_registrations_page function... It first builds the header. A standard column looks like this....
$header = array( array( 'data' => t('id'), 'field' => 'registration_id', 'type' => 'property', 'specifier' => 'registration_id', ),
.....
I was hoping I could take my custom field and do something like this......
array( 'data' => t('Last Name'), 'field' => 'field_last_name', 'sort' => 'desc', 'type' => 'property', 'specifier' => 'field_last_name' ),
It doesn't like 'type' at all..... SQL error. Looking further you can see that the standard columns are in the table 'registrations' in this case. My custom field is in a separate table. field_data_field_last_name. (field_last_name is the name of the column).
The SQL query is expecting everything to be in the 'registrations' table. Is there some way I need to tell it to look in the other table for last name? I haven't been able to figure out where in the code this query is happening (if that's even possible). Currently out of ideas.
Anyone? Thanks in advance, Phil
PS: on that very page they indicated that they would like a button to press to print all registrants and a button to dump all registrants into a comma delimited .CSV. I have no clue how to do that - haven't had time to search on it. Thought I'd throw that one out too.