0057172: Error when there are more than 300 Sales Representative Users

Openbravo Issue Tracking System - POS2

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0057172

POS2

POS

public

2024-10-30 14:44

2024-12-04 09:18

Reporter

sofidossant

Assigned To

fofarril

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

24Q3.2

Target Version

24Q2.5

Fixed in Version

24Q2.5

Merge Request Status

approved

Review Assigned To

OBNetwork customer

Gold

Support ticket

112501

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0057172: Error when there are more than 300 Sales Representative Users

Description

When we have for example 350 representative users, we cannot search correctly for certain users, because it does not find them by the limit.

Steps To Reproduce

1 - Create 350 Sales Representative Users in backoffice.
2 - Search for a user but with names beginning with the last letters of the alphabet.

You can't find the user, but if you check it is loaded in the cache

Proposed Solution

Code harcode with 300
https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/blob/release/24Q3/web/org.openbravo.mobile.core/app/model/persistence/indexeddb/Criteria.js?ref_type=heads&blame=1 [^]

commit https://gitlab.com/openbravo/product/pmods/org.openbravo.mobile.core/-/commit/0d54d001c0ca49dfcde55c545030363974e9b694 [^]

(function CriteriaDefinition() {
  const DEFAULT_QUERY_LIMIT = 300;
  /**
   * Allows to create a criteria for searching objects using the IndexedDBController API.
   */
  OB.App.Class.Criteria = class Criteria {
    constructor() {
      this.theLimit = DEFAULT_QUERY_LIMIT;
      this.theOperator = 'and';
      this.order = { properties: [], directions: [] };
      this.properties = [];
      this.selectProperties = [];
    }

Additional Information