/usr/share/gforge/db/view_bug.sql is in gforge-db-postgresql 5.3.2+20141104-3+deb8u3.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | DROP VIEW bug;
CREATE VIEW bug AS
SELECT a.artifact_id AS bug_id,
g.group_id,
a.status_id,
a.priority,
a.category_id,
a.submitted_by,
a.assigned_to,
a.open_date,
a.summary,a.details,
a.close_date,
a.group_artifact_id AS bug_group_id,
a.resolution_id AS resolution
FROM artifact a, groups g, artifact_group_list agl
WHERE a.group_artifact_id=agl.group_artifact_id
AND agl.group_id=g.group_id
AND agl.name='Bugs';
|