CiviCRM Community Forums (archive)

I'm dealing with the same issue, we have teams we send out (each team set up as an Event) and each team gets a unique team number.  I have that set up as a custom field at the event level (since it's a number per team/event) and a hook to populate the team number.  Our folks currently (in their non-Civi system) rely solely on that Team Number for searches and editing. I'd need a way to expose this in Civi's searches (Find Participants, etc) and reports.

For the gurus out there, how hard would it be to implement custom fields at the Event level searches and reports?

peterd, here is the note next to the custom field "Is this Field Searchable?" box (not good news, seems like it's a feature, not a bug, as Events are not in the list):

NOTE: This feature is available to custom fields used for Contacts (individuals, organizations and househoulds), Contributions, Pledges, Memberships, Event Participants, Activities, and Relationships.

If this is a huge issue to implement, one alternative I can think of for both our cases would be to write a hook that concatenates the custom field value to the Event Name so we end up with a new event name that has both and would show up in searches.  It's a bit hacky, imho, but might work as a stop-gap.

i suspect this is a 20-40 hour project. Would be great if someone can make a code contribution and/or sponsorship to make this happen

lobo

pbarmak - did you resolve anything for your own needs?

We pretty much built out what I described above - I created a hook on the custom "team number" field which updates the Event Title/Name, prefixing it with the value of this custom field.  Unfortunately, it has to be a prefix as the search field for the event name performs a like on the beginning of the title, it doesn't do a full string search using like '%<text>%'.  That would be another nice to have - allowing the event name search to have wildcards on both sides.

Anyway, I had to create the hook to suffice another issue I was having - the one where we can't have multiple partial payments for a single event participant.  I needed to link the event id to a custom field in the Contributions so we can apply multiple contributions to a single event participant.  So it turned out ok for now, but I sure would love to see this change - it'll help a lot with reporting.

Thanks guys.