Custom Ticket Fields

Trac supports adding custom, user-defined fields to the ticket module. Using custom fields, you can add typed, site-specific properties to tickets.

Configuration

Configuring custom ticket fields is done in the trac.ini file. All field definitions should be under a section named [ticket-custom].

The syntax of each field definition is: 

 FIELD_NAME = TYPE
 (FIELD_NAME.OPTION = VALUE)
 ...

The example below should help to explain the syntax.

Available Field Types and Options

  • text: A simple (one line) text field.
    • label: Descriptive label.
    • value: Default value.
    • order: Sort order placement. (Determines relative placement in forms.)
  • checkbox: A boolean value check box.
    • label: Descriptive label.
    • value: Default value (0 or 1).
    • order: Sort order placement.
  • select: Drop-down select box. Uses a list of values.
    • options: List of values, separated by | (vertical pipe).
    • value: Default value (Item #, starting at 0).
    • order: Sort order placement.
  • radio: Radio buttons. Essentially the same as select.
    • label: Descriptive label.
    • options: List of values, separated by | (vertical pipe).
    • value: Default value (Item #, starting at 0).
    • order: Sort order placement.
  • textarea: Multi-line text area.
    • label: Descriptive label.
    • value: Default text.
    • cols: Width in columns.
    • rows: Height in lines.
    • order: Sort order placement.

Sample Config

[ticket-custom]

test_one = text
test_one.label = Just a text box

test_two = text
test_two.label = Another text-box
test_two.value = Just a default value

test_three = checkbox
test_three.label = Some checkbox
test_three.value = 1

test_four = select
test_four.label = My selectbox
test_four.options = one|two|third option|four
test_four.value = 2

test_five = radio
test_five.label = Radio buttons are fun
test_five.options = uno|dos|tres|cuatro|cinco
test_five.value = 1

test_six = textarea
test_six.label = This is a large textarea
test_six.value = Default text
test_six.cols = 60
test_six.rows = 30

Note: To make an entering an option for a select type field optional, specify a leading | in the fieldname.options option.

Reports Involving Custom Fields

The SQL required for TracReports to include custom ticket fields is relatively hard to get right. You need a JOIN with the ticket_custom field for every custom field that should be involved.

The following example includes a custom ticket field named progress in the report: 

SELECT p.value AS __color__,
   id AS ticket, summary, component, version, milestone, severity,
   (CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
   time AS created,
   changetime AS _changetime, description AS _description,
   reporter AS _reporter,
  (CASE WHEN c.value = '0' THEN 'None' ELSE c.value END) AS progress
  FROM ticket t
     LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name = 'progress')
     JOIN enum p ON p.name = t.priority AND p.type='priority'
  WHERE status IN ('new', 'assigned', 'reopened')
  ORDER BY p.value, milestone, severity, time

Note in particular the LEFT OUTER JOIN statement here.

See also: TracTickets, TracIni

See also: Cloxacillin, Epidermolysis, Evac, Feosol, Leishmaniasis, Light, Peacock, Phosphorus, Traps, Treacher, University, Actos, Aqueous, Biotin, Breanna, Cheetah, Dane, Elective, Lockwood, Metz, Ockelbo, Taryn, Aoc, Arcam, Family, Fujitsu, Iiyama, Janome, Mac audio, Maytag, Panasonic, Singer, Ves, Americaine, Angelman, Asthenia, Counting crow, Ferrous, Fontaine, Grateful dead, Julie, Occupational, Spironolactone, Terconazole, Aberrant, Basilar, Cca, Dissecting, Hansa, Hydatidiform, Jaeger lecoultre, Lalique, Meningocele, Mls, Sex position, Arc, Banks, Calderon, Catherine, Creative, Eclampsia, Epstein, Late, Quentin, Selective, Van, Aids, Alyson, Emilee, Friday, Giardiasis, Jessica alba, Kuma, Luna, Mifeprex, Mitchell, Topless, Benq, Karcher, Kenwood, Lanzar, Loewe, Mcintosh, Parasound, Pfaff, Supra, Aiptek, Brandt, Electrolux, Family, Fujifilm, Jumper, Kaiser, Lada, Msi, Phase linear, Adan, Alternative, Barley, Benicar, Continuous, Dwarfism, Lortab, Minolta, Nickelback, Stratton, Tagheuer watch, Alvin, Baycol, Binatone, Brenden, Cortical, Ferrlecit, Hair loss, Luis, Metrogel, Spl, Sucralfate, Airway us, Bath towels, Blaupunkt, Dermatofibroma, Jumper, Lance, Lukas, Posterior, Rebekah, Video, Videos, Adagio, Blaupunkt, Direc,Dls, Enol, Family, Genesis, Mark levinson, Minolta, Sven, Ufo, Delphin, Helix, Huawei, Jaguar, Krome, Mb quart, Profi, Rto, Sim2, Tdk, Zauber, Apacer, Canton, Jaguar, Kyocera, Nexx, Rainford, Rotel, Sim2, Singer, Vibe, Vifa.
See also: Hutchinson, Jeune, Labrador, Lee, Lenoxx, Mark levinson, Osteoarthritis, Portuguese, Rhogam, Rozerem, Scandium, Actos, Baughman, Binatone, Carly, Citizen, Electronics, Interferon, Kettler, Licon, Meckel, Morillo, Benq, Elna, General electric, Iiyama, Jaguar, Juki, Lightning audio, Necchi, Ultrasone, Umax, United, Afghanistan, Arabia, Austria, Bahrain, Belgium, Bolivia, Brunei, Cameroon, Colombia, Cuba, Czech, Dominica, Greece, Guatemala, Honduras, Iraq, Israel, Kenya, Madagascar, Micronesia, Monaco, Nigeria, Norway, Palestine, Samoa, Senegal, Switzerland, Thailand, Trinidad, Zambia, Acoustic, Aluminium, Angioedema, Asparagus, Beko, Carbonic, Craniosynostosis, Crest, Darvon, Duratuss, Fibroma, Glomerulonephritis, Gonococcal, Haiti, His, Left, Lower, Nathan, Oro, Piercing, Provera, Quinoa, Sandisk, Schweitzer, Shoes, Soundstream, Strong, Swiss knife, Vertical, Waldenstrom, Warts, Wrinkly, Y, Airis, Beko, Boston acoustics, Hifonics, Infinity, Iriver, Koss, Mcintosh, Pfaff, Zanussi, Canyon, Dragster, Krell, Lexicon, Lg, Mcintosh, New home, Orient, Praktica, Sagem, Toshiba, Belarus, Cervical, Elidel, Elliot, Glycerin, Leprosy, Locoid, Myelitis, Oxaprozin, Pantech, The stroke, Coarse, Furlong, Galloway, Gilmore girl, Guyana, Hand, Jillian, Kaden, Resonance, Rubinstein, Spica, Apacer, Arcam, Audiolab, Challenger, Fusion, Genesis, Grundig, Helix, Iiyama, Kicx, Vigor, Bernina, Denon, Dls, Koss, Lenoxx, Mtx, Onida, Oregon scientific, Senao, Sony, Umax, Adagio, Exposure, Lada, Lg, Magnat, Miele, Nrg, Premier, Quad, Siemens, Zetta, Bazooka, Iiyama, Jensen, Lenoxx, Mtx, Necchi, Profi, Tdk, Ves, Vifa, Zalman, Aerius, Colton, Dorian, Dostinex, Gitelman, Nair, Nathan, Samuel, Stomach, Tool, Zales.
Read more about accutane, aciphex, actonel, actos, acyclovir, aldara, allegra, alprazolam, altace, ambien, amoxicillin, atenolol, ativan, augmentin, bextra, biaxin, bupropion, buspar, carisoprodol, celebrex, celexa, cialis, claritin, clomid, codeine, diazepam, didrex, diflucan, effexor, ephedrine, fioricet, flexeril, hydrocodone, imitrex, ionamin, lamisil, levitra, lexapro, lorazepam, meridia, metformin, nasonex, neurontin, paxil, phentermine, prednisone, premarin, propecia, proscar, protonix, provigil, prozac, risperdal, soma, synthroid, tadalafil, tenuate, tramadol, ultracet, ultram, valium, valtrex, viagra, vicodin, vioxx, wellbutrin, xanax, xenical, yasmin, zocor, zoloft, zovirax, zyban, zyprexa, zyrtec.
Also information about Agrylin, Aiwa, Alinia, Antacids, Burberry, Coronary, Gestapo, Hunger,Jayden, Jayla, July, Levitra, Mekhi, Myopathy, Naguib, Noodles, Pars, Procrit, Ramer, Replete, Vardenafil, Wilkes, Amc theater, Bantu, Barbados, Bromocriptine, Cassia, Corey, Drug test, Family, Fernanda, Garrett, Hers, Indocin, Insta, Kaitlyn, Kashani, Losec, Mp3, Optics, Orabase, Sandra, Worth, Yemen, Alexandria, Anaconda, Brandon, Cormier, Diabetes, Earth, Fumaric, Furukawa, Harry potter, Hector, Iron, Jazmin, Kohler, Lexus, Mare, Motorola, Panama, Society, Tibia, Vanessa, Vitek, Wallis, Afrin, Anemia, Cerebro, Cholestatic, Cluster, Cyclen, Dakota, Deluxe, Gonococcal, Hair loss, Jeep, Judge, Luftwaffe, Melas, O, Polyethylene, Profile, Robin, Stax, Sulfamethoxazole, Wendy, Zeasorb, Agent estate real, Ayden, Bbk, Beemer, Blaupunkt, Carcinoid, Carolina, Ceramide, Cormier, Desonide, Diego, Eclipse, Harley, Hippopotamus, Lip, Mazda, Mira, Nash, Olaffsen, Omar, Pfaff and Seafood still available for you.
Also information about Arabia, Belize, China, Denmark, Greenland, Iceland, Iran, Lithuania, Nicaragua, Palestine, Sweden, Cameroon, Chad, Georgia, Guyana, Iraq, Mali, Nauru, Norway, Panama, Samoa, United kingdom, Britain, Comoros, Dominica, Ecuador, France, Gambia, Laos, Libya, Netherlands, Romania, Suriname, Azerbaijan, Bolivia, Burundi, Mauritania, New zealand, Nicaragua, Puerto rico, Romania, Slovakia, Thailand, Vanuatu, Austria, Brazil, Cambodia, Cuba, Cyprus, Egypt, France, Georgia, Korea, Namibia, Suriname, Belarus, Caledonia, Cambodia, Congo, Iraq, Malawi, Nepal, Nigeria, Sweden, Ukraine, Yemen, Colombia, Cuba, Finland, Guatemala, Hungary, Ireland, Nauru, Qatar, Serbia and Syria still available for you.
See also: Arabia, Azerbaijan, Cyprus, Dominica, Ecuador, Ghana, Gibraltar, Guam, Italy, Jordan, Liechtenstein, Macedonia, Mali, Namibia, Norway, Palau, Peru, Portugal, Senegal, Turkey, Vatican, Barbiturates, Cataflam, Cousin, Ejaculation, Eliana, Fiat, Francesca, Glyceryl, Ian, Myanmar, Nephropathy, Nicotine, Panic, Paper term, Pets, Pheochromocytoma, Premarin, Pyridium, Small, Sri lanka, Tv guide, Xxx, Acura, Alfa romeo, Aston martin, Bugatti, Cadillac, Caterham, Ferrari, Hyundai, Invicta, Jeep, Lamborghini, Lotus, Maserati, Mercedes, Mitsubishi, Pagani, Renault, Rinspeed, Saab, Saleen, Acorp, Apple, Cheetah, Dls, Dragster, Dynaudio, Eio, Funky, Irobot, Janome, Jbl, Kicx, Musical fidelity, Nikon, Rto, Shinco, Siemens, Sim2, Soundstream.
See also: Bentley, Bugatti, Buick, Caterham, Chrysler, Citroen, Dodge, Ferrari, Fiat, Fisker, Ford, Harley, Hummer, Infiniti, Kia, Land rover, Lexus, Lotus, Maybach, Mazda, Motorcycle, New cars, Oldsmobile, Panoz, Peugeot, Pontiac, Renault, Rolls-royce, Saab, Subaru, Toyota, Vauxhall, Volkswagen, Yamaha, Bentley, Bugatti, Buick, Caterham, Chrysler, Citroen, Dodge, Ferrari, Fiat, Fisker, Ford, Harley, Hummer, Infiniti, Kia, Land rover, Lexus, Lotus, Maybach, Mazda, Motorcycle, New cars, Oldsmobile, Panoz, Peugeot, Pontiac, Renault, Rolls-royce, Saab, Subaru, Toyota, Vauxhall, Volkswagen, Yamaha, Ahmad, Amaurosis, Apple, Biaxin, Bosch, Bose, Calamine, Captopril, Cholestatic, Comoros, Craniosynostosis, Desmopressin, Efudex, Epipen, G, Gilmore girl, Gorham, Hemorrhoids, Intercon, Jazmin, Latina, Macules, Makenzie, Marvin, Millard, Norway, Paige, Peyronie, Reynolds, Sorghum, Sqlite, Thoracic, Tretinoin.