Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038599ModulesAdvanced Warehouse Operationspublic2018-05-22 18:322018-07-19 14:48
Reporterdmiguelez 
Assigned Toguilleaer 
PriorityurgentSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Tomarvintm
Support ticket
OBNetwork customerOBPS
Regression introduced in release
Summary0038599: Not possible to log in AWO Front End if an attribute value has '/n'
DescriptionNot possible to log in AWO Front End if an attribute value has '/n'

The attribute value should not have this value, however, this should be also controlled in AWO FE, if not, the application can be broken
Steps To ReproduceWith AWO and AWO SampleData installed

Go to Goods Receipt Window and create a record with:
  * Organization: US West Coast
  * Business Partner: Be Soft Drinker
  * Warehouse: US West Coast
Move to lines and create a new one with:
  * Product: Apple
  * Operative Quantity: 10
  * Attribute Set Value:
    - First, click on the X to remove existing attribute
    - Create a new one with: 'Test [Enter]'. By clicking on enter it will introduce a '\n' character
Complete the Document

Go to Warehouse Operations Window and select the previously created Stock
Click on Put-Away and assign it to Openbravo

Log in the Front-End with Openbravo.
A Json Error is thrown and it is not possible to log in the application
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0038751 closed guilleaer Modules [AWOFE] obawo_getjsondescription PLSQL function is already in core. Use it and remove from awo module 
related to defect 0038757 new AtulOpenbravo Openbravo ERP Strange characters like "line break" are being accepted as attribute value 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-05-22 18:32dmiguelezNew Issue
2018-05-22 18:32dmiguelezAssigned To => dmiguelez
2018-05-22 18:32dmiguelezResolution time => 1526076000
2018-05-22 18:32dmiguelezOBNetwork customer => Yes
2018-05-22 19:00dmiguelezResolution time1526076000 => 1528754400
2018-05-22 19:00dmiguelezAssigned Todmiguelez => guilleaer
2018-06-13 13:41hgbotCheckin
2018-06-13 13:41hgbotNote Added: 0105125
2018-06-13 13:41hgbotStatusnew => resolved
2018-06-13 13:41hgbotResolutionopen => fixed
2018-06-13 13:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/3f5b8647c2f40875a09263b6686d4466434c9cf7 [^]
2018-06-13 15:20guilleaerRelationship addedrelated to 0038751
2018-06-13 15:20guilleaerNote Added: 0105127
2018-06-13 15:20guilleaerStatusresolved => new
2018-06-13 15:20guilleaerResolutionfixed => open
2018-06-13 16:53hgbotCheckin
2018-06-13 16:53hgbotNote Added: 0105130
2018-06-13 16:53hgbotStatusnew => resolved
2018-06-13 16:53hgbotResolutionopen => fixed
2018-06-13 16:53hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/3f5b8647c2f40875a09263b6686d4466434c9cf7 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/14df8fa5237c719d570e43c7ec10eae3846e2c0b [^]
2018-06-14 11:10guilleaerRelationship addedrelated to 0038757
2018-06-14 16:15hgbotCheckin
2018-06-14 16:15hgbotNote Added: 0105146
2018-06-14 17:38hgbotCheckin
2018-06-14 17:38hgbotNote Added: 0105148
2018-06-18 09:58marvintmReview Assigned To => marvintm
2018-06-18 09:58marvintmStatusresolved => closed
2018-07-19 14:48hgbotCheckin
2018-07-19 14:48hgbotNote Added: 0105806
2018-07-19 14:48hgbotCheckin
2018-07-19 14:48hgbotNote Added: 0105807
2022-09-06 17:18caristuCategoryAdvance Warehouse Operations => Advanced Warehouse Operations

Notes
(0105125)
hgbot   
2018-06-13 13:41   
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: 3f5b8647c2f40875a09263b6686d4466434c9cf7
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Wed Jun 13 13:41:32 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/3f5b8647c2f40875a09263b6686d4466434c9cf7 [^]

Fixed issue 38599: JSON not valid characters are escaped or encoded for att values

---
M src-db/database/model/functions/OBAWO_GETJSONDESCRIPTION.xml
---
(0105127)
guilleaer   
2018-06-13 15:20   
backouted
(0105130)
hgbot   
2018-06-13 16:53   
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: 14df8fa5237c719d570e43c7ec10eae3846e2c0b
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Wed Jun 13 16:53:26 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/14df8fa5237c719d570e43c7ec10eae3846e2c0b [^]

Fixed issue 38599: Fixed translation problems between xml & PLSQL

---
M src-db/database/model/functions/OBAWO_GETJSONDESCRIPTION.xml
---
(0105146)
hgbot   
2018-06-14 16:15   
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations.sampledata
Changeset: d80e388e07d127834ece94740c8849d45f5dffbc
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu Jun 14 15:52:33 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations.sampledata/rev/d80e388e07d127834ece94740c8849d45f5dffbc [^]

Related to issue 38599: Add test case to ensure that special characters are escaped by getjsondescription

---
M referencedata/sampledata/AWO_QA/M_ATTRIBUTEINSTANCE.xml
M referencedata/sampledata/AWO_QA/M_ATTRIBUTESETINSTANCE.xml
---
(0105148)
hgbot   
2018-06-14 17:38   
Repository: erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: 1a35877211c98fb819a29e2e5193e3703df1dd83
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu Jun 14 17:38:26 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.advancedwarehouseoperations/rev/1a35877211c98fb819a29e2e5193e3703df1dd83 [^]

Related to issue 38599, 38751: Add tests for issue 38599. Use core function (issue 38751)

---
M src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/AWOo_JsonDescription.java
---
(0105806)
hgbot   
2018-07-19 14:48   
Repository: retail/backports/AWO/3.0RR17Q4/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: 37b36e65a20c8f86d1619d0ae2002afe916fa433
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu Jul 19 14:48:06 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR17Q4/org.openbravo.warehouse.advancedwarehouseoperations/rev/37b36e65a20c8f86d1619d0ae2002afe916fa433 [^]

Related to issue 38599: [backport 17Q4] JSON not valid characters are escaped or encoded for att values

---
M src-db/database/model/functions/OBAWO_GETJSONDESCRIPTION.xml
---
(0105807)
hgbot   
2018-07-19 14:48   
Repository: retail/backports/AWO/3.0RR18Q1/org.openbravo.warehouse.advancedwarehouseoperations
Changeset: ff951a177d71535fb849e341ebbdc254b1f850f4
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Thu Jul 19 14:46:12 2018 +0200
URL: http://code.openbravo.com/retail/backports/AWO/3.0RR18Q1/org.openbravo.warehouse.advancedwarehouseoperations/rev/ff951a177d71535fb849e341ebbdc254b1f850f4 [^]

Related to issue 38599: [backport 18Q1] <?xml version=1.0?>

---
M src-db/database/model/functions/OBAWO_GETJSONDESCRIPTION.xml
---