v5.5.1

• Fix broken resource handling (#66)

Full Changelog: v5.5.0...v5.5.1

v5.5.0

What's Changed

• Show Event Type on Tune Report by @slominskir in #65

Full Changelog: v5.4.0...v5.5.0

v5.4.0

What's Changed

• Include event name in overlap message by @slominskir in #63
• Updated Beam Transport Category components list in test env to match production

Full Changelog: v5.3.0...v5.4.0

v5.3.0

What's Changed

• Core downtime reports type multi-select by @slominskir in #61
• Reports Weekly Tune and Tune Comparison now include multi-select type

Full Changelog: v5.2.0...v5.3.0

v5.2.0

• Subtract Tuning from Research

Full Changelog: v5.1.0...v5.2.0

v5.1.0

What's Changed

• Tuning in Joule by @slominskir in #59

Oracle DB Migration Notes

insert into dtm_owner.event_type (event_type_id, name, description, weight, abbreviation, archived_yn) values(9, 'CEBAF Tuning', 'CEBAF Tuning', 0, 'TUN', 'N');
insert into DTM_OWNER.TYPE_CATEGORY (EVENT_TYPE_ID, CATEGORY_ID) values (9, 381);

delete from DTM_OWNER.TYPE_CATEGORY where EVENT_TYPE_ID = 1 and CATEGORY_ID = 381;

Full Changelog: v5.0.2...v5.1.0

v5.0.2

• Honor component and system ARCHIVED_YN
• Events page filter beam transport using category (no longer system)
• Consolidate Events page filter/count logic
• Remove affected hall filtering on weekly repair report
• Remove all_components view, previously replaced with deleted_components view

Full Changelog: v5.0.1...v5.0.2

v5.0.1

• Missed some spots removing AffectedHall

Full Changelog: v5.0.0...v5.0.1

v5.0.0

What's Changed

• Remove affected program / affected hall by @slominskir in #57
• Bump Wildfly to v37 by @slominskir in #58
• Replace EternalComponent and EternalSystem with ARCHIVE_YN flag to satisfy Hibernate v6

Oracle DB Migration Notes

CREATE OR REPLACE VIEW DTM_OWNER.DELETED_COMPONENTS as
(
select distinct(component_id), name, system_id, region_id
from srm_owner.component_aud inner join srm_owner.application_revision_info using(rev)
where revtype = 2
);

create or replace view dtm_owner.component as
(
select component_id, name, system_id, region_id, 'N' as archived_yn from srm_owner.component where system_id in (select system_id from srm_owner.system_application where application_id = 2)
union select component_id, name, system_id, region_id, 'Y' as archived_yn from dtm_owner.deleted_components
);

create view DTM_OWNER.DELETED_SYSTEMS as
(
select distinct(system_id), name, category_id, weight, 'N' as srm_yn
from srm_owner.system_aud
         inner join srm_owner.application_revision_info using (rev)
where revtype = 2
);

create or replace view dtm_owner.system as
(
select SYSTEM_ID, NAME, CATEGORY_ID, WEIGHT, 'N' as ARCHIVED_YN,
CASE
  WHEN (select 'Y' from srm_owner.system_application where srm_owner.system_application.system_id = b.system_id and application_id = 1) IS NOT NULL THEN 'Y'
  ELSE 'N'
END as SRM_YN
from srm_owner.system b where system_id in (select system_id from srm_owner.system_application where application_id = 2)
  union select system_id, name, category_id, weight, 'Y' as archived_yn,  srm_yn from dtm_owner.deleted_systems
);

Full Changelog: v4.31.0...v5.0.0

v4.31.0

• Rename T&R to TSR (Joule)
• Research Y/N Renamed Program Physics/Internal
• NPES_SCHEDULE_URL moved to Settings DB Table

Oracle Migration Notes

insert into SETTING (KEY, VALUE, TYPE, DESCRIPTION, TAG, WEIGHT) values ('NPES_SCHEDULE_ENABLED', 'N', 'BOOLEAN', 'Query external NPES Schedule integration?', 'OTHER', 2);
insert into SETTING (KEY, VALUE, TYPE, DESCRIPTION, TAG, WEIGHT) values ('NPES_SCHEDULE_URL', 'https://ace.jlab.org/btm', 'STRING', 'NPES Schedule URL', 'OTHER', 3);

Full Changelog: v4.30.1...v4.31.0