#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 11 years ago
Updated 11 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

11 years and 3 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 11 years and 2 months ago