0056938: 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

0056938

POS2

POS

public

2024-10-30 14:44

2024-11-20 10:59

Reporter

sofidossant

Assigned To

fofarril

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

24Q3.2

Target Version

Fixed in Version

25Q1

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

0056938: 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

Tags

No tags attached.

Relationships

depends on	backport	0057170	24Q4	closed	fofarril	Error when there are more than 300 Sales Representative Users
depends on	backport	0057171	24Q3.3	closed	fofarril	Error when there are more than 300 Sales Representative Users
depends on	backport	0057172	24Q2.5	closed	fofarril	Error when there are more than 300 Sales Representative Users