Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032903Retail ModulesWeb POSpublic2015-08-24 14:592016-06-03 11:01
Reportermarvintm 
Assigned Toranjith_qualiantech_com 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR16Q2Fixed in VersionRR16Q2 
Merge Request Status
Review Assigned Toguilleaer
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032903: The JSON column in the Log Client table is redundant, and takes too much space
DescriptionCurrently we are saving the full JSON information in the log client table, and this column is redundant (it's information is already present in the rest of the columns). It should be removed so that the table takes less space.

Also, in the request the information seems to be redundant also, and it could be simplified to consume less bandwidth.
Steps To Reproduce- Login in the POS and do some actions to trigger log messages.
- Verify that in the request to the backend, the information is duplicated.
- Verify that the information in the JSON column in the backend, and the information in the rest of the columns is the same, so the JSON column could be deleted.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0030652 closed ranjith_qualiantech_com The JSON column in the Log Client table is redundant, and takes too much space 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-05-09 11:46marvintmTypedefect => backport
2016-05-09 11:46marvintmTarget Version => RR16Q2
2016-05-09 12:56hgbotCheckin
2016-05-09 12:56hgbotNote Added: 0086308
2016-05-09 12:57hgbotCheckin
2016-05-09 12:57hgbotNote Added: 0086309
2016-05-09 12:57hgbotStatusscheduled => resolved
2016-05-09 12:57hgbotResolutionopen => fixed
2016-05-09 12:57hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/51f93b1cb56ff2bf45c25602211797831ac71a5f [^] => http://code.openbravo.com/retail/backports/3.0RR16Q2/org.openbravo.mobile.core/rev/b2348b588236d9f9c6d86e6bad1ffa88be97706f [^]
2016-06-03 11:01guilleaerReview Assigned Tomarvintm => guilleaer
2016-06-03 11:01guilleaerStatusresolved => closed
2016-06-03 11:01guilleaerFixed in Version => RR16Q2

Notes
(0086308)
hgbot   
2016-05-09 12:56   
Repository: retail/backports/3.0RR16Q2/org.openbravo.retail.posterminal
Changeset: d9fdb09f41584dcaba952ff35db2b21740ac0ea3
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Mon May 09 16:24:36 2016 +0530
URL: http://code.openbravo.com/retail/backports/3.0RR16Q2/org.openbravo.retail.posterminal/rev/d9fdb09f41584dcaba952ff35db2b21740ac0ea3 [^]

Related to issue 32903 : Renaming Log client column from "online" to "isOnline"

---
M web/org.openbravo.retail.posterminal/js/login/model/login-model.js
---
(0086309)
hgbot   
2016-05-09 12:57   
Repository: retail/backports/3.0RR16Q2/org.openbravo.mobile.core
Changeset: b2348b588236d9f9c6d86e6bad1ffa88be97706f
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Mon Mar 28 14:56:36 2016 +0530
URL: http://code.openbravo.com/retail/backports/3.0RR16Q2/org.openbravo.mobile.core/rev/b2348b588236d9f9c6d86e6bad1ffa88be97706f [^]

Fixes issue 32903 : Removing "json" column from Mobile Core Log table

---
M src-db/database/model/tables/OBMOBC_LOGCLIENT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/mobile/core/utils/LogClientLoader.java
M web/org.openbravo.mobile.core/source/model/logclient.js
M web/org.openbravo.mobile.core/source/model/ob-terminal-model.js
M web/org.openbravo.mobile.core/source/utils/logClientSyncUtils.js
M web/org.openbravo.mobile.core/source/utils/ob-utilities.js
---