Changes between Version 23 and Version 24 of TracTicketsCustomFields

Timestamp:

Apr 7, 2008, 1:37:39 PM (16 years ago)

Author:

mbucas@…

Comment:

Details on updating ticket_custom when adding a new custom field

TracTicketsCustomFields

@@ -125 +125 @@
 }}}
 
+If you added multiple custom fields at different points in time, you should be more specific in the subquery on table {{{ticket}}} by adding the exact custom field name to the query:
+
+{{{
+#!sql
+INSERT INTO ticket_custom
+   (ticket, name, value)
+   SELECT 
+      id AS ticket,
+      'request_source' AS name,
+      'None' AS value
+   FROM ticket 
+   WHERE id NOT IN (
+      SELECT ticket FROM ticket_custom WHERE name = 'request_source'
+   );
+}}}
+
 ----
 See also: TracTickets, TracIni