Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0053564Openbravo ERPA. Platformpublic2023-09-28 14:002023-10-06 10:04
Reportercaristu 
Assigned Tocaristu 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0053564: Support mapping date properties showing their values in the Organization Time Zone
DescriptionIt would be nice if it could be possible to define the time zone of a store (organization) and display the audit information (created, updated) of the different records of the Business API records in that time zone, when defined in the corresponding entity mappings.
Steps To Reproduce.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0053358 closed jarmendariz Openbravo ERP Configurable Organization Time Zone 
related to feature request 0053588 new Triage Platform Conn Modules Add missing checks to ensure the correct definition of the property mappings 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-09-28 14:00caristuNew Issue
2023-09-28 14:00caristuAssigned To => caristu
2023-09-28 14:00caristuModules => Core
2023-09-28 14:00caristuTriggers an Emergency Pack => No
2023-09-28 14:00caristuIssue generated from0053358
2023-09-28 14:00caristuRelationship addedrelated to 0053358
2023-09-28 14:03caristuSummaryConfigurable Organization Time Zone => Support mapping created and updated properties with the date in the Organization Time Zone
2023-09-28 14:07hgbotNote Added: 0155351
2023-09-28 15:56hgbotNote Added: 0155355
2023-09-28 15:59caristuSummarySupport mapping created and updated properties with the date in the Organization Time Zone => Support mapping date properties in the Organization Time Zone
2023-09-28 15:59caristuDescription Updatedbug_revision_view_page.php?rev_id=26917#r26917
2023-09-28 16:00caristuSummarySupport mapping date properties in the Organization Time Zone => Support mapping date properties showing their values in the Organization Time Zone
2023-09-28 18:08hgbotNote Added: 0155361
2023-10-04 08:56hgbotNote Added: 0155474
2023-10-04 08:58hgbotNote Added: 0155475
2023-10-04 09:00hgbotNote Added: 0155476
2023-10-04 11:35caristuRelationship addedrelated to 0053588
2023-10-05 08:21hgbotNote Added: 0155534
2023-10-05 08:21hgbotResolutionopen => fixed
2023-10-05 08:21hgbotStatusnew => closed
2023-10-05 08:21hgbotNote Added: 0155535
2023-10-05 08:25hgbotNote Added: 0155536
2023-10-05 08:25hgbotNote Added: 0155537
2023-10-05 08:25hgbotNote Added: 0155538
2023-10-05 08:26hgbotNote Added: 0155539
2023-10-05 08:26hgbotNote Added: 0155540
2023-10-05 08:28hgbotNote Added: 0155541
2023-10-05 08:28hgbotNote Added: 0155542
2023-10-05 08:28hgbotNote Added: 0155543
2023-10-05 08:28hgbotNote Added: 0155544
2023-10-05 08:29hgbotNote Added: 0155545
2023-10-05 08:29hgbotNote Added: 0155546
2023-10-06 10:01hgbotNote Added: 0155615
2023-10-06 10:04hgbotNote Added: 0155616

Notes
(0155351)
hgbot   
2023-09-28 14:07   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.service.external.integration/-/merge_requests/34 [^]
(0155355)
hgbot   
2023-09-28 15:56   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/190 [^]
(0155361)
hgbot   
2023-09-28 18:08   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.service.external.integration.tests/-/merge_requests/19 [^]
(0155474)
hgbot   
2023-10-04 08:56   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/merge_requests/77 [^]
(0155475)
hgbot   
2023-10-04 08:58   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api.giftcards/-/merge_requests/26 [^]
(0155476)
hgbot   
2023-10-04 09:00   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/merge_requests/23 [^]
(0155534)
hgbot   
2023-10-05 08:21   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.service.external.integration/-/merge_requests/34 [^]
(0155535)
hgbot   
2023-10-05 08:21   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.service.external.integration [^]
Changeset: 4074c84d1167cd0eac564f5e1d80da96da9e2a5c
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 05-10-2023 06:03:18
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.service.external.integration/-/commit/4074c84d1167cd0eac564f5e1d80da96da9e2a5c [^]

fixes FR-53564: support mapping dates in organization time zone

