<div dir="ltr">I have created views that we use as an alternative to the regular registration lists. I use Views Data Export to allow for CSV export. </div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jan 8, 2014 at 11:19 AM, <span dir="ltr"><<a href="mailto:Philip_Wetzel@nhd.uscourts.gov" target="_blank">Philip_Wetzel@nhd.uscourts.gov</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Well, I have 2 days left before I officially declare NH District Court<br>
Website is complete<br>
and move on to Probation (their website). I had my dog and pony show<br>
yesterday,<br>
which went pretty well. I think we all agreed that I met expectations. I<br>
do however,<br>
have a list of "it'd be nice if you could...." items.<br>
<br>
One thing I really want to figure out is with the registrations module.<br>
Out of the box you can<br>
list registrants with the standard columns. If you add custom fields, such<br>
as LastName, FirstName to<br>
your registration type, you can list them here (with work). I ran into<br>
trouble when I tried to make LastName<br>
sortable. What's weird is it will sort once (and spew out errors).<br>
<br>
Delving further..... registration_registrations_page function... It first<br>
builds the header.<br>
A standard column looks like this....<br>
<br>
$header = array(<br>
array(<br>
'data' => t('id'),<br>
'field' => 'registration_id',<br>
'type' => 'property',<br>
'specifier' => 'registration_id',<br>
),<br>
<br>
.....<br>
<br>
I was hoping I could take my custom field and do something like this......<br>
<br>
array(<br>
'data' => t('Last Name'),<br>
'field' => 'field_last_name',<br>
'sort' => 'desc',<br>
'type' => 'property',<br>
'specifier' => 'field_last_name'<br>
),<br>
<br>
It doesn't like 'type' at all..... SQL error. Looking further you can see<br>
that the standard columns are in<br>
the table 'registrations' in this case. My custom field is in a separate<br>
table. field_data_field_last_name.<br>
(field_last_name is the name of the column).<br>
<br>
The SQL query is expecting everything to be in the 'registrations' table.<br>
Is there some way I need to tell it<br>
to look in the other table for last name? I haven't been able to figure<br>
out where in the code this query is happening<br>
(if that's even possible). Currently out of ideas.<br>
<br>
Anyone?<br>
Thanks in advance,<br>
Phil<br>
<br>
PS: on that very page they indicated that they would like a button to press<br>
to print all registrants and<br>
a button to dump all registrants into a comma delimited .CSV. I have no<br>
clue how to do that - haven't<br>
had time to search on it. Thought I'd throw that one out too.<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br>Steve Kessler<div>Owner and Lead Consultant </div><div>Denver DataMan, LLC </div><div>303-587-4428</div>
</div>