Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0033275 | Retail Modules | Web POS | public | 2016-06-15 14:24 | 2016-06-16 08:46 |
|
| Reporter | guilleaer | |
| Assigned To | Osmany | |
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | RR16Q3 | |
| Merge Request Status | |
| Review Assigned To | guilleaer |
| OBNetwork customer | |
| 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 |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  issue33275.diff (1,645) 2016-06-15 14:27
https://issues.openbravo.com/file_download.php?file_id=9528&type=bug |
|
| Issue History |
| 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 | 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 |