list of all participations for a contact

Question

I am trying to get a list of all Ids of participations for a certain contact_id (to use it in JS). Currently I am using the _civicrm_buildForm hook to do that, but to extract the contact_id from the passed in $form object I need to use reflection, since is is stored under _form_values which is protected and $form->getFormValues() always returns NULL.

Also CRM_Core_Resources::singleton()->addScript($script, 5, 'page-footer') doesn't seem to have any effect, probably its too late to call it. So I'm simply echoing the script.

==> all less then ideal I assume it is possible to get the participant ids with smarty or an ajax call, but haven't found any example how to express a "Where-Clause" with those. This is the SQL-Query I'm trying to perform:

SELECT `id` FROM `civicrm_participant` WHERE `contact_id`= x

So any help to prettify the first approach or an example for the others would be much appreciated .

Answer 1

Ouch - you're doing it the hard way!

Getting a list of participant records by contact ID is pretty simple using the API. It sounds like maybe you haven't discovered the API Explorer. Without knowing your Civi version (and CMS software/version) I can't tell you exactly where to find it. If you're on Civi 4.5 or 4.6, then in the Help menu (renamed to Support menu in 4.6.5+), go to Developer > API Explorer. If you're on an earlier version, in Drupal it's example.org/civicrm/api/explorer - I can't speak to other CMSes.

Below I've copy/pasted my API Explorer results for finding all the participant records for contact ID 247. Note that some of the syntax for Javascript may not work in Civi earlier than 4.6, so run API Explorer yourself to double-check!

Rest

/sites/all/modules/civicrm/extern/rest.php?entity=Participant&action=get&api_key=yourkey&key=sitekey&json={"sequential":1,"contact_id":247}

Smarty

{crmAPI var='result' entity='Participant' action='get' contact_id=247}
{foreach from=$result.values item=participant}
  {$participant.some_field}
{/foreach}

Php

$result = civicrm_api3('Participant', 'get', array(
  'sequential' => 1,
  'contact_id' => 247,
));

Javascript

CRM.api3('Participant', 'get', {
  "sequential": 1,
  "contact_id": 247
}).done(function(result) {
  // do something
});