Deployment dashboard requesting REQUIREMENT_SET and NOTIFICATION_SETS

XMLWordPrintable

    • 0
    • 3

      Summary

      When visiting http://localhost:8085/deploy/viewAllDeploymentProjects.action, Bamboo runs a SQL statement joining 2 tables (REQUIREMENT_SET and NOTIFICATION_SETS) that should not be required by the view.

      SQL statement

      select this_.ENVIRONMENT_ID as ENVIRONM1_27_3_
	, this_.NAME as NAME2_27_3_
	, this_.DESCRIPTION as DESCRIPT3_27_3_
	, this_.XML_DEFINITION_DATA as XML_DEFI4_27_3_
	, this_.TRIGGERS_XML_DATA as TRIGGERS5_27_3_
	, this_.CONFIGURATION_STATE as CONFIGUR6_27_3_
	, this_.PACKAGE_DEFINITION_ID as PACKAGE_7_27_3_
	, this_.REQUIREMENT_SET as REQUIREM8_27_3_
	, this_.NOTIFICATION_SET as NOTIFICA9_27_3_
	, this_.LIST_POSITION as LIST_PO10_27_3_
	, mutabledep2_.DEPLOYMENT_PROJECT_ID as DEPLOYME1_29_0_
	, mutabledep2_.OID as OID2_29_0_
	, mutabledep2_.NAME as NAME3_29_0_
	, mutabledep2_.DESCRIPTION as DESCRIPT4_29_0_
	, mutabledep2_.PLAN_KEY as PLAN_KEY5_29_0_
	, requiremen3_.REQUIREMENT_SET_ID as REQUIREM1_70_1_
	, notificati4_.NOTIFICATION_SET_ID as NOTIFICA1_55_2_
	, notificati4_.SET_TYPE as SET_TYPE2_55_2_
  from DEPLOYMENT_ENVIRONMENT this_ 
  left outer join DEPLOYMENT_PROJECT mutabledep2_ on this_.PACKAGE_DEFINITION_ID=mutabledep2_.DEPLOYMENT_PROJECT_ID 
  left outer join REQUIREMENT_SET requiremen3_ on this_.REQUIREMENT_SET=requiremen3_.REQUIREMENT_SET_ID 
  left outer join NOTIFICATION_SETS notificati4_ on this_.NOTIFICATION_SET=notificati4_.NOTIFICATION_SET_ID

      Environment

      • Tested on Bamboo v5.15.5 connected to PostgreSQL
      • Tested on Bamboo v6.1.1 connected to PostgreSQL

      Steps to Reproduce

            Assignee:
            Unassigned
            Reporter:
            Rafael Sperafico (Inactive)
            Votes:
            5 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: