| Line 126... |
Line 126... |
| 126 |
|
126 |
|
| 127 |
|
127 |
|
| 128 |
'If CInt(NNiss_db) = enumCLEARQUEST_DEVI_ID Then
|
128 |
'If CInt(NNiss_db) = enumCLEARQUEST_DEVI_ID Then
|
| 129 |
' SQLstr = _
|
129 |
' SQLstr = _
|
| 130 |
' " SELECT si.dbid AS iss_id, si.new_num AS iss_num, si.headline AS summary, sd.NAME AS state"&_
|
130 |
' " SELECT si.dbid AS iss_id, si.new_num AS iss_num, si.headline AS summary, sd.NAME AS state"&_
|
| 131 |
' " FROM DEVI_PROD.admin.software_issue si,"&_
|
131 |
' " FROM CQ_DEVI.admin.software_issue si,"&_
|
| 132 |
' " DEVI_PROD.admin.STATEDEF sd"&_
|
132 |
' " CQ_DEVI.admin.STATEDEF sd"&_
|
| 133 |
' " WHERE si.STATE = sd.ID "
|
133 |
' " WHERE si.STATE = sd.ID "
|
| 134 |
|
134 |
|
| 135 |
'ElseIf ( CInt(NNiss_db) = enumCLEARQUEST_TDSE_ID) Then
|
135 |
'ElseIf ( CInt(NNiss_db) = enumCLEARQUEST_TDSE_ID) Then
|
| 136 |
' SQLstr = _
|
136 |
' SQLstr = _
|
| 137 |
' " SELECT si.dbid AS iss_id, si.job_number AS iss_num, si.problem_summary AS summary, sd.NAME AS state"&_
|
137 |
' " SELECT si.dbid AS iss_id, si.job_number AS iss_num, si.problem_summary AS summary, sd.NAME AS state"&_
|
| 138 |
' " FROM TDSE_2002.admin.request si, "&_
|
138 |
' " FROM CQ_TDSE.admin.request si, "&_
|
| 139 |
' " TDSE_2002.admin.STATEDEF sd"&_
|
139 |
' " CQ_TDSE.admin.STATEDEF sd"&_
|
| 140 |
' " WHERE si.STATE = sd.ID "
|
140 |
' " WHERE si.STATE = sd.ID "
|
| 141 |
|
141 |
|
| 142 |
'ElseIf ( CInt(NNiss_db) = enumCLEARQUEST_VT5DM_ID) Then
|
142 |
'ElseIf ( CInt(NNiss_db) = enumCLEARQUEST_VT5DM_ID) Then
|
| 143 |
' SQLstr = _
|
143 |
' SQLstr = _
|
| 144 |
' " SELECT si.dbid AS iss_id, si.new_num AS iss_num, si.headline AS summary, sd.NAME AS state"&_
|
144 |
' " SELECT si.dbid AS iss_id, si.new_num AS iss_num, si.headline AS summary, sd.NAME AS state"&_
|
| 145 |
' " FROM VT5DM.admin.software_issue si,"&_
|
145 |
' " FROM CQ_VT5DM..admin.software_issue si,"&_
|
| 146 |
' " VT5DM.admin.STATEDEF sd"&_
|
146 |
' " CQ_VT5DM..admin.STATEDEF sd"&_
|
| 147 |
' " WHERE si.STATE = sd.ID "
|
147 |
' " WHERE si.STATE = sd.ID "
|
| 148 |
|
148 |
|
| 149 |
'SQLstr = "SELECT * FROM JIRA.jirauser.jiraissue"
|
149 |
'SQLstr = "SELECT * FROM JIRA.jirauser.jiraissue"
|
| 150 |
|
150 |
|
| 151 |
Dim rsProjId, pkey
|
151 |
Dim rsProjId, pkey
|
| Line 296... |
Line 296... |
| 296 |
"AND I.issuestatus = ISS.ID "
|
296 |
"AND I.issuestatus = ISS.ID "
|
| 297 |
|
297 |
|
| 298 |
'If CInt(nIssDB) = enumCLEARQUEST_DEVI_ID Then
|
298 |
'If CInt(nIssDB) = enumCLEARQUEST_DEVI_ID Then
|
| 299 |
' SQLstr = _
|
299 |
' SQLstr = _
|
| 300 |
' " SELECT si.dbid, sd.name AS state_name, si.state AS state_id"&_
|
300 |
' " SELECT si.dbid, sd.name AS state_name, si.state AS state_id"&_
|
| 301 |
' " FROM DEVI_PROD.admin.software_issue si,"&_
|
301 |
' " FROM CQ_DEVI.admin.software_issue si,"&_
|
| 302 |
' " DEVI_PROD.admin.statedef sd"&_
|
302 |
' " CQ_DEVI.admin.statedef sd"&_
|
| 303 |
' " WHERE si.STATE = sd.ID"&_
|
303 |
' " WHERE si.STATE = sd.ID"&_
|
| 304 |
' " AND si.dbid IN ("& sIssIdList &")"
|
304 |
' " AND si.dbid IN ("& sIssIdList &")"
|
| 305 |
|
305 |
|
| 306 |
'ElseIf CInt(nIssDB) = enumCLEARQUEST_TDSE_ID Then
|
306 |
'ElseIf CInt(nIssDB) = enumCLEARQUEST_TDSE_ID Then
|
| 307 |
' SQLstr = _
|
307 |
' SQLstr = _
|
| 308 |
' " SELECT si.dbid, sd.name AS state_name, si.state AS state_id"&_
|
308 |
' " SELECT si.dbid, sd.name AS state_name, si.state AS state_id"&_
|
| 309 |
' " FROM TDSE_2002.admin.request si,"&_
|
309 |
' " FROM CQ_TDSE.admin.request si,"&_
|
| 310 |
' " TDSE_2002.admin.statedef sd"&_
|
310 |
' " CQ_TDSE.admin.statedef sd"&_
|
| 311 |
' " WHERE si.STATE = sd.ID"&_
|
311 |
' " WHERE si.STATE = sd.ID"&_
|
| 312 |
' " AND si.dbid IN ("& sIssIdList &")"
|
312 |
' " AND si.dbid IN ("& sIssIdList &")"
|
| 313 |
'ElseIf CInt(nIssDB) = enumCLEARQUEST_VT5DM_ID Then
|
313 |
'ElseIf CInt(nIssDB) = enumCLEARQUEST_VT5DM_ID Then
|
| 314 |
' SQLstr = _
|
314 |
' SQLstr = _
|
| 315 |
' " SELECT si.dbid, sd.name AS state_name, si.state AS state_id"&_
|
315 |
' " SELECT si.dbid, sd.name AS state_name, si.state AS state_id"&_
|
| 316 |
' " FROM VT5DM.admin.software_issue si,"&_
|
316 |
' " FROM CQ_VT5DM..admin.software_issue si,"&_
|
| 317 |
' " VT5DM.admin.statedef sd"&_
|
317 |
' " CQ_VT5DM..admin.statedef sd"&_
|
| 318 |
' " WHERE si.STATE = sd.ID"&_
|
318 |
' " WHERE si.STATE = sd.ID"&_
|
| 319 |
' " AND si.dbid IN ("& sIssIdList &")"
|
319 |
' " AND si.dbid IN ("& sIssIdList &")"
|
| 320 |
'
|
320 |
'
|
| 321 |
|
321 |
|
| 322 |
'End If
|
322 |
'End If
|