0030505: Compilation in 2.50 mode fails for Navigation Rules tab of Window, Tabs and Fields

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0030505

Openbravo ERP

00. Application dictionary

public

2015-08-06 09:52

2015-08-20 23:16

Reporter

gorkaion

Assigned To

alostale

Priority

immediate

Severity

minor

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

gorkaion

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Automated tests

Regression date

2015-08-05

Regression introduced in release

Regression introduced by commit

http://code.openbravo.com/erp/devel/pi/rev/1f572104e426366ac67e9efc7bd74040f8142ac3 [^]

Triggers an Emergency Pack

Summary

0030505: Compilation in 2.50 mode fails for Navigation Rules tab of Window, Tabs and Fields

Description

There is a compilation error in 2.50 mode.

https://ci.openbravo.com/job/int-full-pgsql-compile-all/601/consoleFull [^]

The issue is in "Window, Tabs and Fields" window when computing the xsql file for the new Navigation Rules tab. In this file it is not generating properly the query to load the identifier of the parent field (AD_Field_id)

Steps To Reproduce

On a pi on changeset 0c08e36aad01. Compile the application in 2.50 mode:

ant compile.complete -Dwad.generateAllClassic250Windows=true

There is a query that it is not correctly generated:
SELECT (TO_CHAR(COALESCE(TO_CHAR((CASE WHEN tableTRL1.Name IS NULL THEN TO_CHAR(table1.Name) ELSE TO_CHAR(tableTRL1.Name) END)), '')) || ' - ' || list1.name) AS NAME
FROM AD_Field left join (select AD_Field_ID, Name, AD_Tab_ID from AD_Field) table1 on (AD_Field.AD_Field_ID = table1.AD_Field_ID)
left join (select AD_Field_ID,AD_Language, Name from AD_Field_TRL) tableTRL1 on (table1.AD_Field_ID = tableTRL1.AD_Field_ID and tableTRL1.AD_Language = ?)
left join ad_ref_list_v list1 on (table2.AD_Tab_ID = list1.value and list1.ad_reference_id = '' and list1.ad_language = ?)
WHERE AD_Field.AD_Field_ID = ?

Proposed Solution

Additional Information