• last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
fixed more queries

fixed sequences. Updated functions. Improved drop script

changed to consistent sequence names

initial testing and debug work

added query files for main workflow page

Fix queries

fixed up package display to work with postgresql

files no lnger applicable

added new query files used for moving scheduling from oracle to aolserver

Built two query snippets using "db_map". They weren't db specific so we

now have a generic index.xql file...

cleanup

added oracle query

moved scheduling to aolserver

catchall

Initial Revision

    • -0
    • +130
    /openacs-4/packages/acs-mail/tcl/acs-mail-procs.xql
Fixed pl/sql and outer join

moved content repository job scheduling from oracle to aolsrver, that it is compatible with postgresql

Added calls to Dan's new "db_map" routine to make db-specific queries in

the apm index page work.

Initial Revision

    • -0
    • +203
    /openacs-4/packages/acs-mail/tcl/acs-mail-procs-oracle.xql
Initial Revision

fixed permissions problem for handling insertion of dup index values

fixed up a few queries that I missed on the initial porting pass

fixed dynmic query using new db_map command

added uplevel subst to db_map command

cleanup

cleaned up content repository data-model and converted oracle apm to use file storage in the content repository

added new db_map command for generating query snippets

ported complex search using new db_map command for generating query snippets

Just what it says ...

initial porting of queries