TorstenNeumann Absent Member.
Absent Member.
401 views

SQL Rules in multi-language (MLU) configuration

Jump to solution

Hallo,

we have a SQL rule in a request type that sets a field's value (Drop-down validated by list) based on some other field's value. We are in a multi-language environment using German and English.

If the rule is defined with a German text in the selection and someone logs into PPM with an English session, then the rule throws an error message: "Could not set field '<field name >' to value '<some German value>' in Rule 1 - '<Rule Name>'.

Does anyone know a way to make a SQL rule aware of the current session language and select the necessary value accordingly from the KNTA_LOOKUPS_NLS or KNTA_LOOKUPS_LOC table?

I already searched the available documentation with no success.

Thanks for your help!

0 Likes
1 Solution

Accepted Solutions
Micro Focus Expert
Micro Focus Expert

Re: SQL Rules in multi-language (MLU) configuration

Jump to solution

Hi Torsten,

The trick with MLU is to NOT hit the _NLS and _LOC tables, but instead hit the view that will expose the data from these tables using the language of the user currently connected.

So just write your SQL to target the KNTA_LOOKUPS view, and you''ll get the data in whatever language the connected user uses. If this is run without a user (in a background service, or possibly a scheduled report - though I'm not sure about this one), it should use the System Language.

Let me know if that works,

Kind Regards,

Etienne.

 

2 Replies
Micro Focus Expert
Micro Focus Expert

Re: SQL Rules in multi-language (MLU) configuration

Jump to solution

Hi Torsten,

The trick with MLU is to NOT hit the _NLS and _LOC tables, but instead hit the view that will expose the data from these tables using the language of the user currently connected.

So just write your SQL to target the KNTA_LOOKUPS view, and you''ll get the data in whatever language the connected user uses. If this is run without a user (in a background service, or possibly a scheduled report - though I'm not sure about this one), it should use the System Language.

Let me know if that works,

Kind Regards,

Etienne.

 

TorstenNeumann Absent Member.
Absent Member.

Re: SQL Rules in multi-language (MLU) configuration

Jump to solution

Thanks, Etienne! That was it.

I did not know that the user's session language would be the DB session language when rules were used.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.