Hi!
I'm doing duplication via UI of a card and it isn't being duplicated identically -- a grouping field is lost.
Original:
Duplicate:
here custom field 'Satisfaction' is absent.
I'm running:
Mozilla Firefox 102.0 (64-bit) for Ubuntu, Ubuntu 20.04.4 LTS ( as well reproducible on Chrome on iOS)
Metabase connected to MySQL, on AWS, v.1.43.1
STR:
Open card, on left tray click duplicate, compare duplicate with original card.
Original query json:
{
"dataset_query": {
"database": 43,
"type": "query",
"query": {
"source-table": 319,
"filter": [
"=",
[
"field",
2229,
null
],
161757
],
"joins": [
{
"fields": "all",
"source-table": 321,
"condition": [
"=",
[
"field",
2229,
null
],
[
"field",
2241,
{
"join-alias": "Question"
}
]
],
"alias": "Question"
},
{
"fields": "all",
"source-table": 323,
"condition": [
"=",
[
"field",
2227,
null
],
[
"field",
2255,
{
"join-alias": "Response"
}
]
],
"alias": "Response"
},
{
"fields": "all",
"source-table": 324,
"condition": [
"=",
[
"field",
2227,
null
],
[
"field",
2256,
{
"join-alias": "Metadata"
}
]
],
"alias": "Metadata"
}
],
"expressions": {
"Order": [
"case",
[
[
[
">",
[
"field",
2231,
null
],
8
],
0
],
[
[
">",
[
"field",
2231,
null
],
6
],
1
],
[
[
"<=",
[
"field",
2231,
null
],
2
],
4
],
[
[
"<=",
[
"field",
2231,
null
],
4
],
3
]
],
{
"default": 2
}
],
"Satisfaction": [
"case",
[
[
[
"=",
[
"expression",
"Order"
],
0
],
"Very satisfied"
],
[
[
"=",
[
"expression",
"Order"
],
1
],
"Satisfied"
],
[
[
"=",
[
"expression",
"Order"
],
4
],
"Very unsatisfied"
],
[
[
"=",
[
"expression",
"Order"
],
3
],
"Unsatisfied"
]
],
{
"default": "Neutral"
}
]
},
"breakout": [
[
"expression",
"Satisfaction"
],
[
"expression",
"Order"
]
],
"aggregation": [
[
"count"
]
],
"order-by": [
[
"asc",
[
"expression",
"Order"
]
]
]
}
}
}
Duplicate dataset_query:
{
"dataset_query": {
"database": 43,
"type": "query",
"query": {
"source-table": 319,
"filter": [
"=",
[
"field",
2229,
null
],
161757
],
"joins": [
{
"fields": "all",
"source-table": 321,
"condition": [
"=",
[
"field",
2229,
null
],
[
"field",
2241,
{
"join-alias": "Question"
}
]
],
"alias": "Question"
},
{
"fields": "all",
"source-table": 323,
"condition": [
"=",
[
"field",
2227,
null
],
[
"field",
2255,
{
"join-alias": "Response"
}
]
],
"alias": "Response"
},
{
"fields": "all",
"source-table": 324,
"condition": [
"=",
[
"field",
2227,
null
],
[
"field",
2256,
{
"join-alias": "Metadata"
}
]
],
"alias": "Metadata"
}
],
"expressions": {
"Order": [
"case",
[
[
[
">",
[
"field",
2231,
null
],
8
],
0
],
[
[
">",
[
"field",
2231,
null
],
6
],
1
],
[
[
"<=",
[
"field",
2231,
null
],
2
],
4
],
[
[
"<=",
[
"field",
2231,
null
],
4
],
3
]
],
{
"default": 2
}
],
"Satisfaction": [
"case",
[
[
[
"=",
[
"expression",
"Order"
],
0
],
"Very satisfied"
],
[
[
"=",
[
"expression",
"Order"
],
1
],
"Satisfied"
],
[
[
"=",
[
"expression",
"Order"
],
4
],
"Very unsatisfied"
],
[
[
"=",
[
"expression",
"Order"
],
3
],
"Unsatisfied"
]
],
{
"default": "Neutral"
}
]
},
"breakout": [
[
"expression",
"Order"
]
],
"aggregation": [
[
"count"
]
],
"order-by": [
[
"asc",
[
"expression",
"Order"
]
]
]
}
}
}
Also getting this in console: