0012770: Messages

Description

I have customized a stored procedure, i raise an error coded on ad_message and the message is in a module with language 'it_IT':
example Raise '%', '@IT_XXX@';

On the application the message isn't decodified but it show '@IT_XXX@'.
I have analyzed the code and the message is called from Utility.parseTranslation that at the end in the method messageBD(ConnectionProvider conn, String strCode, String strLanguage) calls the statement :
MessageBDData.messageLanguage(conn, strCode, strLanguage);
but this method isn't correct if you have a module with language different from 'en_US'.

Steps To Reproduce

Create a module with language different from 'en_US',
Create a message associated to this module.
Raise in exception this message from a stored procedure , i.e. c_invoice_post.

Proposed Solution

Change in the file MessageBD_data, in the method <SqlMethod name="messageLanguage" type="preparedStatement" return="String" default="">
the row
SELECT AD_MESSAGE_TRL.MSGTEXT
with the row
SELECT COALESCE(AD_MESSAGE_TRL.MSGTEXT, AD_MESSAGE.MSGTEXT) as MSGTEXT

Issue History
Date Modified	Username	Field	Change
2010-03-23 10:08	FrancescoFinamore	New Issue
2010-03-23 10:08	FrancescoFinamore	Assigned To	=> alostale
2017-04-10 14:39	alostale	Assigned To	alostale => platform
2022-02-01 08:08	alostale	Assigned To	platform => Triage Platform Base

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.