Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0033275
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSminorhave not tried2016-06-15 14:242016-06-16 08:46
ReporterguilleaerView Statuspublic 
Assigned ToOsmany 
PrioritynormalResolutionfixedFixed in VersionRR16Q3
StatusclosedFix in branchFixed in SCM revision13bc8e2ea388
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toguilleaer
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033275: Incremental refresh is nt working fine for product services model

DescriptionIncremental 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 ReproduceLogin 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 Solutionremove isActive condition from the query.
$incrementalUpdateCriteria will add it if it's needed
TagsNo tags attached.
Attached Filesdiff file icon issue33275.diff [^] (1,645 bytes) 2016-06-15 14:27 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(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
---

- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker