Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0058220 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
design defect | [Openbravo ERP] A. Platform | major | always | 2025-03-12 16:44 | 2025-03-27 12:08 | |||
Reporter | sofidossant | View Status | public | |||||
Assigned To | Triage Omni WMS | |||||||
Priority | high | Resolution | duplicate | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | OBPS | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | 123872 | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0058220: Product field performance in physical inventory | |||||||
Description | When we want to add a line in physical inventory, and we search for a product, the selector takes a long time. | |||||||
Steps To Reproduce | Create a physical inventory. Add columns and open the product selector. Remove the filters in the selector. And add other filters, for example the generic product. | |||||||
Proposed Solution | try to replace the selector with another definition in which a database view is not used. Postgresql is not able to use proper indexes when using views. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
|
![]() |
|
(0177460) hgbot (developer) 2025-03-27 12:08 |
Issue exported to Jira: https://openbravo.atlassian.net/browse/RM-24193 [^] |
![]() |
|||
Date Modified | Username | Field | Change |
2025-03-12 16:44 | sofidossant | New Issue | |
2025-03-12 16:44 | sofidossant | Assigned To | => Triage Platform Base |
2025-03-12 16:44 | sofidossant | OBNetwork customer | => OBPS |
2025-03-12 16:44 | sofidossant | Modules | => Core |
2025-03-12 16:44 | sofidossant | Support ticket | => 123872 |
2025-03-12 16:44 | sofidossant | Triggers an Emergency Pack | => No |
2025-03-12 16:45 | Practics | Issue Monitored: Practics | |
2025-03-20 11:26 | AugustoMauch | Assigned To | Triage Platform Base => Triage Omni OMS |
2025-03-20 11:26 | AugustoMauch | Type | defect => design defect |
2025-03-20 21:09 | aferraz | Assigned To | Triage Omni OMS => Triage Omni WMS |
2025-03-27 12:08 | hgbot | Note Added: 0177460 | |
2025-03-27 12:08 | hgbot | Status | new => closed |
2025-03-27 12:08 | hgbot | Resolution | open => duplicate |
Copyright © 2000 - 2009 MantisBT Group |