Index: openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-one-postgresql.xql,v diff -u -r1.8 -r1.9 --- openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql 8 Aug 2003 22:24:14 -0000 1.8 +++ openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql 11 Aug 2003 20:00:18 -0000 1.9 @@ -70,7 +70,7 @@ WHERE t.item_id = :task_id and t.item_id = i.item_id - $orderby_revisions_clause + [template::list::orderby_clause -name revisions -orderby] @@ -91,7 +91,7 @@ c.parent_task_id = t.item_id and t.revision_id = i.live_revision and t.item_id = i.item_id - $orderby_consts_clause + [template::list::orderby_clause -name consts -orderby] @@ -113,7 +113,7 @@ c.parent_task_id = :task_id and t.revision_id = i.live_revision and t.item_id = i.item_id - $orderby_consts2_clause + [template::list::orderby_clause -name consts2 -orderby] Index: openacs-4/contrib/packages/project-manager/www/task-one.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-one.tcl,v diff -u -r1.10 -r1.11 --- openacs-4/contrib/packages/project-manager/www/task-one.tcl 8 Aug 2003 22:24:14 -0000 1.10 +++ openacs-4/contrib/packages/project-manager/www/task-one.tcl 11 Aug 2003 20:00:18 -0000 1.11 @@ -16,10 +16,15 @@ @param project_item_id the item_id for the project. Used for navigational links @param project_id the revision_id for the project. Used for navigational links @param context_bar value for context bar creation + @param orderby_revisions specifies how the revisions table will be sorted + @param orderby_consts specifies how the constraints will be sorted + @param orderby_consts2 specifies how the constraints will be sorted (for tasks that have constraints on this task) } { task_id:integer,optional task_revision_id:integer,optional - orderby:optional + orderby_revisions:optional + orderby_consts:optional + orderby_consts2:optional } -properties { task_info:onerow @@ -110,16 +115,18 @@ percent_complete {orderby percent_complete} start_date {orderby start_date} end_date {orderby end_date} + default_value revision_id,desc } \ + -orderby_name orderby_revisions \ -filters { - task_revision_id + task_revision_id {} + orderby_consts {} + orderby_consts2 {} + } \ + -html { + width 100% } -if {[exists_and_not_null orderby]} { - set orderby_revisions_clause "ORDER BY [template::list::orderby_clause -name revisions]" -} else { - set orderby_revisions_clause "ORDER BY revision_id desc" -} db_multirow -extend { item_url } revisions task_revisions_query { } { @@ -172,12 +179,16 @@ start_date {orderby start_date} end_date {orderby end_date} } \ + -orderby_name orderby_consts \ -filters { - task_revision_id + task_revision_id {} + orderby_revisions {} + orderby_consts2 {} + } \ + -html { + width 100% } -set orderby_consts_clause "ORDER BY task_title" - db_multirow -extend { item_url } consts consts_query { } { set item_url [export_vars -base "task-one" -override {{task_id $parent_task_id}} { task_id }] @@ -229,13 +240,17 @@ start_date {orderby start_date} end_date {orderby end_date} } \ + -orderby_name orderby_consts2 \ -filters { - task_revision_id + task_revision_id {} + orderby_revisions {} + orderby_consts {} + } \ + -html { + width 100% } -set orderby_consts2_clause "ORDER BY task_title" - db_multirow -extend { item_url } consts2 consts2_query { } {