Uploaded image for project: 'mod-orders'
  1. mod-orders
  2. MODORDERS-783

Implement Orders Export History API

    XMLWordPrintable

Details

    • ACQ Sprint 150, ACQ Sprint 151
    • 3
    • Thunderjet
    • Orchid (R1 2023)
    • TBD

    Description

      Purpose/Overview:
      New API to get Export History for given PO Line should be implemented

      Requirements/Scope:

      1. Adjust export history functionality in orders-storage to store more required fields connected with export
      2. Allow user to query orders-storage to get all required fields(Vendor Name,  File Name, Export Method, Export Date) for provided PO Line id

      Approach:{}

      Required changes in mod-orders-storage:

      Mod-orders-storage already has REST API and DAO methods to work with this table export_history.

      1. Need to provide a meachanism to search export history records by order line id.

      Need Modify mod-orders-storage to save data into 2 tables: 

      1. Save export history info in already existed table export_history
      2. Create new table for stroring  exportJobId and poLineId and SN: poId pair
      3. Extract PO Line ids SN: PO Ids from kafka payload and save into new table using batch operation.

      Required changes in mod-orders:

      Provide new API to call mod-orders-storage to find export history by PO Line Id

      Do we need to provide migration scipt: No

      Create new complex Karate test in scope of another story

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                siarhei_hrabko Siarhei Hrabko
                Nosko Serhii Nosko
                Dennis Bridges Dennis Bridges
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases