Hi, thanks so much for this great tool and it would be really great if it has more support for monogdb. so here I'm trying to use date field filter on a date field which was a result of lookup stage between two collections as shown in this mongodb query but I'm getting this error on the screenshot
I'm new to metabase and I really appreciate any help and guidance , Thank you
[{
$match: {
tierCode: 'client'
}
}, {
$lookup: {
from: 'users',
localField: 'meta.orgInfo.id',
foreignField: 'meta.orgInfo.id',
as: 'client_users'
}
}, {
$project: {
client_id: '$id',
usr_cd: '$client_users.meta.createdDate',
usr_id: '$client_users.id'
}
}, {
$unwind: {
path: '$usr_cd'
}
}, {
$unwind: {
path: '$usr_id'
}
}, {
$project: {
client_id: '$client_id',
usr_cd: '$usr_cd',
usr_id: '$usr_id'
}
}, {
$match:
{usr_cd:
{{created_date}}
}
}]