Details
-
Type:
Task
-
Status:
Done
(View Workflow)
-
Priority:
Normal
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: UCMDB
-
Labels:None Labels
-
Customer:Mobinets
-
Complexity:High
Description
Click to add description
Activity
- All
- Comments
- Work Log
- History
- Activity
- Links Hierarchy
- Transitions
- Trace
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