CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Delete *just* first of multiple participants?
Pages: [1]

Author Topic: Delete *just* first of multiple participants?  (Read 952 times)

bokabu

  • I’m new here
  • *
  • Posts: 16
  • Karma: 1
    • California Creativity
Delete *just* first of multiple participants?
December 15, 2009, 11:39:54 pm
I just discovered that I cannot delete just the first of multiple participants.  Is there a way to avoid/break this feature so that additional participants can stay registered?

I have a profile affiliated with the registration.  I have discovered (and enforce with hooks) that every registrant must register themselves first (lest they instead cause their own profile to be changed).  I want "team managers" to be able to come in a second time and register more team members, but since they then create a duplicate event record, I want to be able to go clean it up later.  The "all or none" participant deletion keeps me from doing that.

Any clues would be appreciated.

- Bob

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Delete *just* first of multiple participants?
December 16, 2009, 01:26:35 am
Or even better if people could register others without registering themselves? That would be really handy! It would solve your problem and a handful of others - like parents registering kids for things
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Delete *just* first of multiple participants?
December 16, 2009, 07:08:52 am

this has been on the wishlist for some time. would be great for someone to step up and either contribute the code or sponsor the core team to do this. i suspect its a 50 hour or so project

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

bokabu

  • I’m new here
  • *
  • Posts: 16
  • Karma: 1
    • California Creativity
Re: Delete *just* first of multiple participants?
December 17, 2009, 11:30:08 pm
For now, I'll be breaking the official binding between the primary registrant and their minions by periodically invoking

  UPDATE civicrm_participant SET source=registered_by_id,registered_by_id=NULL WHERE registered_by_id IS NOT NULL;

That lets me keep the "registered_by_id" in the previously NULL source in case I want to look at it with phpMyAdmin later, but NULLs out the registered_by_id, thereby breaking the link.

I tried this and it works, but I'm relying on left-to-right execution order for UPDATE, and I've not found documentation that assures me that's guaranteed.

- Bob

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Delete *just* first of multiple participants?

This forum was archived on 2017-11-26.