Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0048665ModulesExternal Integration Infrastructurepublic2022-02-23 18:052022-03-31 11:11
Reportercaristu 
Assigned Tocaristu 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0048665: Improve EntityPropertyMapping to support exporting a subset of properties
DescriptionIt would be nice if the EntityPropertyMapping would have support for selecting a subset of properties of the referenced entity when exporting. Currently all the properties defined in the mapping are being exported.

See additional info here: https://docs.google.com/document/d/1EhNjp4WrVTon3gAXnRfdr6a70N4hs10xfJ1a_wZP8wI/edit [^]
Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0048579 closed caristu Openbravo ERP Push API 
related to defect 0048864 closed Sandrahuguet Modules Select On Entity Referencing field have wrong display logic 
related to feature request 0054979 closed ignacio_deandres Modules Add 'Only As Information' Option for 'Selected Properties On Entity Referencing' Functionality 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-02-23 18:05caristuNew Issue
2022-02-23 18:05caristuAssigned To => caristu
2022-02-24 19:44hgbotNote Added: 0135296
2022-02-24 19:57hgbotNote Added: 0135298
2022-02-25 12:39hgbotNote Added: 0135317
2022-03-02 10:40caristuRelationship addedrelated to 0048579
2022-03-07 10:38hgbotResolutionopen => fixed
2022-03-07 10:38hgbotStatusnew => closed
2022-03-07 10:38hgbotNote Added: 0135481
2022-03-07 10:38hgbotNote Added: 0135482
2022-03-07 10:38hgbotNote Added: 0135483
2022-03-07 10:38hgbotNote Added: 0135484
2022-03-07 10:38hgbotNote Added: 0135485
2022-03-07 10:38hgbotNote Added: 0135486
2022-03-31 11:11hgbotNote Added: 0136206
2022-05-18 17:29caristuRelationship addedrelated to 0048864
2024-03-18 12:10ignacio_deandresRelationship addedrelated to 0054979

Notes
(0135296)
hgbot   
2022-02-24 19:44   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.service.external.integration/-/merge_requests/11 [^]
(0135298)
hgbot   
2022-02-24 19:57   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.service.external.integration.tests/-/merge_requests/6 [^]
(0135317)
hgbot   
2022-02-25 12:39   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/5 [^]
(0135481)
hgbot   
2022-03-07 10:38   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.service.external.integration [^]
Changeset: 26161510a960d6563636662f8e14c8335a4c4b9e
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 04-03-2022 16:16:48
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.service.external.integration/-/commit/26161510a960d6563636662f8e14c8335a4c4b9e [^]

fixes ISSUE-48665: Improve EntityPropertyMapping

  Improve EntityPropertyMapping to support exporting a subset of properties

---
M src-db/database/model/tables/OBEI_ENTITY_MAPPING.xml
M src-db/database/model/tables/OBEI_PROP_MAP_INSTANCE.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-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src/org/openbravo/service/external/integration/datasource/JavaPropertyMappingHandlerDS.java
M src/org/openbravo/service/external/integration/export/DalSynchronizableBusinessObjectExporter.java
M src/org/openbravo/service/external/integration/export/RetailApiSynchronizableBusinessObjectExporter.java
M src/org/openbravo/service/external/integration/export/SynchronizableBusinessObjectExporter.java
M src/org/openbravo/service/external/integration/handler/PropertyMappingInstanceEventHandler.java
M src/org/openbravo/service/external/integration/mapping/EntityPropertyMapping.java
M src/org/openbravo/service/external/integration/mapping/ExportJavaPropertyMappingHandler.java
M src/org/openbravo/service/external/integration/mapping/PropertyMapper.java
M src/org/openbravo/service/external/integration/mapping/PropertyMapping.java
---
(0135482)
hgbot   
2022-03-07 10:38   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.service.external.integration/-/merge_requests/11 [^]
(0135483)
hgbot   
2022-03-07 10:38   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.service.external.integration.tests [^]
Changeset: 566e3ff4560866ed1637232bfb9bad0396d58b62
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 04-03-2022 14:40:42
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.service.external.integration.tests/-/commit/566e3ff4560866ed1637232bfb9bad0396d58b62 [^]

related to ISSUE-48665: Tests for property selection in EntityPropertyMapping

---
A src-test/org/openbravo/service/external/integration/test/property_mappings/export/OrganizationExportJavaPropertyMapping.java
M src-db/database/sourcedata/OBEI_ENTITY_MAPPING.xml
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
M src-test/data/exported_USA_and_ES.json
M src-test/data/exported_france_excluded.json
M src-test/org/openbravo/service/external/integration/test/TestConstants.java
M src-test/org/openbravo/service/external/integration/test/datasource/JavaPropertyMappingHandlerDSTest.java
---
(0135484)
hgbot   
2022-03-07 10:38   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.service.external.integration.tests/-/merge_requests/6 [^]
(0135485)
hgbot   
2022-03-07 10:38   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: 55b71d967c01d8c67a3ee07912e7b1220785667e
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 04-03-2022 15:25:25
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/55b71d967c01d8c67a3ee07912e7b1220785667e [^]

related to ISSUE-48665: show entity property mappings with the new format

  When there are selected properties on referenced entities when
exporting, now this results in two differen properties:

  - propertyName: with the property selected as identifier
  - propertyName_info: with the rest of the selected properties

---
M src/org/openbravo/api/openapi/OpenApiEntityMapping.java
---
(0135486)
hgbot   
2022-03-07 10:38   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/5 [^]
(0136206)
hgbot   
2022-03-31 11:11   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.service.external.integration [^]
Changeset: 1135f78b2de9173911f7f388e9fc2818e035df6f
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 31-03-2022 10:32:25
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.service.external.integration/-/commit/1135f78b2de9173911f7f388e9fc2818e035df6f [^]

related to BUG-48665: add id property only if there is not a mapping for it

---
M src/org/openbravo/service/external/integration/mapping/EntityPropertyMapping.java
---