ACE
  1. ACE
  2. ACE-608

board caption need to be reviewed in the invBoard view

      Details

      • Type: Task Task
      • Status: Done Done (View Workflow)
      • Priority: Normal 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

          Ascending order - Click to sort in descending order
          Nouha Mhadhbi made changes -
          Field Original Value New Value
          Gantt Options Milestone (set to milestone: having a due date but zero effort)
          Planned Start 2026-03-25 24:00 (milestone: set planned start date to due date)
          Planned End 2026-03-25 24:00 (milestone: set planned end date to due date)
          Permalink
          Nouha Mhadhbi logged work - 09/Mar/26 12:00 AM - edited
          • Time Spent:
            4 hours
             

            update UCMDB_NODE_BOARD_VW & UCMDB_TRANSMISSIONLINK_VW to make boardcaption matches swing code-full details in comments section

          Nouha Mhadhbi made changes -
          Summary board caption need to be reviewed in the invBoardview board caption need to be reviewed in the invBoard view
          Nouha Mhadhbi made changes -
          Status To Do [ 10001 ] In Progress [ 3 ]
          Nouha Mhadhbi made changes -
          Remaining Estimate 0 minutes [ 0 ]
          Time Spent 4 hours [ 14400 ]
          Worklog Id 293513 [ 293513 ]
          Nouha Mhadhbi made changes -
          Baseline Start 2026-03-25 24:00 (set baseline based of initial work logging)
          Baseline End 2026-03-25 24:00 (set baseline based of initial work logging)
          Hide
          Permalink
          Nouha Mhadhbi added a comment -

          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

          Show
          Nouha Mhadhbi added a comment - 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
          Nouha Mhadhbi made changes -
          Worklog Id 293513 [ 293513 ]
          Nouha Mhadhbi made changes -
          Status In Progress [ 3 ] Done [ 10000 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          To Do To Do In Progress In Progress
          		12d 3h 33m 1 Nouha Mhadhbi 09/Mar/26 10:05 AM
          In Progress In Progress Done Done
          		4h 8m 1 Nouha Mhadhbi 09/Mar/26 2:13 PM
          Subversion JIRA

          Links Hierarchy

          		  Documentation

          Invalid license: EXPIRED

          Cancel

            People

            • Assignee:
              Nouha Mhadhbi
              Reporter:
              Bessem Manita
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Planned Start:
                Planned End:
                Actual Start:
                Date of Baselining:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 4 hours
                4h

                  Drag and Drop