#354 - Store custom field values in their own table
Type Enhancement
Status Completed
Milestone 3.3
Version -
Component Custom fields
Priority Normal
Severity Normal
Owner Jack
Assigned to Jack
Reported 9 years ago
Updated 8 years ago
Votes 0
Related tickets
Proposed time
Worked time

Instead of storing the values of custom fields in the tickets extra column, save them into their own table.

That way filtering tickets by custom fields can be done with a JOIN instead of a hackish LIKE on the extra column like so:

SELECT `tickets`.* FROM `tickets`
JOIN `custom_fields_values` AS `fields`
  ON (`fields`.`custom_field_id` = 2 AND `fields`.`value` = "5.4.14" AND `fields`.`ticket_id` = `tickets`.`id`)

Tasks

  • Update install/upgrade files
  • Store custom field values in their own table
  • Cleanup code

Ticket History

8 years and 11 months ago by Jack

  • Status Accepted Started
  • Tasks Update install/upgrade files, Store custom field values in their own table, Cleanup code
Jack closed as Completed 8 years and 9 months ago