Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0044155Openbravo ERPY. DBSourceManagerpublic2020-05-22 11:462020-12-01 10:39
ReporterioritzCia 
Assigned Toplatform 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR21Q1 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0044155: Make DBSM support Postgres tsvector column
DescriptionMake DBSM support Postgres tsvector column

http://wiki.openbravo.com/wiki/Projects/Full_Text_Search/Technical_Documentation [^]
Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
causes defect 0045529 closed cberner Search Vector reference is missing a User Interface Definition 
causes defect 0045530 closed alostale UISearchVector extends UITableDir 
causes defect 0045931 closed cberner Create Fields button in Window, tabs and fields-Tab not working (0 fields created) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-05-22 11:46ioritzCiaNew Issue
2020-05-22 11:46ioritzCiaAssigned To => platform
2020-05-22 11:46ioritzCiaWeb browser => Google Chrome
2020-05-22 11:46ioritzCiaModules => Core
2020-05-22 11:46ioritzCiaTriggers an Emergency Pack => No
2020-11-27 12:02hgbotNote Added: 0124651
2020-11-27 12:02hgbotNote Added: 0124652
2020-11-27 12:29hgbotResolutionopen => fixed
2020-11-27 12:29hgbotStatusnew => closed
2020-11-27 12:29hgbotNote Added: 0124653
2020-11-27 12:29hgbotFixed in Version => PR21Q1
2020-11-27 12:29hgbotNote Added: 0124654
2020-12-01 10:12hgbotNote Added: 0124668
2020-12-01 10:34cbernerRelationship addedcauses 0045529
2020-12-01 10:39hgbotNote Added: 0124670
2020-12-01 11:23alostaleRelationship addedcauses 0045530
2021-03-24 06:54alostaleRelationship addedcauses 0045931

Notes
(0124651)
hgbot   
2020-11-27 12:02   
Repository: https://gitlab.com/openbravo/product/dbsm [^]
Changeset: 7bfa9f07b0feeddee23d1ac54c4f7178fcd1356a
Author: Asier Lostalé <asier.lostale@openbravo.com>
Date: 2020-11-27T12:00:51+01:00
URL: https://gitlab.com/openbravo/product/dbsm/-/commit/7bfa9f07b0feeddee23d1ac54c4f7178fcd1356a [^]

related to FR-44155: support for pg full text search

MR !10

---
A src-test/data/datachanges/fullTextSearch/TEST.xml
A src-test/model/fullTextSearch/BASE_MODEL.xml
A src-test/src/org/openbravo/dbsm/test/model/TSVectorColumn.java
M src-test/src/org/openbravo/dbsm/test/model/ModelSuite.java
M src/database.dtd
M src/org/apache/ddlutils/model/TypeMap.java
M src/org/apache/ddlutils/platform/PlatformImplBase.java
M src/org/apache/ddlutils/platform/oracle/OracleBuilder.java
M src/org/apache/ddlutils/platform/oracle/OracleModelLoader.java
M src/org/apache/ddlutils/platform/oracle/OraclePlatform.java
M src/org/apache/ddlutils/platform/postgresql/PostgreSqlModelLoader.java
M src/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java
M src/org/apache/ddlutils/util/ExtTypes.java
M src/org/openbravo/ddlutils/task/ImportSampledata.java
---
(0124652)
hgbot   
2020-11-27 12:02   
Merge request merged: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/10 [^]
(0124653)
hgbot   
2020-11-27 12:29   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/88 [^]
(0124654)
hgbot   
2020-11-27 12:29   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: a6119cf9a4f14d3643bb706231f841a8246ca24c
Author: Asier Lostalé <asier.lostale@openbravo.com>
Date: 2020-11-27T12:28:16+01:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/a6119cf9a4f14d3643bb706231f841a8246ca24c [^]

fixed FR-44155: support full text search in PostgreSQL

MR !88

---
A modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/PgFullTextSearchFunction.java
A src/org/openbravo/reference/ui/UISearchVector.java
M modules/org.openbravo.client.application/src/org/openbravo/client/application/CachedPreference.java
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/KernelSQLFunctionRegister.java
M src-db/database/lib/dbsourcemanager.jar
M src-db/database/model/functions/AD_TABLE_IMPORT.xml
M src-db/database/model/functions/AD_TAB_IMPORT.xml
M src-db/database/model/triggers/AD_FIELD_MOD_TRG.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src/org/openbravo/base/gen/entity.ftl
M src/org/openbravo/base/model/Entity.java
M src/org/openbravo/dal/core/DalMappingGenerator.java
M src/org/openbravo/service/dataset/DataSetService.java
M src/org/openbravo/service/system/DatabaseValidator.java
---
(0124668)
hgbot   
2020-12-01 10:12   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/250 [^]
(0124670)
hgbot   
2020-12-01 10:39   
Merge request closed: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/250 [^]