[ACE-608] board caption need to be reviewed in the invBoard view Created: 25/Feb/26  Updated: 09/Mar/26  Due: 25/Mar/26

Status: Done
Project: ACE
Component/s: UCMDB
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Normal
Reporter: Bessem Manita Assignee: Nouha Mhadhbi
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: 0 minutes
Time Spent: 4 hours
Original Estimate: Not Specified

Customer:
Mobinets
Planned Start:
Planned End:
Complexity: High
Actual Start:
Date of Baselining:

 Comments   
Comment by Nouha Mhadhbi [ 09/Mar/26 ]

Hi
Refactored board caption generation in database views to match the legacy Swing getBoardCaption() logic and ensure consistent captions across modules.

Implemented dynamic caption rules in UCMDB_NODE_BOARD_VW using SQL CASE logic instead of the previous static concatenation.

Key rules implemented:

WDM + Alcatel-Lucent
boardType shelf/slot
boardType shelf/slot/index (only when index > 0, bug fixed)

ADM + Huawei
slot-boardType
slot-index-boardType

IDU + Huawei
boardType slot-boardType
slot-index-boardType

IDU + Ericsson
boardType shelf/slot
boardType shelf/slot+protectionSlot

Router + Huawei
boardType slot/index

Router + Cisco
boardType slot
boardType slot/index

Default rule

if cabinet != 1 OR shelf != 1 →
boardType cabinet/shelf/slot/index

otherwise →
boardType slot or boardType slot/index

Also implemented the Swing logic equivalent of
getBoard(-1, slot, shelf, cabinet) to detect -1 index boards.

Updated UCMDB_TRANSMISSIONLINK_VW to reuse captions from UCMDB_NODE_BOARD_VW (board1.BOARD_CAPTION, board2.BOARD_CAPTION) instead of rebuilding them.

Views implemented for Oracle and MySQL with equivalent logic

Generated at Wed Apr 15 13:07:18 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.