Store custom field values in their own table

354
Enhancement
Jack
Jack
3.3
-
Custom fields
Completed
Normal
Normal
4 years ago
3 years ago
0

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

Ticket History

4 years ago by Jack

  • Changed Status from Accepted to Started
  • Set Tasks to Update install/upgrade files, Store custom field values in their own table, Cleanup code

3 years and 11 months ago by Jack

  • Closed ticket as Completed