microsoft / microsoft/BCApps

[Bug]: Transformation Rule default Codes are translated (not Locked), causing inconsistent Code values across language installations

Open Beginner friendly
#9,192 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Approved Team: Integrations
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
  1. Install on an en-US environment and on a non-English one.
  2. Open the "Transformation Rules" page on both.
  3. 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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.