• last updated 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
use ad_acs_kernel_id to get package_id

    • -2
    • +2
    ./ticket-tracker/www/admin/install/index.tcl
send the proper date format to ad_dateentrywidget

    • -1
    • +1
    ./ticket-tracker-lite/www/ticket-postgresql.xql
adjusted install sequence to use ad_parameter instead of checking db directly

    • -2
    • +2
    ./ticket-tracker/www/admin/install/index.adp
    • -20
    • +17
    ./ticket-tracker/www/admin/install/index.tcl
    • -8
    • +4
    ./ticket-tracker/www/admin/install/index.xql

There were some inconsistencies in the way return_url was being set up...

Small change to wf_task_panels ...

fix bug that didn't allow for null charters

    • -3
    • +1
    ./bboard/sql/oracle/bboard-packages.sql
make it obvious that null charters are allowed

fix bug to allow for null charters

fix bug that dosen't allow null charters

Added a new proc to return the panels associated with a workflow ...

    • -4
    • +26
    ./acs-workflow/tcl/workflow-procs.tcl
    • -1
    • +38
    ./acs-workflow/tcl/workflow-procs.xql

Removed references to jobs-start and jobs-kill (it's done in Tcl now)

Added a new function that returns the task_id for a particular case/taskkey.

The only way to get this (needed to fire a message transition) was for one's

client code to poke into the datamodel directly with a select.

    • -1
    • +20
    ./acs-workflow/sql/oracle/workflow-case-package-body.sql

1. Changed a couple of ns_schedule_proc calls to ad_schedule_proc.

2. Moved job scheduling for workflow from the db to tcl, because PG doesn't

support in-db job scheduling.

    • -29
    • +0
    ./acs-workflow/sql/oracle/jobs-kill.sql
    • -47
    • +0
    ./acs-workflow/sql/oracle/jobs-start.sql
    • -0
    • +16
    ./acs-workflow/tcl/workflow-procs-oracle.xql
    • -14
    • +12
    ./acs-workflow/tcl/workflow-procs-postgresql.xql
    • -1
    • +18
    ./acs-workflow/tcl/workflow-procs.tcl
  1. … 4 more files in changeset.

1. Removed call to "schedule_proc" in acs-workflow. It's no longer needed.

2. Changed admin UI so you can enter the sort order when adding or editing

places.

3. Duplicated Bart Teeuwisse's glossary changes for Oracle.

    • -0
    • +1
    ./acs-workflow/www/admin/place-add-2.tcl
    • -2
    • +2
    ./acs-workflow/www/admin/place-add-2.xql
    • -0
    • +5
    ./acs-workflow/www/admin/place-add.adp
    • -1
    • +2
    ./acs-workflow/www/admin/place-edit-2.tcl
    • -1
    • +2
    ./acs-workflow/www/admin/place-edit-2.xql
    • -1
    • +6
    ./acs-workflow/www/admin/place-edit.adp
    • -1
    • +1
    ./acs-workflow/www/admin/place-edit.xql
  1. … 5 more files in changeset.
fix "cellpadding" typo that was causing bboard message list table to be very cluttered.

Fixed some errors in my earlier hacking on hierarchical queries...

    • -1
    • +1
    ./bboard/www/message-threaded-postgresql.xql
  1. … 3 more files in changeset.

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

    • -3
    • +3
    ./bboard/tcl/bboard-procs-postgresql.xql
  1. … 17 more files in changeset.

Oops - I'd previously committed a query with a literal substituted for

:forum_id, done back when I was hacking these queries for greater efficiency

using real test data. I was using psql so I was using literal values...

Changed the representation of tree_sortkeys from "text" to "bit varying".

    • -5
    • +3
    ./bboard/tcl/bboard-procs-postgresql.xql
    • -3
    • +10
    ./bboard/www/message-delete-2-postgresql.xql
    • -3
    • +3
    ./bboard/www/message-move-2-postgresql.xql
  1. … 57 more files in changeset.

Changed to the new tree_sortkey comparison scheme. Mostly untested (yet)

will do so shortly!

    • -16
    • +12
    ./bboard/tcl/bboard-procs-postgresql.xql
    • -27
    • +16
    ./bboard/www/forum-postgresql.xql
    • -8
    • +3
    ./bboard/www/message-delete-2-postgresql.xql
    • -11
    • +6
    ./bboard/www/message-move-2-postgresql.xql
    • -7
    • +5
    ./bboard/www/message-threaded-postgresql.xql

1. Replaced more "tree_sortkey like" with "tree_sortkey between" expressions

2. Fixed a bad port of an Oracle query in site-nodes-procs.tcl and removed

a needless outer join from both versions in the process.

  1. … 11 more files in changeset.

Check the comments in postgresql.sql - my previous commit didn't quite work

as expected.

I also removed an ugly assumption made in the PG port in bboard-procs.tcl.

    • -5
    • +7
    ./bboard/tcl/bboard-procs-postgresql.xql
  1. … 1 more file in changeset.

Added "tree_left" and "tree_right" in order to optimize tree queries, which

I did for the bboard package. "LIKE (tree_sortkey || %)" never uses the

index as we thought it did, as it turns out ... see postgresql.sql for

example queries that do.

    • -1
    • +3
    ./bboard/sql/postgresql/bboard-create.sql
    • -3
    • +5
    ./bboard/sql/postgresql/bboard-views.sql
  1. … 1 more file in changeset.

First round of speedups for verious permissions issues. Key finding is that

the all_object_party_privilege_map is speedy in PostgreSQL and apparently in

Oracle, as well (having re-read some of the optimization threads).

    • -12
    • +16
    ./bboard/tcl/bboard-procs-postgresql.xql
    • -1
    • +1
    ./bboard/www/message-delete-2-oracle.xql
  1. … 18 more files in changeset.

Added a comment to this file ...

    • -1
    • +7
    ./bboard/sql/postgresql/bboard-views.sql

1. Fixed a boneheaded error in the bootstrapper: "AvailablePool" was being

submitted to a case-sensitive check. Of course AOLserver parameters are

case-insensitive.

2. A recently submitted patch to the db routine that PSQL's source broke

the code if you haven't started postmaster with the "-i" option.

3. Bboard was very, very slow in PG. It is now much faster.

    • -47
    • +13
    ./bboard/sql/postgresql/bboard-views.sql
  1. … 2 more files in changeset.
initial revision of acs-workflow-4.3

initial revision of acs-workflow-4.3

initial revision of acs-workflow-4.3

initial revision of acs-workflow-4.3