L3 Support
  1. L3 Support
  2. LS-386

Update on INVENTORYREPORTVIEW

        Details

        • Type: CR CR
        • Status: Closed Closed (View Workflow)
        • Priority: Urgent Urgent
        • Resolution: Fixed
        • Component/s: NEP
        • Labels:
          None Labels
        • Customer:
          Zain KSA 3.X
        • Complexity:
          Medium

          Description

          Update the database view to consider the below:

          • ACTUAL_SITE: this column is the site name; it has to be deduced from the additional info Actual Site of the parent NE. if no additional info, keep using the site name. (Confirm the exact name of additional info with support or AI team)
          • DUMPS_SERIAL_NUMBER:
          • The view shall contain in addition to Cabinet, Shelf, Board:
            • Transceivers (Node interface having transceivers)
            • Radio antennas

            Activity

            Ascending order - Click to sort in descending order
            Permalink
            Diana Hamdouche logged work - 16/May/25 12:00 AM
            • Time Spent:
              1 day
               

              .

            Hassan Abdine made changes -
            Field Original Value New Value
            Gantt Options Milestone (set to milestone: having a due date but zero effort)
            Planned Start 2025-05-19 24:00 (milestone: set planned start date to due date)
            Planned End 2025-05-19 24:00 (milestone: set planned end date to due date)
            Hassan Abdine made changes -
            Description Update the database view to consider the below:

            * *ACTUAL_SITE*: this column is the site name; it has to be deduced from the additional info *Actual Site* of the parent NE. if no additional info, keep using the site name.

            * The view shall contain in addition to Cabinet, Shelf, Board:
            ** Transceivers (Node interface having transceivers)
            ** Radio antennas
            Hassan Abdine made changes -
            Description Update the database view to consider the below:

            * *ACTUAL_SITE*: this column is the site name; it has to be deduced from the additional info *Actual Site* of the parent NE. if no additional info, keep using the site name.

            * The view shall contain in addition to Cabinet, Shelf, Board:
            ** Transceivers (Node interface having transceivers)
            ** Radio antennas             		Update the database view to consider the below:

            * *ACTUAL_SITE*: this column is the site name; it has to be deduced from the additional info *Actual Site* of the parent NE. if no additional info, keep using the site name. (Confirm the exact name of additional info with support or AI team)

            * The view shall contain in addition to Cabinet, Shelf, Board:
            ** Transceivers (Node interface having transceivers)
            ** Radio antennas
            Khaled Khalil made changes -
            Assignee Khaled Khalil [ kkhalil ] Diana Hamdouche [ dhamdouche ]
            Hassan Abdine made changes -
            Description Update the database view to consider the below:

            * *ACTUAL_SITE*: this column is the site name; it has to be deduced from the additional info *Actual Site* of the parent NE. if no additional info, keep using the site name. (Confirm the exact name of additional info with support or AI team)

            * The view shall contain in addition to Cabinet, Shelf, Board:
            ** Transceivers (Node interface having transceivers)
            ** Radio antennas             		Update the database view to consider the below:

            * *ACTUAL_SITE*: this column is the site name; it has to be deduced from the additional info *Actual Site* of the parent NE. if no additional info, keep using the site name. (Confirm the exact name of additional info with support or AI team)

            * *DUMPS_SERIAL_NUMBER*:

            * The view shall contain in addition to Cabinet, Shelf, Board:
            ** Transceivers (Node interface having transceivers)
            ** Radio antennas
            Permalink
            Diana Hamdouche logged work - 19/May/25 12:00 AM
            • Time Spent:
              1 day
               

              .

            made changes -
            Attachment 20250519_UPDATE_INVENTORYREPORTVIEW.zip [ 109307 ]
            Hide
            Permalink
            added a comment -

            Please find attached a zip folder containing a script to update "INVENTORYREPORTVIEW" as required
            You should replace “PUT REQUIRED VERSION NAME HERE” with the appropriate version name.

            Show
            added a comment - Please find attached a zip folder containing a script to update "INVENTORYREPORTVIEW" as required You should replace “PUT REQUIRED VERSION NAME HERE” with the appropriate version name.
            Diana Hamdouche made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 1 day [ 28800 ]
            Worklog Id 267403 [ 267403 ]
            Diana Hamdouche made changes -
            Baseline Start 2025-05-19 24:00 (set baseline based of initial work logging)
            Baseline End 2025-05-19 24:00 (set baseline based of initial work logging)
            Diana Hamdouche made changes -
            Time Spent 1 day [ 28800 ] 2 days [ 57600 ]
            Worklog Id 267404 [ 267404 ]
            Hide
            Permalink
            added a comment -

            Applied on PROD

            Show
            added a comment - Applied on PROD
            Abir Messaikeh made changes -
            Status Opened [ 1 ] Pending Requirements [ 10300 ]
            Abir Messaikeh made changes -
            Status Pending Requirements [ 10300 ] Pending Design Session [ 10112 ]
            Assignee Diana Hamdouche [ dhamdouche ] Khaled Khalil [ kkhalil ]
            Abir Messaikeh made changes -
            Status Pending Design Session [ 10112 ] Dev Scheduled [ 10014 ]
            Abir Messaikeh made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Assignee Khaled Khalil [ kkhalil ] Abir Messaikeh [ amessaikeh ]
            Abir Messaikeh made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Abir Messaikeh made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Abir Messaikeh [ amessaikeh ] Hassan Abdine [ habdine ]
            Abir Messaikeh made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Assignee Hassan Abdine [ habdine ] Abir Messaikeh [ amessaikeh ]
            Abir Messaikeh made changes -
            Status QA In Progress [ 10015 ] Closed [ 6 ]
            Resolution Fixed [ 1 ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Opened Opened Pending Requirements Pending Requirements
            		5d 2h 40m 1 Abir Messaikeh 21/May/25 8:33 AM
            Pending Requirements Pending Requirements Pending Design Session Pending Design Session
            		9s 1 Abir Messaikeh 21/May/25 8:33 AM
            Pending Design Session Pending Design Session Dev Scheduled Dev Scheduled
            		9s 1 Abir Messaikeh 21/May/25 8:34 AM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		3s 1 Abir Messaikeh 21/May/25 8:34 AM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		6s 1 Abir Messaikeh 21/May/25 8:34 AM
            To Be Released To Be Released Ready for QA Ready for QA
            		3s 1 Abir Messaikeh 21/May/25 8:34 AM
            Ready for QA Ready for QA QA In Progress QA In Progress
            		13s 1 Abir Messaikeh 21/May/25 8:34 AM
            QA In Progress QA In Progress Closed Closed
            		7s 1 Abir Messaikeh 21/May/25 8:34 AM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

              • Assignee:
                Abir Messaikeh
                Reporter:
                Hassan Abdine
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:
                  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 - 2 days
                  2d

                    Drag and Drop