translation on report or sql and inifs

The result of PAYMENT_TERM_API.Get_Description(COMPANY,PAY_TERM_ID) is in french in IFS in french and when i call the sames API in Armony solution or SQL in have the result in English.

I don’t understand why.

Even more that i have put the translation in the menu Application Base Setup\Enterprise\Company\System Manager Functions\Company Attribute Translations for the company in use, the module ‘ACCRUL’ and the logical unit ‘Payment term’.

Hi ​@Julien T. :

Have you tried adding the “Accept-Language” property to the REST API header? :

In SQL, you can temporarily switch to French by executing this PL/SQL block before executing your SQL query:

BEGIN
	IFSAPP.Log_SYS.Init_Debug_Session_('fr');
END;

Best Regards,

Théo

This is the only SQL request on wich i have this problem.

Now when i am doing this request in IFS on SQL, i have the response in french.

I have still the problem with SQLDELOPPER and Armony Report.

​@Julien T. ,

Yes, this is normal behavior.

A new ORACLE session is not automatically in French.

Before executing your SQL query in SQL Developer, execute this block: 

BEGIN
	IFSAPP.Log_SYS.Init_Debug_Session_('fr');
END;

In Armony, upstream of your script, you can try calling the “IFSSetLanguage” tag.

I put this in Armony :

  <Value BackColor="transparent" FontName="[DefaultFont]" VAlign="Center" HAlign="Left" FontSize="9" Bold="True" Line.DashStyle.Top="None" IFSSetlanguage= "fr" Condition = "'[Langage]' = 'fr'">
                        <p>Règlement par: [FACTURE.descr_paiement] [FACTURE.desc_condition_paiement]</p>
                    </Value>

but the restitution of the field  [FACTURE.desc_condition_paiement] is still in English.