CiviCRM Community Forums (archive)

Hello, I'm new to CiviCRM. Maybe I'm not understanding this properly, but when I enter a search term in the Fee Level field of the Participant Search, it doesn't seem to have any affect. I get the same search result as I do w/o the Fee Level Search. All of the Fee Level data is stored in a single field in the participants table, so, ideally, text entered in this field would use wild card on both ends of the search term (e.g.: civicrm_participant.fee_level LIKE '%search terms%'). I've attempted to do a little troubleshooting, but I can't find exactly how the SQL query is built. It looks to me like the Fee Level condition is left out of my query.

I should also note, I'm using a custom price set for this event.

Any help will be greatly appreciated.

Peter

Thanks,
Does civicrm have a mysql log or are you referring to the logging through mysql itself? I don't have shell access to the server my site is on, so I don't think I can get to the mysql logs.

I did enter a sample event into the sandbox and came up with the same result. How do I go about filing this as a bug?

I would be happy to help work on the solution to this if anyone could point me in the right direction. I can provide more detail about what I've discovered so far. The building of database queries seems to be incredibly complex in civicrm.

-Peter