OpenACS / openacs-4 / packages / bug-tracker / tcl

bug-procs-postgresql.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 10
Last Commit: 05 Apr
Commits this week: 0
Total Lines of Code (LoC): 43
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 5 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 23 Nov 2017
5:41 pm

antoniop

Reduce divergencies between oracle and postgres codebase, replace queries with proper api, exploit on delete cascade

Options
    • -204
    • +8
    ./bug-procs-postgresql.xql
  2. … 3 more files in changeset.
Wednesday 06 Jul 2016
11:01 am

gustafn

- reduce the dependencies on acs_object_party_privilege_map for PostgreSQL

Options
    • -1
    • +7
    ./bug-procs-postgresql.xql
  2. … 2 more files in changeset.
Thursday 17 Jun 2010
8:51 pm

ryang

Optionally display only the bugs the user is participating in.

Options
    • -3
    • +3
    ./bug-procs-postgresql.xql
  2. … 14 more files in changeset.
Thursday 19 Jun 2008
4:47 am

ryang

Fix broken list filtering.

Options
    • -1
    • +2
    ./bug-procs-postgresql.xql
Thursday 01 Dec 2005
2:25 pm

eduardop

fix date format to be ISO 8601 in preparation to date/time localization

Options
    • -4
    • +4
    ./bug-procs-postgresql.xql
  2. … 4 more files in changeset.
2:25 pm

eduardop

fix date format to be ISO 8601 in preparation to date/time localization

Options
    • -4
    • +4
    ./bug-procs-postgresql.xql
  2. … 5 more files in changeset.
2:25 pm

eduardop

fix date format to be ISO 8601 in preparation to date/time localization

Options
    • -4
    • +4
    ./bug-procs-postgresql.xql
  2. … 5 more files in changeset.
Thursday 24 Feb 2005
2:32 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20050111 and jcd-merge-5-1-20050224

Options
    • -60
    • +54
    ./bug-procs-postgresql.xql
  2. … 321 more files in changeset.
Thursday 27 Jan 2005
3:29 am

donb

Added a whole shitpile of caching to speed things up

Options
    • -54
    • +0
    ./bug-procs-postgresql.xql
  2. … 7 more files in changeset.
Sunday 23 Jan 2005
1:21 am

donb

We can further simplify the display query when using the paginator because

we don't need to include the filter clauses that are used to restrict the

rows returned. The paginator returns a list of ids that have already been

so restricted so the filter clauses are redundant in the display query.

Options
    • -1
    • +0
    ./bug-procs-postgresql.xql
  2. … 1 more file in changeset.
1:12 am

donb

Switched views for filtered queries that return a bug assigned to a

particular user. The workflow views invoked in these queries simply

do not scale well. This needs to be addressed fundamentally in workwflow

at some point but hacking bug-tracker seems easiest for now.

Options
    • -5
    • +6
    ./bug-procs-postgresql.xql
  2. … 2 more files in changeset.
Saturday 22 Jan 2005
12:35 am

donb

Finally figured out the obnoxious main query and rewrote the pagination

query to match my new understanding ...

Options
    • -61
    • +36
    ./bug-procs-postgresql.xql
  2. … 1 more file in changeset.
Thursday 20 Jan 2005
3:11 am

donb

Added per-instance list builder caching ...

Options
    • -0
    • +2
    ./bug-procs-postgresql.xql
  2. … 4 more files in changeset.
Friday 14 Jan 2005
2:46 am

donb

Ahem. Pagination might work now ... it didn't really before.

Options
    • -0
    • +71
    ./bug-procs-postgresql.xql
  2. … 2 more files in changeset.
Thursday 13 Jan 2005
2:54 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

Options
    • -4
    • +4
    ./bug-procs-postgresql.xql
  2. … 2275 more files in changeset.
Wednesday 10 Nov 2004
7:43 pm

maltes

Removed one join with acs_users_all that was unnecessary. Removed on call of acs_users_all and replaced with persons. Works now for openacs.org

Options
    • -5
    • +4
    ./bug-procs-postgresql.xql
Monday 26 Jul 2004
3:10 pm

jeffd

search and syndication for bugs

Options
    • -2
    • +2
    ./bug-procs-postgresql.xql
  2. … 3 more files in changeset.
Friday 04 Jun 2004
1:36 am

jeffd

There was an extra acs_users_all assignee join in the first part of

the query which caused the set of returned rows to be the cartesian

product of the bugs X keywords X users on system = very very slow

for anything more than a trivial number of users.

It still returns bugs x keywords rows which is not great but seems tolerable.

Options
    • -1
    • +0
    ./bug-procs-postgresql.xql
  2. … 1 more file in changeset.
Monday 17 May 2004
5:14 pm

jeffd

merge changes on oacs-5-1 branch to head, changes between jcd-merge-20040420 and jcd-merge-5-1-20040517 were merged, head pre changes is jcd-merge-pre-20040517 and post is jcd-merge-post-20040517

Options
    • -41
    • +77
    ./bug-procs-postgresql.xql
  2. … 834 more files in changeset.
Thursday 29 Apr 2004
12:36 pm

lars

Merged changes on oacs-5-0 branch from jcd-504-merge to lars-504-2-merge (changes made since 5.0.4 release) onto oacs-5-1 branch

Options
    • -41
    • +77
    ./bug-procs-postgresql.xql
  2. … 5 more files in changeset.
10:22 am

lars

Lower instead of upper

Options
    • -4
    • +4
    ./bug-procs-postgresql.xql
  2. … 2 more files in changeset.
10:13 am

lars

Fixed bug with sorting bugs list

Options
    • -1
    • +6
    ./bug-procs-postgresql.xql
  2. … 2 more files in changeset.
Tuesday 16 Mar 2004
3:40 pm

bdolicki

Adding a column to the bug list showing who is assigned to which bug.

Options
    • -39
    • +71
    ./bug-procs-postgresql.xql
  2. … 2 more files in changeset.
Wednesday 28 Jan 2004
10:45 am

peterm

in the bug listing query, setting parent_enabled_action_id to null in where clause to only get top workflows

Options
    • -0
    • +1
    ./bug-procs-postgresql.xql
  2. … 1 more file in changeset.
Friday 03 Oct 2003
6:54 pm

lars

Unassigned query not ported to PG

Options
    • -0
    • +11
    ./bug-procs-postgresql.xql
  2. … 3 more files in changeset.
Sunday 28 Sep 2003
3:28 am

lars

Using list builder for bug listing

Options
    • -0
    • +138
    ./bug-procs-postgresql.xql
  2. … 24 more files in changeset.
Wednesday 05 Mar 2003
7:12 pm

lars

Merged over latest version from HEAD

Options
    • -0
    • +0
    ./bug-procs-postgresql.xql
  2. … 114 more files in changeset.
6:39 pm

lars

Latest version of bug-tracker/ticket-tracker, using workflow

Options
    • -75
    • +24
    ./bug-procs-postgresql.xql
  2. … 114 more files in changeset.
Monday 13 Jan 2003
4:25 pm

lars

Cleaned up bug.tcl page, now using new form builder enhancements

Options
    • -0
    • +104
    ./bug-procs-postgresql.xql
  2. … 10 more files in changeset.