Hi, we met the problem of version 0.41 about column missing while export csv or excel. After we apply the patch of https://github.com/metabase/metabase/pull/18441, we test that it can fix the case you have given.
We also find other case still suffer from column missing, looks like when invoke table join. But unfortunately we can't reproduce it in sampleSet.
The query dataset_query
is:
{
"type": "query",
"query": {
"source-table": 112,
"filter": [
"=",
[
"field-id",
538039
],
1
],
"joins": [
{
"fields": [
[
"joined-field",
"dim_table_bss_product_biz",
[
"field-id",
570
]
]
],
"source-table": 69,
"condition": [
"=",
[
"field-id",
74949
],
[
"joined-field",
"dim_table_bss_product_biz",
[
"field-id",
572
]
]
],
"alias": "dim_table_bss_product_biz"
}
],
"order-by": [
[
"asc",
[
"joined-field",
"dim_table_bss_product_biz",
[
"field-id",
570
]
]
]
],
"fields": [
[
"field-id",
569
],
[
"field-id",
567
]
]
},
"database": 2
}
The visualization_settings
is:
{
"table.pivot_column": "name_2",
"table.cell_column": "name",
"table.columns": [
{
"name": "name_2",
"fieldRef": [
"joined-field",
"dim_table_bss_product_biz",
[
"field-id",
570
]
],
"enabled": true
},
{
"name": "id",
"field_ref": [
"field-id",
569
],
"enabled": true
},
{
"name": "name",
"fieldRef": [
"field-id",
567
],
"enabled": true
}
],
"column_settings": {
"[\"ref\",[\"field-id\",570]]": {
"column_title": "业务"
},
"[\"ref\",[\"field-id\",567]]": {
"column_title": "付费产品"
},
"[\"ref\",[\"field-id\",569]]": {
"column_title": "付费产品ID"
}
}
}
The case above, when export, column of field-id=569
is missing
Any tips?