[support] Some last tweaks needed to registration module.
Philip_Wetzel at nhd.uscourts.gov
Philip_Wetzel at nhd.uscourts.gov
Fri Jan 10 17:55:47 UTC 2014
Hi Steve,
I hate to sound like an invalid, but I haven't had much success in
duplicating the
registrant list with a view. I'm still struggling when I need to use a
wildcard
(for lack of a better description). For instance node/514/registrations
replaced
with node/%/registrations. Seems to work, but how are the fields
specified.
It's been hard finding good info in this area.
Thanks,
Phil
From: Steve Kessler <skessler at denverdataman.com>
To: "support at drupal.org" <support at drupal.org>,
Date: 01/08/2014 03:02 PM
Subject: Re: [support] Some last tweaks needed to registration module.
Sent by: support-bounces at drupal.org
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.
On Wed, Jan 8, 2014 at 11:19 AM, <Philip_Wetzel at nhd.uscourts.gov> wrote:
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.
--
[ Drupal support list | http://lists.drupal.org/ ]
--
Steve Kessler
Owner and Lead Consultant
Denver DataMan, LLC
303-587-4428--
[ Drupal support list | http://lists.drupal.org/ ]
More information about the support
mailing list