---
A src/org/openbravo/service/external/integration/mapping/OrganizationDateTimeDirectPropertyMapping.java
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/OBEI_PROPERTY_MAPPING_CLASS.xml
M src-db/database/sourcedata/OBEI_PROP_MAP_CLASS_IMPL.xml
M src/org/openbravo/service/external/integration/handler/PropertyMappingInstanceEventHandler.java
M src/org/openbravo/service/external/integration/mapping/DateDirectPropertyMapping.java
M src/org/openbravo/service/external/integration/mapping/DatePropertyFormatter.java
---
(0155538)
hgbot   
2023-10-05 08:25   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/190 [^]
(0155537)
hgbot   
2023-10-05 08:25   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: 73c66c01ce668d490af8eecaa58bc986b3df52fd
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 05-10-2023 08:22:26
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/73c66c01ce668d490af8eecaa58bc986b3df52fd [^]

related to FR-53564: add localCreationDate and localUpdationDate properties

---
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
---
(0155536)
hgbot   
2023-10-05 08:25   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: ce8c17b5d93cb8866df294451dced2926d4abd5a
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 05-10-2023 06:03:33
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/ce8c17b5d93cb8866df294451dced2926d4abd5a [^]

related FR-53564: add documentation for the OrganizationDateTimeDirectPropertyMapping

---
M src/org/openbravo/api/openapi/OpenApiEntityMapping.java
---
(0155539)
hgbot   
2023-10-05 08:26   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.service.external.integration.tests [^]
Changeset: aae031985d7dbf679c1c2cd209b717db00ef6e85
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 28-09-2023 18:20:00
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.service.external.integration.tests/-/commit/aae031985d7dbf679c1c2cd209b717db00ef6e85 [^]

related FR-53564: add test case

---
A src-test/org/openbravo/service/external/integration/test/export/GoodsShipmentExportTest.java
M src-db/database/sourcedata/OBEI_ENTITY_MAPPING.xml
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
M src-test/org/openbravo/service/external/integration/test/ExternalIntegrationTestSuite.java
M src-test/org/openbravo/service/external/integration/test/TestConstants.java
M src-test/org/openbravo/service/external/integration/test/export/PropertiesExportTest.java
---
(0155540)
hgbot   
2023-10-05 08:26   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.service.external.integration.tests/-/merge_requests/19 [^]
(0155541)
hgbot   
2023-10-05 08:28   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api [^]
Changeset: 1ba48e5e785d855b0ab19554b6562f167dd270b5
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 05-10-2023 06:28:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/commit/1ba48e5e785d855b0ab19554b6562f167dd270b5 [^]

related to FR-53564: add localCreationDate and localUpdationDate properties to CashUp

---
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
---
(0155542)
hgbot   
2023-10-05 08:28   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/merge_requests/77 [^]
(0155543)
hgbot   
2023-10-05 08:28   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api.giftcards/-/merge_requests/26 [^]
(0155544)
hgbot   
2023-10-05 08:28   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api.giftcards [^]
Changeset: ca1145d410b22a0c02de888d71ac8b4cee11296e
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 05-10-2023 06:28:41
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api.giftcards/-/commit/ca1145d410b22a0c02de888d71ac8b4cee11296e [^]

related to FR-53564: add localCreationDate and localUpdationDate properties

---
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
---
(0155545)
hgbot   
2023-10-05 08:29   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api [^]
Changeset: 762ca3c44add77442f1580b2f0c0db775e90e907
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 05-10-2023 06:29:04
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/commit/762ca3c44add77442f1580b2f0c0db775e90e907 [^]

related to FR-53564: add localCreationDate and localUpdationDate properties

---
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
---
(0155546)
hgbot   
2023-10-05 08:29   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/merge_requests/23 [^]
(0155615)
hgbot   
2023-10-06 10:01   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.service.external.integration [^]
Changeset: 6f0b58b0c49042c211ba97cf831b3aad9d00e45f
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 06-10-2023 10:00:50
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.service.external.integration/-/commit/6f0b58b0c49042c211ba97cf831b3aad9d00e45f [^]

related to FR-53564: support mapping also for the Organization entity

---
M src/org/openbravo/service/external/integration/mapping/OrganizationDateTimeDirectPropertyMapping.java
---
(0155616)
hgbot   
2023-10-06 10:04   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: bb359229907ca953158dde5f7cb8ebec9bdd8b77
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 06-10-2023 10:03:29
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/bb359229907ca953158dde5f7cb8ebec9bdd8b77 [^]

related to FR-53564: add localCreationDate and localUpdationDate in Organization mapping

---
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
---