File: view_patch.sql

package info (click to toggle)
fusionforge 5.3.2%2B20141104-3
  • links: PTS, VCS
  • area: main
  • in suites: jessie-kfreebsd
  • size: 60,472 kB
  • sloc: php: 271,846; sql: 36,817; python: 14,575; perl: 6,406; sh: 5,980; xml: 4,294; pascal: 1,411; makefile: 911; cpp: 52; awk: 27
file content (18 lines) | stat: -rw-r--r-- 439 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
DROP VIEW patch;
CREATE VIEW patch AS
	SELECT a.artifact_id AS patch_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 patch_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='Patches';