Search order_request_items by their inventory barcode
Good afternoon @mobreza
@1cgiar/palmira
We are currently making a new native Android application, using the new GG-CE API - REST services.
This application, performs the search of inventories in cold rooms, to be able to pack the new inventories for dispatch.
To continue development, we request two things:
-
The item must have a relationship with two inventories (source and sample).
-
A service that searches through the inventory barcode, the order request item and its respective order to which it belongs. Currently we have to list all orders (filter by order request actions), then search for their items (filter by order request items actions), search for inventories and compare the barcode of the inventory read to find the inventory.
Could you do it in a better way? or is it necessary to build a new service? Currently the performance of this query is poor.
Thank you