Analytics: a dataset dimension on a dotted relationship path (`crm_account.industry`) renders raw stored values — the same field as a local dimension renders its option labels

[yinlianghui]

Summary

A DatasetDimension whose field is a dotted relationship path gets no select-option resolution at all: the chart plots the raw stored values (education, finance, manufacturing). The same underlying field, reached as a local dimension on the object that owns it, resolves to its option labels (Education, Finance, Manufacturing).

Both render side by side on one dashboard, so the inconsistency is visible without leaving the screen.

Evidence

@objectstack/* 17.0.0-rc.1, fresh database, admin user. One dashboard (executive_dashboard), two widgets, both grouping on crm_account.industry:

Widget A — joined dimension → raw values

{ id: 'revenue_by_industry', type: 'donut',
 dataset: 'opportunity_metrics', dimensions: ['account_industry'], values: ['total_amount'] }

where the dataset declares

{ name: 'account_industry', label: 'Account Industry', field: 'crm_account.industry', type: 'string' }

renders its legend as:

education finance healthcare manufacturing software technology

Widget B — local dimension → option labels

{ id: 'accounts_by_industry', type: 'table',
 dataset: 'account_metrics', dimensions: ['industry'], values: ['annual_revenue_sum', 'account_count'] }

where the dataset declares

{ name: 'industry', label: 'Industry', field: 'industry', type: 'string' }

renders its rows as:

Education Energy & Utilities Finance Healthcare Logistics Manufacturing Software / SaaS Technology

Same field, same dashboard, same request. The only difference is field: 'crm_account.industry' vs field: 'industry'.

The option values on crm_account.industry are education / finance / … with labels Education / Finance / …, so widget A's output is exactly the stored column, unresolved.

Mechanism

The label resolver appears to look the select options up on the dataset's own object. For a dotted field, the options live on the related object (crm_account), the lookup misses, and the renderer falls through to the stored value. Nothing errors, so the widget just quietly displays database enum values to end users.

DatasetDimension has no key to help here — its whole surface is { name, label, field, type, dateGranularity } and type has no select member — so the dataset cannot declare "this dotted path is a picklist, resolve it against crm_account".

Why this is not a duplicate of #5076

#5076 is about analytics surfaces resolving option labels and then not applying the i18n bundle — the label is found, it is just the English one. That is widget B's behaviour.

This issue is the layer below: for a joined dimension the label is never resolved at all. Fixing #5076 alone would leave widget A still printing education, because there is no label in hand to translate.

Impact

Raw enum values reach end users on a dashboard. On a non-English deployment it is worse than English — education is neither the user's language nor a word they have ever seen in the UI, since every form and list shows the translated label.

Suggested fix

When a dimension's field is a dotted path, resolve the select options against the target object of the relationship rather than the dataset's base object, then apply the same option-label (and, per #5076, i18n bundle) resolution the local-dimension path already uses.

Related

• Analytics surfaces resolve select-option labels but never apply the i18n bundle — reports and dashboards show English while lists and forms show the translation #5076 — analytics surfaces resolve option labels but skip the i18n bundle.
• Report charts render the raw dataset measure name as the axis title, ignoring the measure's label — the same measure on a dashboard chart resolves correctly #5141 — report charts drop the dataset measure's label.
• View labels never resolve a translation — resolveViewLabel reads two fields the served view document does not have #4854 — view / report / dataset labels have no live translation path.

Filed from a downstream app (hotcrm-heimao), tracked there as issue #69.

[os-zhuang]

分诊:补 pm:queue(既有 repo:objectui 路由沿用,此前只有路由半边、缺分类半边)。

落点:objectui analytics 维度标签解析 —— dotted relationship path(crm_account.industry)的 select options 应对关联目标对象解析,现只查 dataset 基对象、miss 后静默落回存储值。与 #5076 的区分成立(那单是 label 已解析但未过 i18n bundle;本单是 joined 维度根本不解析),两单修复叠加才完整。注意 DatasetDimension 无 select type 成员,若需 spec 面配合再按跨域拆分,先按纯前端解析修。

本评论来自分诊座位 Routine(#5474 试点),不构成认领。

---

Generated by Claude Code

[os-zhuang]

Migrated to objectstack-ai/objectui#4053 under #7167 (file-at-destination ruling, maintainer 2026-08-10). Native GitHub issue transfer is not available to this session's credential, so the card was recreated at the destination; this thread stays as the authoritative history and is linked from the new card. Closing as not planned here — moved, not rejected.

---

Generated by Claude Code