Details

    • Type: Bug Bug
    • Status: Rejected Rejected (View Workflow)
    • Priority: Normal Normal
    • Resolution: Not Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: SRD
    • Labels:
    • Customer:
      OMAN-Tel
    • Product:
      NEP

      Description

      Review SRD API getGponDesignParameters
      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://server.internal.api.srd.nep.mobinets.com/">
      <soapenv:Header/>
      <soapenv:Body>
      <ser:getGponDesignParameters>
      <!-Optional:->
      <requestId>mb011</requestId>
      <!-Optional:->
      <serviceName>1319442_FBB</serviceName>
      </ser:getGponDesignParameters>
      </soapenv:Body>
      </soapenv: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-03-17 24:00 (milestone: set planned start date to due date)
        Planned End 2026-03-17 24:00 (milestone: set planned end date to due date)
        Zein Trabelsi made changes -
        Assignee Zein Trabelsi [ ztrabelsi ] Ayed Bada [ abada ]
        Hide
        Ayed Bada added a comment -

        The API is working correctly. In this example, it returns a default response.

        To get a real (non-default) response, please execute the following query:
        SELECT
        sm.request_id,
        sbi.MILESTONE_ID
        FROM
        SRD_MILESTONE sm
        INNER JOIN
        SRD_MILESTONE_PROFILE sbi
        ON sm.id = sbi.MILESTONE_ID
        WHERE
        sm.DTYPE = 'GPON';
        This will provide a list of request_id values that can be used for testing and should return non-default data.

        Please also refer to the attached screenshot, where I tested this in my local environment.

        Show
        Ayed Bada added a comment - The API is working correctly. In this example, it returns a default response. To get a real (non-default) response, please execute the following query: SELECT sm.request_id, sbi.MILESTONE_ID FROM SRD_MILESTONE sm INNER JOIN SRD_MILESTONE_PROFILE sbi ON sm.id = sbi.MILESTONE_ID WHERE sm.DTYPE = 'GPON'; This will provide a list of request_id values that can be used for testing and should return non-default data. Please also refer to the attached screenshot, where I tested this in my local environment.
        Ayed Bada made changes -
        Attachment ACE-722.PNG [ 131321 ]
        Ayed Bada made changes -
        Status Open Bug [ 10108 ] Rejected [ 10100 ]
        Assignee Ayed Bada [ abada ] Mbaye Lo [ mbayel ]
        Resolution Cancelled [ 10100 ]
        Mbaye Lo made changes -
        Assignee Mbaye Lo [ mbayel ] Zein Trabelsi [ ztrabelsi ]
        Hide
        Mbaye Lo added a comment - - edited

        Please provide a sample in Omantel platforms 179 and 84 and to be demoed in SRD UI

        Show
        Mbaye Lo added a comment - - edited Please provide a sample in Omantel platforms 179 and 84 and to be demoed in SRD UI
        Mbaye Lo made changes -
        Resolution Cancelled [ 10100 ] Not Fixed [ 10200 ]
        Status Rejected [ 10100 ] Reopened [ 4 ]
        Zein Trabelsi made changes -
        Attachment Untitled.png [ 134806 ]
        Zein Trabelsi made changes -
        Attachment Untitled.png [ 134807 ]
        Zein Trabelsi made changes -
        Status Reopened [ 4 ] Dev Scheduled [ 10014 ]
        Zein Trabelsi made changes -
        Status Dev Scheduled [ 10014 ] Open Bug [ 10108 ]
        Assignee Zein Trabelsi [ ztrabelsi ] Mbaye Lo [ mbayel ]
        Zein Trabelsi made changes -
        Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
        Hide
        Zein Trabelsi added a comment -

        What it does:
        Returns GPON design parameters (total cost, distance to exchange, vendor, exchange list)
        by reading the GPON Milestone profiles for the given requestId.

        Find valid requestId from DB:
        SELECT m.REQUEST_ID, SUM(p.COST), COUNT(p.ID)
        FROM SRD_MILESTONE m
        JOIN SRD_MILESTONE_PROFILE p ON p.MILESTONE_ID = m.ID
        WHERE m.DTYPE = 'GPON' GROUP BY m.REQUEST_ID HAVING COUNT(p.ID) > 0;

        UI Check: Open request id → GPON Milestone tab.
        Values shown should match the aggregated API response.

        see attached screenshots

        Show
        Zein Trabelsi added a comment - What it does: Returns GPON design parameters (total cost, distance to exchange, vendor, exchange list) by reading the GPON Milestone profiles for the given requestId. Find valid requestId from DB: SELECT m.REQUEST_ID, SUM(p.COST), COUNT(p.ID) FROM SRD_MILESTONE m JOIN SRD_MILESTONE_PROFILE p ON p.MILESTONE_ID = m.ID WHERE m.DTYPE = 'GPON' GROUP BY m.REQUEST_ID HAVING COUNT(p.ID) > 0; UI Check: Open request id → GPON Milestone tab. Values shown should match the aggregated API response. see attached screenshots
        Zein Trabelsi made changes -
        Status Dev Scheduled [ 10014 ] Rejected [ 10100 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Bug Open Bug Rejected Rejected
        20d 6h 54m 1 Ayed Bada 30/Mar/26 2:55 PM
        Rejected Rejected Reopened Reopened
        41d 22h 16m 1 Mbaye Lo 11/May/26 1:11 PM
        Reopened Reopened Dev Scheduled Dev Scheduled
        3d 21h 12m 1 Zein Trabelsi 15/May/26 10:24 AM
        Dev Scheduled Dev Scheduled Open Bug Open Bug
        2s 1 Zein Trabelsi 15/May/26 10:24 AM
        Open Bug Open Bug Dev Scheduled Dev Scheduled
        8s 1 Zein Trabelsi 15/May/26 10:24 AM
        Dev Scheduled Dev Scheduled Rejected Rejected
        9s 1 Zein Trabelsi 15/May/26 10:25 AM
        Subversion JIRA

        Links Hierarchy

         Documentation

        Invalid license: EXPIRED

          People

          • Assignee:
            Mbaye Lo
            Reporter:
            Mbaye Lo
            Rejected By:
            Zein Trabelsi
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Due:
              Created:
              Updated:
              Resolved:
              Planned Start:
              Planned End:

              Drag and Drop