Changes between Version 1 and Version 2 of TracTicketsCustomFields
- Timestamp:
- Jun 23, 2015, 6:04:32 PM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TracTicketsCustomFields
v1 v2 18 18 * value: Default value. 19 19 * order: Sort order placement. (Determines relative placement in forms with respect to other custom fields.) 20 * format: One of: 21 * `plain` for plain text 22 * `wiki` to interpret the content as WikiFormatting (''since 0.11.3'') 23 * `reference` to treat the content as a queryable value (''since 1.0'') 24 * `list` to interpret the content as a list of queryable values, separated by whitespace (''since 1.0'') 20 25 * '''checkbox''': A boolean value check box. 21 26 * label: Descriptive label. … … 35 40 * label: Descriptive label. 36 41 * value: Default text. 37 * cols: Width in columns .42 * cols: Width in columns 38 43 * rows: Height in lines. 39 44 * order: Sort order placement. 45 * format: Either `plain` for plain text or `wiki` to interpret the content as WikiFormatting. (''since 0.11.3'') 46 47 Macros will be expanded when rendering `textarea` fields with format `wiki`, but not when rendering `text` fields with format `wiki`. 40 48 41 49 === Sample Config === … … 48 56 test_two = text 49 57 test_two.label = Another text-box 50 test_two.value = Just a default value 58 test_two.value = Default [mailto:joe@nospam.com owner] 59 test_two.format = wiki 51 60 52 61 test_three = checkbox … … 79 88 {{{ 80 89 #!sql 90 SELECT p.value AS __color__, 81 91 id AS ticket, summary, owner, c.value AS progress 82 92 FROM ticket t, enum p, ticket_custom c … … 90 100 {{{ 91 101 #!sql 102 SELECT p.value AS __color__, 92 103 id AS ticket, summary, component, version, milestone, severity, 93 104 (CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner, … … 104 115 105 116 Note in particular the `LEFT OUTER JOIN` statement here. 117 118 Note that if your config file uses an uppercase name, e.g., 119 {{{ 120 [ticket-custom] 121 122 Progress_Type = text 123 }}} 124 you would use lowercase in the SQL: `AND c.name = 'progress_type'` 106 125 107 126 === Updating the database ===