[support] Some last tweaks needed to registration module.

[Philip_Wetzel at nhd.uscourts.gov]

BTW: I was actually able to get the regular view to display all of the
fields including
custom fields.  Hacked up Registration.module pretty good to do it.    I've
been able to
make hooks work, but had problems in this case.

Really wanted to sort on Last name.  From what I can tell the Entity module
sorts
just from one table and custom fields are in a separate table.  I think
there is a
select statement somewhere that needs to have a JOIN clause added somehow.

As far as I can tell there is no documentation to guide one through that.
I find that
accomplishing most of what I needed to modify is strait hard core reverse
engineering.

I see there is a whole module called registration_views contained within
the registration
module.  I have no clue how to use it or perhaps I am using it, but don't
know it.

Phil



From:	Philip_Wetzel at nhd.uscourts.gov
To:	support at drupal.org,
Date:	01/10/2014 01:06 PM
Subject:	Re: [support] Some last tweaks needed to registration module.
Sent by:	support-bounces at drupal.org



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/ ]

--
[ Drupal support list | http://lists.drupal.org/ ]