CiviCRM Community Forums (archive)

The storage of selected price set field values on a civicrm_contribution record seems rather odd.

From what I see, the labels of selected fields in the price set are stored in concatenated form in civicrm_contribution.amount_level rather than in a structured way using unique ids that would facilitate joining with civicrm_price_field for reporting. It's hard to see how to easily produce reports, especially efficient ones, using a join to the civicrm_price_field table.

Is this a quick and dirty implementation that could be changed by adding an additional table in the next release?