Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0045931Openbravo ERP00. Application dictionarypublic2021-02-20 14:322021-03-24 07:31
Production - QA Approved
PR21Q1 [^]
0045931: Create Fields button in Window, tabs and fields-Tab not working (0 fields created)
It is not possible to create fields in a tab anymore using the 'Create Fields' procedure (AD_TAB_IMPORT0)
Create a window with a tab based on the C_BPARTNER table for example.
Click on button 'Create Fields'
-> 0 Fields created
The problem is in the AD_TAB_IMPORT function.

You added a join on the USER_TAB_COLUMNS in last version and you do a join on the name of the table and name of the column

In the USER_TAB_COLUMN, all the names (tablename and columnname) are uppercased!

When you join on the tablename and columnname, use UPPER() on both.
-> utc.table_name = UPPER(t.tablename) AND utc.column_name = UPPER(c.Columnname)

I can only guess that this change was not tested at all... The only way to make it work would be that the table name and column names would all be in uppercase in the dictionnary (and it is not the case)
No tags attached.
depends on backport 0046126PR21Q1.1 closed cberner Create Fields button in Window, tabs and fields-Tab not working (0 fields created) 
caused by feature request 0044155 closed platform Make DBSM support Postgres tsvector column 
Issue History
2021-02-20 14:32neil_smithNew Issue
2021-02-20 14:32neil_smithAssigned To => platform
2021-02-20 14:32neil_smithModules => Core
2021-02-20 14:32neil_smithTriggers an Emergency Pack => No
2021-03-23 13:36cbernerAssigned Toplatform => cberner
2021-03-23 13:40cbernerRegression level => Production - QA Approved
2021-03-23 13:40cbernerRegression date => 2020-11-27
2021-03-23 13:40cbernerRegression introduced in release => PR21Q1
2021-03-23 13:40cbernerRegression introduced by commit => [^]
2021-03-23 13:40cbernerSeveritycritical => major
2021-03-23 13:57hgbotNote Added: 0126850
2021-03-24 06:54alostaleRelationship addedcaused by 0044155
2021-03-24 07:00alostaleStatusnew => scheduled
2021-03-24 07:31hgbotNote Added: 0126873
2021-03-24 07:31hgbotResolutionopen => fixed
2021-03-24 07:31hgbotStatusscheduled => closed
2021-03-24 07:31hgbotFixed in Version => PR21Q2
2021-03-24 07:31hgbotNote Added: 0126874

2021-03-23 13:57   
Merge Request created: [^]
2021-03-24 07:31   
Merge request merged: [^]
2021-03-24 07:31   
Directly closing issue as related merge request is already approved.

Repository: [^]
Changeset: 63037b074faa4b3dfa847e9b6f3bbd5bf1da2a1b
Author: Cristian Berner <>
Date: 2021-03-24T06:09:41+00:00
URL: [^]

Fixes ISSUE-45931: Create Fields button in Window -> tabs not working (0 fields created)

This issue was due to a modification on the selection query to detect
which fields should be added, from the columns of the underlying table.
A new join was added with table user_tab_column, but it was incorrect,
as one part of it was always in upper case, while the other part was not.

To fix it, an UPPER() function has been added to the corresponding where
clauses that required it.

Fixes regression introduced by commit 809d27effffdab2849401ef6ae46b0887286d4f3

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