← All issues
FixedImprovement

#6 Code der Child-Entity in Flat Itegration View

Opened on August 2, 2026 · Fixed in 1.2026.8.2

Ich benutze in einer Parent-Entity eine Child-Entity (Domain) für mehrere Spalten.
Eine Hierarchy Integration View kann diese Spalten nicht enthalten.
Bei der Flat-View wird der DomainValue geliefert.
Ich möchte, dass bei der Flat-View der Code aus der Child-Entity geliefert wird.

We email you when the status changes or Primentra posts an update. Your address stays private.

Replies

Primentra · August 2, 2026

Fixed in 1.2026.8.2 — integration view columns

Thanks for the report — you were right on both points, and both came from the same cause: column names were built from the referenced entity alone, without recording which column reached it.

Where one entity referenced the same domain entity from more than one column, every reference produced identical names and SQL Server rejected the view outright (“Column name ‘Klant_Code’ is specified more than once”), so it was never created. Each reference is now named after the column it came from.

Take an Order with two Domain columns, Factuurklant and Afleverklant, both pointing at Klant. The hierarchy view now gives Factuurklant_Klant_Code, Factuurklant_Klant_Land and so on, alongside Afleverklant_Klant_Code, Afleverklant_Klant_Land. Each reference brings the complete referenced record and the two resolve independently. Where an entity is referenced only once the names stay as they are today (Klant_Code), so existing views are unaffected.

Flat views now expose the referenced record’s code next to its id, so you can join on the key you recognise rather than on our internal row number. Timestamps are no longer emitted twice, and column names no longer pick up stray spaces typed around a name.

One thing to check before upgrading: in flat views, Order_Factuurklant becomes Order_Factuurklant_ID with a new Order_Factuurklant_Code beside it. Existing views keep their current columns until you sync or edit them, so nothing breaks on upgrade — but update anything reading those columns first.