Details

    • Type: CR CR
    • Status: Ready for QA Ready for QA (View Workflow)
    • Priority: Normal Normal
    • Resolution: Unresolved
    • Component/s: FN
    • Labels:
      None Labels
    • Customer:
      OMAN-Tel
    • Product:
      NEP

      Description

      As discussed please check below we need the field INSTALLED_PLAN_DATE to show date time together.

      The value is available in INSERTDATE column in this format : API should return 2026-04-07 13:30:32 (Format)

      <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
      <SOAP-ENV:Header xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
      <wsse:Security
      xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"
      xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"
      soap:mustUnderstand="1">
      <wsse:UsernameToken wsu:Id="UsernameToken-ccc6a478-03f3-475b-a929-11a2cef3d665">
      <wsse:Username>nep-api-key</wsse:Username>
      <wsse:Password
      Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">
      mobinets@2017</wsse:Password>
      </wsse:UsernameToken>
      </wsse:Security>
      </SOAP-ENV:Header>
      <soap:Body>
      <ns2:getObcRemarksResponse xmlns:ns2="http://server.api.nep.mobinets.com/">
      <return>
      <returnCode>0</returnCode>
      <returnMessage>SUCCESS</returnMessage>
      <TASK>
      <WO_ID>-3312255</WO_ID>
      <STATUS>Order Accepted</STATUS>
      <INSTALLED_PLAN_DATE>08-Apr-2026 HH:MM:SS</INSTALLED_PLAN_DATE>
                 <!-- add date time>
      </TASK>
      <TASK>
      <WO_ID>-3312255</WO_ID>
      <STATUS>SubContractor Assigned</STATUS>
      <INSTALLED_PLAN_DATE>08-Apr-2026</INSTALLED_PLAN_DATE>
      </TASK>

      <TASK>
      <WO_ID>-3312255</WO_ID>
      <STATUS>Order Rejected</STATUS>
      <INSTALLED_PLAN_DATE>08-Apr-2026</INSTALLED_PLAN_DATE>
      </TASK>
      </return>
      </ns2:getObcRemarksResponse>
      </soap:Body>
      </soap:Envelope>

        Activity

        Abdulrahman Dabboussi made changes -
        Field Original Value New Value
        Gantt Options Milestone (set to milestone: having a due date but zero effort)
        Planned Start 2026-04-15 24:00 (milestone: set planned start date to due date)
        Planned End 2026-04-15 24:00 (milestone: set planned end date to due date)
        Khaled Khalil made changes -
        Assignee Khaled Khalil [ kkhalil ] Ayed Bada [ abada ]
        Ayed Bada logged work - 14/Apr/26 12:00 AM
        • Time Spent:
          4 hours
           

          Implementation

        Ayed Bada logged work - 15/Apr/26 12:00 AM
        • Time Spent:
          6 hours
           

          Implementation and local test

        Hide
        Ayed Bada added a comment -

        The new patch, along with the provided SQL query, will cover the requirement to return INSTALLED_PLAN_DATE with time details.
        In the OBC task (FN), we have maintained compatibility with the previous date format.
        Please run the mentioned SQL query.

        Patch 3.7.0.1445.

        Show
        Ayed Bada added a comment - The new patch, along with the provided SQL query, will cover the requirement to return INSTALLED_PLAN_DATE with time details. In the OBC task (FN), we have maintained compatibility with the previous date format. Please run the mentioned SQL query. Patch 3.7.0.1445.
        Ayed Bada made changes -
        Khaled Khalil made changes -
        Status Opened [ 1 ] Pending Requirements [ 10300 ]
        Khaled Khalil made changes -
        Status Pending Requirements [ 10300 ] Pending Design Session [ 10112 ]
        Assignee Ayed Bada [ abada ] 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 ]
        Ayed Bada made changes -
        Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
        Khaled Khalil made changes -
        Assignee Khaled Khalil [ kkhalil ] Ayed Bada [ abada ]
        Khaled Khalil made changes -
        Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
        Assignee Ayed Bada [ abada ] Abdulrahman Dabboussi [ adabboussi ]
        Ayed Bada made changes -
        Remaining Estimate 0 minutes [ 0 ]
        Time Spent 6 hours [ 21600 ]
        Worklog Id 296948 [ 296948 ]
        Ayed Bada made changes -
        Baseline Start 2026-04-15 24:00 (set baseline based of initial work logging)
        Baseline End 2026-04-15 24:00 (set baseline based of initial work logging)
        Ayed Bada made changes -
        Time Spent 6 hours [ 21600 ] 1 day, 2 hours [ 36000 ]
        Worklog Id 296949 [ 296949 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Opened Opened Pending Requirements Pending Requirements
        7d 1h 11m 1 Khaled Khalil Wednesday 3:07 PM
        Pending Requirements Pending Requirements Pending Design Session Pending Design Session
        10s 1 Khaled Khalil Wednesday 3:07 PM
        Pending Design Session Pending Design Session Dev Scheduled Dev Scheduled
        6s 1 Khaled Khalil Wednesday 3:07 PM
        Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
        7s 1 Khaled Khalil Wednesday 3:07 PM
        Implementation in progress Implementation in progress To Be Released To Be Released
        42s 1 Ayed Bada Wednesday 3:08 PM
        To Be Released To Be Released Ready for QA Ready for QA
        46s 1 Khaled Khalil Wednesday 3:08 PM
        Subversion JIRA

        Links Hierarchy

         Documentation

        Invalid license: EXPIRED

          People

          • Assignee:
            Abdulrahman Dabboussi
            Reporter:
            Abdulrahman Dabboussi
          • Votes:
            0 Vote for this issue
            Watchers:
            2 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 - 1 day, 2 hours
              1d 2h

                Drag and Drop