0055223: duplicated data fetched as part of offline user masterdata models

Openbravo Issue Tracking System - POS2

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0055223

POS2

Core

public

2024-04-17 14:35

2024-06-03 17:17

Reporter

alostale

Assigned To

cberner

Priority

normal

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

24Q2

Fixed in Version

24Q3

Merge Request Status

Review Assigned To

OBNetwork customer

Support ticket

Regression level

Production - Confirmed Stable

Regression date

2022-03-10

Regression introduced in release

22Q3

Regression introduced by commit

https://gitlab.com/openbravo/product/pmods/org.openbravo.core2/-/commit/2f9085eac2a9c579fbf9fdaa0958fbbca06ad4cc [^]

Triggers an Emergency Pack

Summary

0055223: duplicated data fetched as part of offline user masterdata models

Description

When requesting data for offline user master data model, lots of duplicated records are fetched. Although they are cleaned up while inserting, it is suboptimal.

Steps To Reproduce

1. Log in POS and refresh master data to ensure there is no additional records to fetch
2. Log in BO
3. Check Group - Admin role can approve at least one user action
4. Open User window and select Demouser
5. Update some field (ie. email)
6. Log in POS
7. Refresh masterdata and check the request for OfflineUser model in the network panel
EXPECTED: 1 row should have been fetched as only one user was modified
GOT: 28 identical rows, all with the same information for demouser

Proposed Solution

Inner joins in the queries should be replaced by exists clauses.

Additional Information