[Bug]: Transformation Rule default Codes are translated (not Locked), causing inconsistent Code values across language installations
Nobody has claimed this yet.
- Dominant language
- AL
- Stars
- 683
- Forks
- 459
- Avg merge
- 3d 26m
- Merged PRs (30d)
- 633
Description
Describe the issue
Table 1237 "Transformation Rule" (namespace System.IO) seeds its default rules in CreateDefaultTransformations() using labels for the Code field (UPPERCASETxt, LOWERCASETxt, TITLECASETxt, TRIMTxt, ...).
None of these labels are marked Locked = true, so the literal text stored in the Code field which is the table's primary key gets translated according to the environment's installation/UI language.
Expected behavior
Code values must stay constant regardless of installation language only Description
should be translated. These labels should be marked Locked = true, since Code is a
primary key referenced by other objects/configurations as a fixed identifier.
Steps to reproduce
- Install on an en-US environment and on a non-English one.
- Open the "Transformation Rules" page on both.
- Compare the Code column for the same rule (e.g. Uppercase) the value differs
between environments instead of staying constant.
Additional context
No response
I will provide a fix for a bug
- I will provide a fix for a bug
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start in Table 1237 "Transformation Rule" and locate CreateDefaultTransformations(), where the default Code values use labels such as UPPERCASETxt and TRIMTxt. Check how the Code and Description labels are defined and verify the resulting values in English and non-English installations. Done means Code values remain identical across languages while only Description is translated.
Written by the indexing model from the issue text.
Assessment
- Domain
- databases, localization
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Quiet
- Clarity
- Clearly specified
- Newbie friendliness
- 68/100