CiviCRM Community Forums (archive)

Hello, CiviPeople!

Firstly, thanks for the huge amount of work and dedication you all put in to CiviCRM. Now if I can just work out how to use it... :/!!!

I think I keep trying to make things too complicated, but am finding that I have so many things I want it to do! With that in mind, I have a question...

Is it possible to search for contacts that have attended an event at a given venue?

I need to create a register so that staff can choose to tick off individuals that have attended events at particular venues. The register would be made up of past attendees.

This may sound a bit wierd, but for monitoring and funding purposes we need to know who went to what session. As these are open access play sessions in parks etc, registering online is not really an option.

I'm thinking that if I can search and find the contacts then I can make a smart group and work from there.

I can't find any way to do this, or even to search for participants that have attended events with particular attributes (people that have attended events in Bristol - for instance)

Is this possible? of is it a job for mysql and php?

OK, I'm back to this now, but am a bit lost in how to accomplish it.
How can I make the location (of events) available in a custom event report to find participants that attended that venue?

My Mysql and PHP are not good, but with a bit of a start, I think I can start to work out what's going on.

Can anyone point me in the right direction?

...please?

Thanks Lobo... I've spent about a day and a half looking at the:
 - http://wiki.civicrm.org/confluence/display/CRMDOC/CiviReport+Reference
 - http://wiki.civicrm.org/confluence/display/CRMDOC33/CiviReport+structure+and+customization

and various other docs, but my php and mysql isn't good enough --this is my path to learning. There's not a lot of documentation in the code to take the pain away...

I think I need to refer to the loc_block_id in the civicrm_event table and use it to get the address_id, then I could show the addresses on the form, but how do I get info from two tables away and keep them relevant?

are the any templates which do this? I can't find any that aren't quite straightforward.

I know peoples time is precious, but I can put notes in a template and hopfully help others through the process if I can understand it.

Appreciate if people are too busy, though...

Marsh