Created 03-21-2018 10:16 AM
I am trying to fetch some data from mongodb using Nifi and I am using GetMongo processor. I am trying to write a query inside GetMongo but I dont have any idea how t write query inside this processor.
This is my sample query
db.Person.find({ $and:[ {"createdAt":{$ne:null}}, {"updatedAt":{$ne:null}} ] })
when I write this query it shows the exclamation marks over the processor showing that "Query validated against .... is invalid because JSON was expecting a value but find db." Help me with the correct expression variables at least a good sample will be helpful.
Created 03-21-2018 05:22 PM
@Vivek Singh The query in GetMongo Processor should be in Extended JSON format. The format you are mentioning is the Mongo Shell format and not compatible with the processors. Switch your query to look something like below.
{ "createdAt":{$ne:null}, "updatedAt" : {$ne:null} }
Created 03-21-2018 05:22 PM
@Vivek Singh The query in GetMongo Processor should be in Extended JSON format. The format you are mentioning is the Mongo Shell format and not compatible with the processors. Switch your query to look something like below.
{ "createdAt":{$ne:null}, "updatedAt" : {$ne:null} }
Created 03-22-2018 07:41 PM
@Vivek Singh did the suggestion worked for you?
Created 03-23-2018 01:29 AM
@Rahul Soni Yes Mr. Soni thanks its working. Thanks for your time.
Created 03-10-2023 02:01 AM
any way to use query for filter only last minutes transactions