Openbravo Issue Tracking System - Retail Modules
View Issue Details
0048486Retail ModulesWeb POSpublic2022-01-26 15:062022-03-08 07:20
migueldejuana 
gorka_gil 
normalminoralways
newopen 
5
 
 
marvintm
No
0048486: Masterdata model with several queries is not retrievieng all data using batches
We have a Masterdata model which returns more than one query in getQuery method in the Java that extends ProccessHQLQuery. If "Masterdata models batch size" preference is defined and the value is multiple of the rows returned by the first query in our Model, we do not reset the offset for next queries and it only retrieves the data starting from the last offset instead of starting again from 0.
- Login in https://livebuilds.openbravo.com/retail_modules_pgsql_pi/web/org.openbravo.warehouse.advancedwarehouseoperations/ [^]
- Check in the developers tools that there are 36 Locators --> 33 regular locators and 3 external locators(trucks)
- Define "Masterdata models batch size" to 3
- Client browser storage and login again
- Check in the developers tools that there are 33 Locators --> 33 regular locators and 0 external locators(trucks)
ERROR! External locators are not loaded because the offset was 33 instead of 0

This example is in AWO but it affects all apps.
No tags attached.
Issue History
2022-01-26 15:06migueldejuanaNew Issue
2022-01-26 15:06migueldejuanaAssigned To => migueldejuana
2022-01-26 15:06migueldejuanaTriggers an Emergency Pack => No
2022-01-26 15:21hgbotNote Added: 0134578
2022-01-26 15:25migueldejuanaReview Assigned To => marvintm
2022-03-08 07:20migueldejuanaAssigned Tomigueldejuana => gorka_gil

Notes
(0134578)
hgbot   
2022-01-26 15:21   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/merge_requests/323 [^]