| Line 47... |
Line 47... |
| 47 |
" CQ_DEVI.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
|
47 |
" CQ_DEVI.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
|
| 48 |
" CQ_DEVI.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
|
48 |
" CQ_DEVI.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
|
| 49 |
" CQ_DEVI.admin.users ap ON si.approver = ap.dbid"&_
|
49 |
" CQ_DEVI.admin.users ap ON si.approver = ap.dbid"&_
|
| 50 |
" WHERE si.dbid = "& NNiss_id
|
50 |
" WHERE si.dbid = "& NNiss_id
|
| 51 |
|
51 |
|
| 52 |
ElseIf Cint(NNiss_db) = enumCLEARQUEST_VT5DM_ID Then
|
- |
|
| 53 |
SQLstr = _
|
- |
|
| 54 |
" SELECT si.dbid, si.new_num AS iss_num, si.headline AS summary, sdef.name AS status, si.priority AS priority, si.issue_type, si.release_part1, "&_
|
- |
|
| 55 |
" si.release_part2, si.release_part3, si.project, si.product AS product, si.package_ref AS package, sb.fullname AS submitter, si.submit_date, ow.fullname AS owner, "&_
|
- |
|
| 56 |
" ap.fullname AS approver, si.description"&_
|
- |
|
| 57 |
" FROM CQ_VT5DM.admin.software_issue si INNER JOIN"&_
|
- |
|
| 58 |
" CQ_VT5DM.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
|
- |
|
| 59 |
" CQ_VT5DM.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
|
- |
|
| 60 |
" CQ_VT5DM.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
|
- |
|
| 61 |
" CQ_VT5DM.admin.users ap ON si.approver = ap.dbid"&_
|
- |
|
| 62 |
" WHERE si.dbid = "& NNiss_id
|
- |
|
| 63 |
|
- |
|
| 64 |
End If
|
- |
|
| 65 |
|
- |
|
| 66 |
OOrsCQ.ActiveConnection = CQ_conn
|
52 |
OOrsCQ.ActiveConnection = CQ_conn
|
| 67 |
OOrsCQ.Source = SQLstr
|
53 |
OOrsCQ.Source = SQLstr
|
| 68 |
OOrsCQ.CursorType = 0
|
54 |
OOrsCQ.CursorType = 0
|
| 69 |
OOrsCQ.CursorLocation = 2
|
55 |
OOrsCQ.CursorLocation = 2
|
| 70 |
OOrsCQ.LockType = 3
|
56 |
OOrsCQ.LockType = 3
|
| 71 |
OOrsCQ.Open()
|
57 |
OOrsCQ.Open()
|
| 72 |
End Sub
|
58 |
End Sub
|
| 73 |
%>
|
59 |
%>
|
| 74 |
<%'If parIss_db <> enumCLEARQUEST_DEVI_ID AND parIss_db <> enumCLEARQUEST_VT5DM_ID Then Call RaiseMsg ( enum_WMSG_ERROR, "This option is not available for this issue's database!" )%>
|
- |
|
| 75 |
<%Call Get_Issue_Details (parIss_id, rsCQ )%>
|
60 |
<%Call Get_Issue_Details (parIss_id, rsCQ )%>
|
| 76 |
<!--#include file="_menu_def.asp"-->
|
61 |
<!--#include file="_menu_def.asp"-->
|
| 77 |
<html>
|
62 |
<html>
|
| 78 |
<head>
|
63 |
<head>
|
| 79 |
<title><%=rsCQ("iss_num")%> - <%=rsCQ("summary")%></title>
|
64 |
<title><%=rsCQ("iss_num")%> - <%=rsCQ("summary")%></title>
|