• last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

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. 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.

    • -14
    • +12
    ./tcl/workflow-procs-postgresql.xql
  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.

    • -11
    • +1
    ./sql/oracle/workflow-case-package.sql
  1. … 5 more files in changeset.
initial revision of acs-workflow-4.3

    • -1
    • +1
    ./sql/postgresql/upgrade-4.1.1-4.3.sql
initial revision of acs-workflow-4.3

    • -1
    • +1
    ./sql/postgresql/upgrade-4.1.1-4.3.sql
initial revision of acs-workflow-4.3

    • -2
    • +2
    ./sql/postgresql/upgrade-4.1.1-4.3.sql
initial revision of acs-workflow-4.3

  1. … 1 more file in changeset.
initial revision of acs-workflow-4.3

  1. … 20 more files in changeset.
initial revision of acs-workflow-4.3

    • -0
    • +697
    ./sql/postgresql/upgrade/upgrade-4.1.1-4.3.sql
    • -205
    • +665
    ./tcl/workflow-procs-oracle.xql
    • -220
    • +615
    ./tcl/workflow-procs-postgresql.xql
    • -497
    • +1030
    ./tcl/workflow-procs.tcl
  1. … 220 more files in changeset.
initial revision of acs-workflow-4.3

    • -114
    • +197
    ./sql/oracle/sample-article-create.sql
    • -121
    • +292
    ./sql/oracle/sample-expenses-create.sql
    • -0
    • +541
    ./sql/oracle/upgrade-4.1.1-4.3.sql
    • -0
    • +46
    ./sql/oracle/wf-callback-package-body.sql
    • -0
    • +34
    ./sql/oracle/wf-callback-package-head.sql
    • -55
    • +3
    ./sql/oracle/wf-callback-package.sql
    • -297
    • +410
    ./sql/oracle/wf-core-create.sql
    • -0
    • +1973
    ./sql/oracle/workflow-case-package-body.sql
  1. … 137 more files in changeset.

Had to declare v_request_id ...

    • -1
    • +2
    ./sql/postgresql/sample-article-create.sql

A variety of minor fixes ...

    • -3
    • +2
    ./sql/oracle/sample-article-create.sql
  1. … 3 more files in changeset.
fixed typo

    • -2
    • +2
    ./sql/postgresql/sample-article-create.sql
moved notification call into callback routine

    • -1
    • +24
    ./sql/oracle/sample-article-create.sql
    • -9
    • +23
    ./sql/oracle/workflow-case-package.sql
    • -1
    • +22
    ./sql/postgresql/sample-article-create.sql
    • -9
    • +19
    ./sql/postgresql/workflow-case-package.sql
reset party_from to -1

    • -2
    • +2
    ./sql/oracle/workflow-case-package.sql
    • -8
    • +2
    ./sql/postgresql/workflow-case-package.sql
fixed incompatiblity in workflow due to changing from acs-notifications to acs-mail

    • -4
    • +10
    ./sql/oracle/workflow-case-package.sql
  1. … 8 more files in changeset.
restored oracle version of test script

fixed display of CR file content in oracle

    • -2
    • +8
    ./sql/postgresql/workflow-case-package.sql
  1. … 8 more files in changeset.
removed another vestige of acs-notification

    • -19
    • +1
    ./sql/postgresql/workflow-case-package.sql
more cleanup of oracle cursors and cms porting work

    • -1
    • +12
    ./sql/oracle/workflow-case-package.sql
  1. … 9 more files in changeset.

1. Straightened out some dependencies that resulted from Dan's moving of

cms workflow from acs-content-repository to the cms, i.e. where it

belongs.

2. Made the default severity in apm_callback_and_log "debug" rather than

"notice".

3. fixed toggle-inherit for Oracle.

  1. … 7 more files in changeset.
fixed cursors that were not being closed in the core

    • -1
    • +3
    ./sql/oracle/workflow-case-package.sql
  1. … 1 more file in changeset.
removed requirement on acs-notifications

    • -2
    • +1
    ./sql/oracle/workflow-case-package.sql
    • -2
    • +1
    ./sql/postgresql/workflow-case-package.sql
  1. … 5 more files in changeset.
converted notification calls to acs_mail_nt calls

    • -12
    • +3
    ./sql/oracle/workflow-case-package.sql
    • -11
    • +9
    ./sql/postgresql/workflow-case-package.sql
  1. … 7 more files in changeset.

1. Added a check that PG was initdb's with the collation order for

characters that we expect.

2. Jon added a "sql/common" directory for the insert statements which

load data for acs-references, so I added a new datamodel type "common"

to the APM.

3. Created a new db API routine that returns true if a given db_type is

compatible with the current RDBMS.

4. Added a workaround for a PL/pgSQL "execute" bug in acs-workflow (other

cases had been fixed previously by others but this one was missed)

5. Diddled a couple of .info files using the APM.

    • -2
    • +4
    ./sql/postgresql/workflow-case-package.sql
  1. … 10 more files in changeset.
cleanup

removed cancel and resume links from cases that are finished - use of these links throws an error

fixed oracle db api so that db_exec_plsql command would still work after the passed in sql query is converted to an empty string

  1. … 1 more file in changeset.
fixed outer join query

    • -5
    • +5
    ./www/admin/static-assignments-postgresql.xql