• last updated 15 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
added file_size to pg datamodel, pg queries. Moved calc (size = bytes/1024) from tcl to sql

Added db_map for oracle-specific partial queries.

Fixed problem caused by dimensional being used twice (renamed to

dimensional_html)

Fixed problem that had set archive_type_id to 'All' (not an integer)

aD used the var 'dimensional' in a query and then reassigned it, so when

the query dispatcher tries to acces 'dimensional', it accesses the wrong

one. renamed the second use to dimensional_html

added partial queries

Added partial queries

more workflow fixup

more workflow cleanup

  1. … 4 more files in changeset.
updated date types to timestamp, eliminated nvl

Port queries/query extractor output

    • -100
    • +10
    /openacs-4/packages/acs-subsite/tcl/package-procs.xql
  1. … 166 more files in changeset.
initial version

more debugging of workflow

fixed up wf after initial testing

  1. … 3 more files in changeset.
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.