start_dt=sort -n /path/date.txt | tail -1
I am converting this date to ISODate beacause it’s is in ISODate formate in mongodb
x=‘ISODate("’$start_dt’")’
mongoexport --ssl --sslCAFile $sslCAFile --host $host -u $username -p $password --collection $collectionMember --db $database --limit 5 \
--query '{
"memberCard.cardMbrDtlsUpdatedTms": {
"$gte": $x
}}’ \
–out $output
I am getting the output with 0 records when we pass the dates manually It’s fetching 5 records based on limt.
Tarun_Gaur
(Tarun Gaur)
September 21, 2022, 4:27am
3
Hello @Yugandhar_Prathi ,
I notice you haven’t had a response to this topic yet - were you able to find a solution?
If not, then you can try below.
ISODate() is a javascript function, hence will not work here.
According to the mongoexport doc
The query must be in Extended JSON v2 format (either relaxed or canonical/strict mode) , including enclosing the field names and operators in quotes:
So you can try using the date
like
{"$gte": {"$date": "2015-01-01T00:00:00.000+0000"}}
Let me know if you have any more questions.
Regards,
Tarun
system
(system)
Closed
October 3, 2022, 7:42am
4
This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.