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

        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.
        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
        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

          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