Details

    • Customer:
      OMAN-Tel
    • Complexity:
      Medium
    • Severity:
      Major
    • Product:
      NEP
    • REQUESTER:
      EXTERNAL

      Description

      It is required to prepare a report for the attributes mentioned in the document for Sites.

      The attributes are need to be in the same sequence as mentioned in the table.

      The reference Reports in NEP are Sites Report & Additional Information report for Site.

      Attribute Details are available in document attached.

        Activity

        Aurobinda Panda logged work - 15/Sep/25 12:00 AM
        • Time Spent:
          1 hour
           

          Document Prepared and ticket raised to L3

        Aurobinda Panda made changes -
        Field Original Value New Value
        Gantt Options Milestone (set to milestone: having a due date but zero effort)
        Planned Start 2025-09-17 24:00 (milestone: set planned start date to due date)
        Planned End 2025-09-17 24:00 (milestone: set planned end date to due date)
        Aurobinda Panda made changes -
        Remaining Estimate 0 minutes [ 0 ]
        Time Spent 1 hour [ 3600 ]
        Worklog Id 277434 [ 277434 ]
        Aurobinda Panda made changes -
        Baseline Start 2025-09-17 24:00 (set baseline based of initial work logging)
        Baseline End 2025-09-17 24:00 (set baseline based of initial work logging)
        Marwan Kanaan logged work - 17/Sep/25 12:00 AM
        • Time Spent:
          2 hours
           

          view done

        Marwan Kanaan made changes -
        Assignee Khaled Khalil [ kkhalil ] Marwan Kanaan [ mkanaan ]
        Marwan Kanaan made changes -
        Assignee Marwan Kanaan [ mkanaan ] Khaled Khalil [ kkhalil ]
        Marwan Kanaan made changes -
        Assignee Khaled Khalil [ kkhalil ] Marwan Kanaan [ mkanaan ]
        Marwan Kanaan made changes -
        Assignee Marwan Kanaan [ mkanaan ] Khaled Khalil [ kkhalil ]
        Khaled Khalil made changes -
        Assignee Khaled Khalil [ kkhalil ] Marwan Kanaan [ mkanaan ]
        Khaled Khalil made changes -
        Status Opened [ 1 ] Pending Requirements [ 10300 ]
        Khaled Khalil made changes -
        Status Pending Requirements [ 10300 ] Pending Design Session [ 10112 ]
        Assignee Marwan Kanaan [ mkanaan ] Khaled Khalil [ kkhalil ]
        Khaled Khalil made changes -
        Status Pending Design Session [ 10112 ] Dev Scheduled [ 10014 ]
        Khaled Khalil made changes -
        Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
        Khaled Khalil made changes -
        Assignee Khaled Khalil [ kkhalil ]
        Khaled Khalil made changes -
        Assignee Marwan Kanaan [ mkanaan ]
        Marwan Kanaan made changes -
        Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
        Marwan Kanaan made changes -
        Attachment 20250917_SITE_DB_REPORT_VIEW.sql [ 117822 ]
        Hide
        Marwan Kanaan added a comment -

        Dear @Aurobinda Panda,

        The view is finished please share and verify. 
        View attached.

        Best Regards,
        Marwan Kanaan I Software Developer

        Show
        Marwan Kanaan added a comment - Dear @Aurobinda Panda, The view is finished please share and verify.  View attached. Best Regards, Marwan Kanaan I Software Developer
        Marwan Kanaan made changes -
        Time Spent 1 hour [ 3600 ] 3 hours [ 10800 ]
        Worklog Id 277867 [ 277867 ]
        Khaled Khalil made changes -
        Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
        Assignee Marwan Kanaan [ mkanaan ] Aurobinda Panda [ apanda ]
        Aurobinda Panda logged work - 18/Sep/25 12:00 AM - edited
        • Time Spent:
          1 hour, 30 minutes
           

          Output is not correct. data validated and shared feedback to L3 Dev.

        Marwan Kanaan logged work - 18/Sep/25 12:00 AM
        • Time Spent:
          1 hour
           

          fixed the db view.

        Marwan Kanaan logged work - 18/Sep/25 12:00 AM - edited
        • Time Spent:
          1 hour
           

          another fix in the view.

        Hide
        Aurobinda Panda added a comment -

        Hi Marwan,
        The Output is not correct. The column names are not matching for few attributes.

        Site ID data is also not matching.
        Please check and confirm.

        Show
        Aurobinda Panda added a comment - Hi Marwan, The Output is not correct. The column names are not matching for few attributes. Site ID data is also not matching. Please check and confirm.
        Aurobinda Panda made changes -
        Time Spent 3 hours [ 10800 ] 4 hours [ 14400 ]
        Worklog Id 277900 [ 277900 ]
        Aurobinda Panda made changes -
        Assignee Aurobinda Panda [ apanda ] Marwan Kanaan [ mkanaan ]
        Aurobinda Panda made changes -
        Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
        Assignee Marwan Kanaan [ mkanaan ] Aurobinda Panda [ apanda ]
        Aurobinda Panda made changes -
        Status QA In Progress [ 10015 ] Bug/s Found [ 10208 ]
        Aurobinda Panda made changes -
        Assignee Aurobinda Panda [ apanda ] Marwan Kanaan [ mkanaan ]
        Aurobinda Panda made changes -
        Attachment Error in Site DB Output.jpg [ 117900 ]
        Hide
        Marwan Kanaan added a comment -

        Dear @Aurobinda Panda,

        Kindly know that the script is fixed.
        Please apply and verify.

        ss

        Best Regards,

        Marwan Kanaan I Software Developer

        Show
        Marwan Kanaan added a comment - Dear @Aurobinda Panda, Kindly know that the script is fixed. Please apply and verify. ss Best Regards, Marwan Kanaan I Software Developer
        Marwan Kanaan made changes -
        Attachment 20250917_SITE_DB_REPORT_VIEW.sql [ 117901 ]
        Marwan Kanaan made changes -
        Attachment 20250917_SITE_DB_REPORT_VIEW.sql [ 117822 ]
        Marwan Kanaan made changes -
        Attachment similar issue same as prod.png [ 117902 ]
        Marwan Kanaan made changes -
        Attachment similar issue same as prod.png [ 117902 ]
        Marwan Kanaan made changes -
        Attachment Screenshot 2025-09-18 083352.png [ 117903 ]
        Marwan Kanaan made changes -
        Time Spent 4 hours [ 14400 ] 5 hours [ 18000 ]
        Worklog Id 277905 [ 277905 ]
        Aurobinda Panda made changes -
        Time Spent 5 hours [ 18000 ] 5 hours, 30 minutes [ 19800 ]
        Worklog Id 277900 [ 277900 ]
        Marwan Kanaan made changes -
        Time Spent 5 hours, 30 minutes [ 19800 ] 6 hours, 30 minutes [ 23400 ]
        Worklog Id 278016 [ 278016 ]
        Marwan Kanaan made changes -
        Worklog Id 278016 [ 278016 ]
        Marwan Kanaan made changes -
        Worklog Id 278016 [ 278016 ]
        Marwan Kanaan made changes -
        Attachment 20250917_SITE_DB_REPORT_VIEW.sql [ 117901 ]
        Marwan Kanaan made changes -
        Attachment 20250917_SITE_DB_REPORT_VIEW.sql [ 118008 ]
        Marwan Kanaan made changes -
        Assignee Marwan Kanaan [ mkanaan ] Aurobinda Panda [ apanda ]
        Abir Messaikeh made changes -
        Status Bug/s Found [ 10208 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]
        Hide
        Abir Messaikeh added a comment -

        Bug fixed , file sent to Agile Ops team for validation

        Show
        Abir Messaikeh added a comment - Bug fixed , file sent to Agile Ops team for validation
        Abir Messaikeh made changes -
        Link This issue relates to MOB-7347 [ MOB-7347 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Opened Opened Pending Requirements Pending Requirements
        2d 3h 36m 1 Khaled Khalil 17/Sep/25 12:28 PM
        Pending Requirements Pending Requirements Pending Design Session Pending Design Session
        7s 1 Khaled Khalil 17/Sep/25 12:28 PM
        Pending Design Session Pending Design Session Dev Scheduled Dev Scheduled
        9s 1 Khaled Khalil 17/Sep/25 12:28 PM
        Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
        6s 1 Khaled Khalil 17/Sep/25 12:28 PM
        Implementation in progress Implementation in progress To Be Released To Be Released
        57m 51s 1 Marwan Kanaan 17/Sep/25 1:26 PM
        To Be Released To Be Released Ready for QA Ready for QA
        13m 45s 1 Khaled Khalil 17/Sep/25 1:40 PM
        Ready for QA Ready for QA QA In Progress QA In Progress
        14h 47m 1 Aurobinda Panda 18/Sep/25 4:27 AM
        QA In Progress QA In Progress Bug/s Found Bug/s Found
        17s 1 Aurobinda Panda 18/Sep/25 4:27 AM
        Bug/s Found Bug/s Found Closed Closed
        4d 10h 58m 1 Abir Messaikeh 22/Sep/25 3:26 PM
        Subversion JIRA

        Links Hierarchy

         Documentation

        Invalid license: EXPIRED

          People

          • Assignee:
            Aurobinda Panda
            Reporter:
            Aurobinda Panda
          • Votes:
            0 Vote for this issue
            Watchers:
            2 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 - 6 hours, 30 minutes
              6h 30m

                Drag and Drop