| |
Results |
|
UsersSkills.xml
|
SELECT ID TS_ID, UUID TS_UUID , NAME TS_NAME, SKILLLEVEL TS_SKILLLEVEL, DESCRIPTION TS_DESCRIPTION from RSM_SKILL where NAMESPACEID={namespaceID}
|
|
|
|
ReleasePackageFromManualTask_v8-Oracle.xml
|
SELECT TRM_RLM_DEPLOY_TASKS.TS_ISSUEID AS TS_ID, SYS_GUID() as TS_UUID , TRM_RLM_TURNOVERS.TS_ID
|
|
|
LinkRPtoManualTask_v12-Oracle.xml
|
SELECT ROW_NUMBER() over(order by TaskExecution.ID ASC) TS_ID, SYS_GUID() TS_UUID , ManualTask.TS_ID TS_ManualTaskID, COALESCE(dbms_lob.substr(ManualTask.TS_TITLE, dbms_lob.getLength(ManualTask.TS_TITLE),
|
|
|
|
ReleasePackageFromManualTask_v6-SQL.xml
|
SELECT TRM_RLM_DEPLOY_TASKS.TS_ISSUEID AS TS_ID, NEWID() as TS_UUID , TRM_RLM_TURNOVERS.TS_ID AS TS_ReleasePackageID, TRM_RLM_TURNOVERS.TS_ISSUEID AS TS_ReleasePackageIssueID, TRM_RLM_TURNOVERS.TS_TITLE AS TS_ReleasePackageTitle, TRM_RLM_DEPLOY_TASKS.
|
|
|
|
IntegrationLinkToRLC_Oracle_v10.xml
|
SELECTROW_NUMBER() over(order by TaskExecution.ID ASC) TS_ID, SYS_GUID() TS_UUID , ReleasePackage.TS_ID TS_ReleasePackageID, COALESCE(dbms_lob.substr(ReleasePackage.TS_TITLE, dbms_lob.getLength(ReleasePackage.TS_TITLE), 1),'0') TS_ReleasePackageTitle, COALESCE
|
|
|
|
LinkReleasePackageToManualTask_v4-SQL.xml
|
SELECTROW_NUMBER() over(order by TaskExecution.ID ASC) TS_ID, NEWID() as TS_UUID , ManualTask.TS_ID TS_ManualTaskID, ManualTask.TS_TITLE TS_ManualTaskTitle, CASE WHEN ManualTask.TS_ACTIVEINACTIVE = '0' THEN 'Active' ELSE 'Inactive' END TS_TaskActiveInactive, ReleasePackage.TS_ID TS_
|
|
|
|
RLC_Request_List.xml
|
SELECT ROW_NUMBER() over(order by rp.ts_title ASC) as TS_ID, NEWID() TS_UUID , RP.TS_ID TS_RPID, RP.TS_TITLE TS_TITLE, RP.TS_RLM_LAST_DEPLOYMENT_DATE TS_DEPLOY_DATE, RP.TS_ISSUEID TS_ISSUEID, USERS.
|
|
|
|
RLC_RP_Attached_To_Request.xml
|
SELECT RP.TS_ID TS_ID, RP. TS_UUID TS_UUID , RP.TS_TITLE TS_TITLE, RP.TS_RLM_LAST_DEPLOYMENT_DATE TS_DEPLOY_DATE, RP.TS_ISSUEID TS_ISSUEID, RQ.REQUEST_ID TS_REQUEST_ID, RQ.TITLE TS_REQUEST_TITLE, USERS
|
|
|
|
RLCDuForEnvironment.xml
|
select DE.ID TS_ID, DE.ID TS_UUID , DE.TITLE TS_DU_TITLE, DE.TYPE TS_DU_TYPE, DE.PROVIDER_INSTANCE_NAME TS_CONFIGURATION, RP.TS_TITLE TS_RP_TITLE, AR.TS_TITLE TS_RP_APPLICATION_RELEASE, APP.TS_TITLE TS_
|
|
|
|
RLCDuByEngineer.xml
|
SELECT DUE.ID TS_ID, DUE.ID TS_UUID , DUE.TITLE TS_DU_TITLE, TE.STATE TS_TE_STATE, TE.PROVIDER_INSTANCE_NAME TS_TE_CONFIGURATION, TCE.START_TIME TS_TCE_START, TCE.END_TIME TS_TCE_END, RENV.NAME TS_ENVIRONMENT,
|
|
|
|
