CiviCRM Community Forums (archive)

I am new to CiviCRM, (hopefully going live with event registration this week)  so if this is something that can be done already, please accept my apologies and it would be great if someone can tell me how.

I would like to be able to search using price fields in the same way that you can search using custom fields.  At the moment it seems that all the data from a price set is contained in the one field, separated by commas, so if I want to find, say everyone who has chosen to add the $15 Lunch to their seminar registration, it becomes a tedious business - particularly if you have several different price fields and several price options within each field.   

The only way I seem to be able to deal with this is to work out all the different total event fees there could be if lunch has been chosen, create a smart group based on fee amount for each total and combine all the smart groups into a parent smart group called "requires lunch".  Not very efficient and it won't work at all if you can get the same event total using 2 (or more) combinations of price options. (I've had to introduce a "$1 administration discount" for one item to get over this - unfortunately the event brochures were printed before we had access to civiCRM so we didn't forsee this problem)

I'm not quite sure about the structure of the database ( how can I find this out?), but it seems likely to me that each custom data set is a table with each custom data field being a column in that table.  It would be good to do the same for price sets (table) and price fields(column).  I suppose at the moment that each price set is a column within, perhaps, the events table.

JoAnne