Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0033275 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] Web POS | minor | have not tried | 2016-06-15 14:24 | 2016-06-16 08:46 | |||
Reporter | guilleaer | View Status | public | |||||
Assigned To | Osmany | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | RR16Q3 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 13bc8e2ea388 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | guilleaer | |||||||
OBNetwork customer | No | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0033275: Incremental refresh is nt working fine for product services model | |||||||
Description | Incremental refresh is not working fine for product services model when a product service is done unactive. master queries never should directly filter by isActive. $incrementalUpdateCriteria instead should be used. | |||||||
Steps To Reproduce | Login into web POS Perform the following query in the local DB select * from m_product_service where m_product_service_id = '06B2CFF248AF4C4483EA5AC3A8F892FC' You will see that product service is there. Then make inactive the product_service UPDATE m_product_service set isactive = 'N', updated = now() where m_product_service_id = '06B2CFF248AF4C4483EA5AC3A8F892FC'; Refresh the web POS. Perform the query again in the local DB select * from m_product_service where m_product_service_id = '06B2CFF248AF4C4483EA5AC3A8F892FC' and you will see that the product is still there Error: Product_service should disappear thanks to the incremental refresh | |||||||
Proposed Solution | remove isActive condition from the query. $incrementalUpdateCriteria will add it if it's needed | |||||||
Tags | No tags attached. | |||||||
Attached Files | ![]() | |||||||
![]() |
|
![]() |
|
(0087320) hgbot (developer) 2016-06-15 21:09 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 13bc8e2ea3881a8d3f39e748dbefb3ca80c35b3d Author: Osmany Garcia Machado <osmany.machado <at> peoplewalking.com> Date: Wed Jun 15 13:09:05 2016 -0600 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/13bc8e2ea3881a8d3f39e748dbefb3ca80c35b3d [^] Fixes issue 33275: Incremental refresh is working fine for product services model --- M src/org/openbravo/retail/posterminal/master/ServiceProduct.java M src/org/openbravo/retail/posterminal/master/ServiceProductProperties.java --- |
![]() |
|||
Date Modified | Username | Field | Change |
2016-06-15 14:24 | guilleaer | New Issue | |
2016-06-15 14:24 | guilleaer | Assigned To | => Retail |
2016-06-15 14:24 | guilleaer | OBNetwork customer | => No |
2016-06-15 14:24 | guilleaer | Triggers an Emergency Pack | => No |
2016-06-15 14:27 | guilleaer | File Added: issue33275.diff | |
2016-06-15 15:59 | Osmany | Assigned To | Retail => Osmany |
2016-06-15 21:09 | hgbot | Checkin | |
2016-06-15 21:09 | hgbot | Note Added: 0087320 | |
2016-06-15 21:09 | hgbot | Status | new => resolved |
2016-06-15 21:09 | hgbot | Resolution | open => fixed |
2016-06-15 21:09 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/13bc8e2ea3881a8d3f39e748dbefb3ca80c35b3d [^] |
2016-06-16 08:46 | guilleaer | Review Assigned To | => guilleaer |
2016-06-16 08:46 | guilleaer | Status | resolved => closed |
2016-06-16 08:46 | guilleaer | Fixed in Version | => RR16Q3 |
Copyright © 2000 - 2009 MantisBT Group |