#354 - Store custom field values in their own table

Description

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

Activity

12 years and 2 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 12 years and 1 month ago

Status

Completed
Jack
Normal

Details

Enhancement
3.3
Custom fields
-
Normal

Tracking

Jack
12 years and 6 months ago
11 years and 11 months ago
0
-
-