Differences From:

File src/tktsetup.c part of check-in [fb8dc7d07f] - The UNIQUE constraint on the default TICKET table was wrong. The tkt_uuid column should be unique unto itself, not in combination with tkt_time. Existing servers will need to fix their TICKET implementations using the setup menu. This check-in changes the default. by drh on 2008-10-05 13:13:13. [view]

To:

File src/tktsetup.c part of check-in [ac3f1f2ba7] - Improvements to how ticket changes are displayed in the UI. The hyperlink is show with strick-through if the ticket is closed. The title is shown after the ticket hyperlink. SQL to determine the closed condition and the title can be set in the ticket setup screens. by drh on 2008-10-18 02:27:13. [view]

@@ -41,8 +41,10 @@
   style_header("Ticket Setup");
   @ <table border="0" cellspacing="20">
   setup_menu_entry("Table", "tktsetup_tab",
     "Specify the schema of the  \"ticket\" table in the database.");
+  setup_menu_entry("Timeline", "tktsetup_timeline",
+    "How to display ticket status in the timeline");
   setup_menu_entry("Common", "tktsetup_com",
     "Common TH1 code run before all ticket processing.");
   setup_menu_entry("New Ticket Page", "tktsetup_newpage",
     "HTML with embedded TH1 code for the \"new ticket\" webpage.");
@@ -616,5 +618,44 @@
     0,
     0,
     10
   );
+}
+
+/*
+** WEBPAGE: tktsetup_timeline
+*/
+void tktsetup_timeline_page(void){
+  login_check_credentials();
+  if( !g.okSetup ){
+    login_needed();
+  }
+
+  if( P("setup") ){
+    cgi_redirect("tktsetup");
+  }
+  style_header("Ticket Display On Timelines");
+  db_begin_transaction();
+  @ <form action="%s(g.zBaseURL)/tktsetup_timeline" method="POST">
+
+  @ <hr>
+  entry_attribute("Ticket Title", 40, "ticket-title-expr", "t", "title");
+  @ <p>An SQL expression in a query against the TICKET table that will
+  @ return the title of the ticket for display purposes after hyperlinks to
+  @ that ticket</p>
+
+  @ <hr>
+  entry_attribute("Ticket Closed", 40, "ticket-closed-expr", "c",
+                  "status='Closed'");
+  @ <p>An SQL expression that evaluates to true in a TICKET table query if
+  @ the ticket is closed.</p>
+
+  @ <hr>
+  @ <p>
+  @ <input type="submit"  name="submit" value="Apply Changes">
+  @ <input type="submit" name="setup" value="Cancel">
+  @ </p>
+  @ </form>
+  db_end_transaction(0);
+  style_footer();
+
 }