CiviCRM Community Forums (archive)

Hi,

I'm trying create a view in Drupal to list some participants using the api.
I've started with the function from this thread http://forum.civicrm.org/index.php/topic,25690.msg108782.html#msg108782 which works fine but I wanted to add a couple of filters : only attendee and only certain status: registered, pending etc.

using this :

$params['id']=$row->id; //$row->id is the civi event id variable supplied by drupal views
  $params = array('event_id' => $params['id'], 'version' => 3,'participant_status_id' => 1, 'participant_role_id' => 1,);
  $getParticipants= civicrm_api("Participant","getcount", $params);
  $total=$getParticipants;
  return $total;

I get the list of participants with status registered and attendee role. but I can't work out how to add other participant status ids.
is there a way to list participants with status 1 or 2 or 5 etc ?
'participant_status_id' => ('1' OR '2')  something like that ?

sorry if this is a silly question ; I have to add I don't know much about PHP... I'm learning (the hard way)

thanks
 

Hi petednz
yes its is possible to filter participant type/ roles etc if I create a view for Participant, but in that case I only manage to get the list of events which have participants.
To list all events I create a view for Event but then I don't have the option to use the view filter for participant status.

is there a way to use AND / OR with 'participant_status_id'?
otherwise is it possible to use 'participant_status_id'  or maybe ParticipantStatusType is_counted (although not exactly the same thing in my case) as a php filter in view?

thanks

Hi
The only two relationships I can see listed  if I create an Event view are :
 CiviCRM Events: Campaign
CiviCRM Phone Details: Contact ID
.....I think I'm going to eat that gauntlet you've thrown down.

What I'm trying to do should be straight forward : list all events and display a count of attendees (registered or pending to pay later. ) and the number of available space for each event. If there is no attendees return the max participants.

As I said I can do this in a view of Participant with event id as relationship, using aggregation to count participant ids then using filter for selecting status and maths expression to subtract from the max participant.

But as I mentioned this only return events which have participants. Am I missing something here ?

Anyway that's why I'm trying to use the php function to filter by status, (which might be useful for non Views user too.) is it possible or am I chasing a wild goose ?

Thanks

Hi Pete

I appreciate you giving me pointers ( and I'm looking into the civi views files just now) but I'm not sure that modifying any of these files is a better solution for me than simply using the API.
(mainly from a maintenance point of view)

Although I think it would be useful to have this relationship setup "by default" ( maybe it's already on someone huge to do list) and will definitely post back if I manage to do it.

But in the mean time ...is it possible to use AND / OR with the Api ?

Thanks

right, haven't moved very far with view. managed to get rid of error messages but just get some nonsense in the query.
I can see the join is already there and a relationship is already defined in civicrm.event.inc but I can't make it work.