Uploaded image for project: 'mod-inventory'
  1. mod-inventory
  2. MODINV-472

Get all item's associated entities in one call

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Draft (View Workflow)
    • Priority: P2
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
    • Template:
    • Sprint:
      Prokopovych - Sprint 129
    • Story Points:
      5
    • Development Team:
      Prokopovych

      Description

      Currently the GET /inventory/items?query=(barcode==xyz) call results in a mod-inventory-storage call to get the item, but 5 other separate calls to get the item's loan type, location, material type, instance, and holdings which together result in at least an additional 500ms, depending on the load at the time.   Could these calls be added to the get item c all itself or at least be batched up in a separate call to get an item's properties since all the data are in the same schema but in different tables that can easily be joined together (similar to getting RTAC's properties in get_items_and_holdings_view) ?  This get item by barcode call is used in the prominent check-in-check-out workflow and other situations so it is a performance gain and execution time saving if it can be optimized.

      Attached is a Giraffe diagram showing the call to get an item and its associated entities along with the costs and overhead (calling mod-authtoken) for each call. 

       

      Interested Parties

      Jenn Colt Holly Mistlebauer Marc Johnson

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                mtraneis Martin Tran
                Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                  Dates

                  Created:
                  Updated:

                    TestRail: Runs

                      TestRail: Cases