Hi,
I would like to use raw mongo aggregate query in c#
ex:
$match: {
sdffds: 'dfsdf',
credat: {
$gte: ISODate('2021-07-05T12:29:30.000+00:00'),
$lte: ISODate('2021-07-15T12:29:30.000+00:00')
}}
}, {
$group: {
_id: {
$dateToString: {
format: '%Y-%m-%d-%H',
date: '$sadsa'
}
},
items: {
$first: '$$ROOT'
}
},{
'$replaceRoot':{
'newRoot':'$items'
}
},{
'$sort':{'plctime':-1
}
}