Details
-
Type:
CR
-
Status:
Closed
(View Workflow)
-
Priority:
Normal
-
Resolution: Fixed
-
Component/s: NEP
-
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.
Attachments
Cancelled
Activity
-
- Time Spent:
- 1 hour
-
Document Prepared and ticket raised to L3
| 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) |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 1 hour [ 3600 ] | |
| Worklog Id | 277434 [ 277434 ] |
| 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) |
| Assignee | Khaled Khalil [ kkhalil ] | Marwan Kanaan [ mkanaan ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Khaled Khalil [ kkhalil ] |
| Assignee | Khaled Khalil [ kkhalil ] | Marwan Kanaan [ mkanaan ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Khaled Khalil [ kkhalil ] |
| Assignee | Khaled Khalil [ kkhalil ] | Marwan Kanaan [ mkanaan ] |
| Status | Opened [ 1 ] | Pending Requirements [ 10300 ] |
| Status | Pending Requirements [ 10300 ] | Pending Design Session [ 10112 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Khaled Khalil [ kkhalil ] |
| Status | Pending Design Session [ 10112 ] | Dev Scheduled [ 10014 ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Assignee | Khaled Khalil [ kkhalil ] |
| Assignee | Marwan Kanaan [ mkanaan ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Attachment | 20250917_SITE_DB_REPORT_VIEW.sql [ 117822 ] |
| Time Spent | 1 hour [ 3600 ] | 3 hours [ 10800 ] |
| Worklog Id | 277867 [ 277867 ] |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Aurobinda Panda [ apanda ] |
-
- Time Spent:
- 1 hour, 30 minutes
-
Output is not correct. data validated and shared feedback to L3 Dev.
-
- Time Spent:
- 1 hour
-
another fix in the view.
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.
| Time Spent | 3 hours [ 10800 ] | 4 hours [ 14400 ] |
| Worklog Id | 277900 [ 277900 ] |
| Assignee | Aurobinda Panda [ apanda ] | Marwan Kanaan [ mkanaan ] |
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Aurobinda Panda [ apanda ] |
| Status | QA In Progress [ 10015 ] | Bug/s Found [ 10208 ] |
| Assignee | Aurobinda Panda [ apanda ] | Marwan Kanaan [ mkanaan ] |
| Attachment | Error in Site DB Output.jpg [ 117900 ] |
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
| Attachment | 20250917_SITE_DB_REPORT_VIEW.sql [ 117901 ] |
| Attachment | 20250917_SITE_DB_REPORT_VIEW.sql [ 117822 ] |
| Attachment | similar issue same as prod.png [ 117902 ] |
| Attachment | similar issue same as prod.png [ 117902 ] |
| Attachment | Screenshot 2025-09-18 083352.png [ 117903 ] |
| Time Spent | 4 hours [ 14400 ] | 5 hours [ 18000 ] |
| Worklog Id | 277905 [ 277905 ] |
| Time Spent | 5 hours [ 18000 ] | 5 hours, 30 minutes [ 19800 ] |
| Worklog Id | 277900 [ 277900 ] |
| Time Spent | 5 hours, 30 minutes [ 19800 ] | 6 hours, 30 minutes [ 23400 ] |
| Worklog Id | 278016 [ 278016 ] |
| Worklog Id | 278016 [ 278016 ] |
| Worklog Id | 278016 [ 278016 ] |
| Attachment | 20250917_SITE_DB_REPORT_VIEW.sql [ 117901 ] |
| Attachment | 20250917_SITE_DB_REPORT_VIEW.sql [ 118008 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Aurobinda Panda [ apanda ] |
| Status | Bug/s Found [ 10208 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] |
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
| Link | This issue relates to MOB-7347 [ MOB-7347 ] |
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
2d 3h 36m | 1 | Khaled Khalil | 17/Sep/25 12:28 PM | |||||
|
7s | 1 | Khaled Khalil | 17/Sep/25 12:28 PM | |||||
|
9s | 1 | Khaled Khalil | 17/Sep/25 12:28 PM | |||||
|
6s | 1 | Khaled Khalil | 17/Sep/25 12:28 PM | |||||
|
57m 51s | 1 | Marwan Kanaan | 17/Sep/25 1:26 PM | |||||
|
13m 45s | 1 | Khaled Khalil | 17/Sep/25 1:40 PM | |||||
|
14h 47m | 1 | Aurobinda Panda | 18/Sep/25 4:27 AM | |||||
|
17s | 1 | Aurobinda Panda | 18/Sep/25 4:27 AM | |||||
|
4d 10h 58m | 1 | Abir Messaikeh | 22/Sep/25 3:26 PM |
|
Links Hierarchy |
 Documentation
|
Dear @Aurobinda Panda,
The view is finished please share and verify.Â
View attached.
Best Regards,
Marwan Kanaan I Software Developer