Metabase中对本地Mongo查询的变量支持

Question

我想在Metabase中为给定的MongoDB查询添加一个变量。我知道它在https://github.com/metabase/metabase/issues/3653我在下面给出了我的查询，该查询不适用于该变量。

我的问题是：

[
{
"$project": {
"lastCommGenTS": "$lastCommGenTS",
"lastUpdated": "$lastUpdated",
"regNo": "$regNo",
"derivedStatus": "$derivedStatus"
}
},
{
"$match": {
"$expr": {
"$and": [
{
"$eq": [
"$regNo",{{regNo}}
]
}
]
}
}
},
{
"$project": {
"_id": "$_id",
"regNo": "$regNo",
"derivedStatus": "$derivedStatus",
"lastcommtimeIST": {
"$dateToString": {
"format": "%Y-%m-%d %H:%M:%S",
"date": {
"$toDate": "$lastCommGenTS"
},
"timezone": "+05:30"
}
},
"lastupdatedIST": {
"$dateToString": {
"format": "%Y-%m-%d %H:%M:%S",
"date": {
"$toDate": "$lastUpdated"
},
"timezone": "+05:30"
}
},
"lag_in_minutes": {
"$divide": [
{
"$subtract": [
"$lastUpdated",
"$lastCommGenTS"
]
},
60000
]
}
}
}
]

我在这里得到了这个错误：

Unexpected character ('{' (code 123)): was expecting double-quote to start field name at [Source: java.io.StringReader@6bab96b; line: 17, column: 26]

请帮帮我。

非常感谢：(

Answer 1

在我的情况下，我无法让变量为本机Mongo查询工作，因为我使用的是不支持相同的旧版本的元数据库。本机Mongo查询中对变量和字段过滤器的支持是在本版本发布后添加的https://github.com/metabase/metabase/releases/tag/v0.34.0