Openbravo Issue Tracking System - POS2
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0051421POS2POSpublic2023-01-19 15:472023-01-30 16:50
Reporteralostale 
Assigned Toranjith_qualiantech_com 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version23Q1Fixed in Version 
Merge Request Statusapproved
Review Assigned Tomarvintm
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0051421: Product Media performs always full refresh
DescriptionWhen executing an incremental refresh, Product Media performs a full refresh retrieving media for all products regardless they were updated.
Steps To ReproduceIn an instance with product media defined:

1. Log in pos2
2. Execute Refresh Masterdata (to ensure next refresh should fetch no rows)
3. Execute Refresh Masterdata
  Check developers tools > Network Panel
    Expected: request to ProductMedia masterdata returns no rows
    Obtained: it contains the whole dataset
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0051415 closed ranjith_qualiantech_com Product Media performs always full refresh 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-01-20 07:25marvintmTypedefect => backport
2023-01-20 07:25marvintmTarget Version => 22Q4.2
2023-01-20 07:25marvintmTarget Version22Q4.2 => 23Q1
2023-01-27 08:16marvintmNote Added: 0145908
2023-01-27 08:16marvintmStatusscheduled => resolved
2023-01-27 08:16marvintmFixed in Version => 23Q2
2023-01-27 08:16marvintmResolutionopen => fixed
2023-01-27 08:16marvintmReview Assigned To => marvintm
2023-01-27 08:16marvintmStatusresolved => closed
2023-01-27 08:17marvintmStatusclosed => new
2023-01-27 08:17marvintmResolutionfixed => open
2023-01-27 08:17marvintmFixed in Version23Q2 =>
2023-01-27 08:17marvintmNote Deleted: 0145908
2023-01-27 08:18marvintmStatusnew => scheduled
2023-01-27 12:25hgbotMerge Request Status => open
2023-01-27 12:25hgbotNote Added: 0145932
2023-01-27 12:25hgbotNote Added: 0145933
2023-01-30 16:49hgbotMerge Request Statusopen => approved
2023-01-30 16:49hgbotResolutionopen => fixed
2023-01-30 16:49hgbotStatusscheduled => closed
2023-01-30 16:49hgbotFixed in Version => RR23Q1
2023-01-30 16:49hgbotNote Added: 0146047
2023-01-30 16:49hgbotNote Added: 0146048
2023-01-30 16:50hgbotNote Added: 0146049
2023-01-30 16:50hgbotNote Added: 0146050

Notes
(0145932)
hgbot   
2023-01-27 12:25   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1049 [^]
(0145933)
hgbot   
2023-01-27 12:25   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/124 [^]
(0146047)
hgbot   
2023-01-30 16:49   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: 9e9e41a8e0dce6942ee0562c0b204eafb39db126
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 27-01-2023 16:46:23
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/9e9e41a8e0dce6942ee0562c0b204eafb39db126 [^]

Fixed ISSUE-51421: Updated ProductMedia query for incrementalRefresh
* Updated ProductMedia query by adding OrgCriteria, incrementalUpdateCriteria,
  paginationCriteria and orderby clause
* Added active and sequenceNumber property to ProductMediaProperties

---
A src/org/openbravo/retail/posterminal/master/ProductMediaProperties.java
M src/org/openbravo/retail/posterminal/master/ProductMedia.java
---
(0146048)
hgbot   
2023-01-30 16:49   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1049 [^]
(0146049)
hgbot   
2023-01-30 16:50   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/124 [^]
(0146050)
hgbot   
2023-01-30 16:50   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: 172d5d2aa79cf6caa8ad100aa86cd0892e7891cf
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 30-01-2023 15:49:53
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/172d5d2aa79cf6caa8ad100aa86cd0892e7891cf [^]

Related to ISSUE-51421: Added active property to ProductMedia mapping

---
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
---