Hello community,

I am trying to query a MongoDB using LookupRecord which works fine when I
read the values directly from the json flow file.
But when I try to query the MongoService using an attribute, I don't find
the expected document.

Here is my nifi 1.6 setup:

json flow file:
{
  "code": "A1234",
  "authority": "MyAuthority",
  "descriptions": [
    {
      "language": "EN",
      "description": "Nifi rocks!"
    }
  ]
}

avro schema:
{
  "type" : "record",
  "name" : "MyClass",
  "namespace" : "com.test.avro",
  "fields" : [ {
    "name" : "code",
    "type" : "string"
  }, {
    "name" : "authority",
    "type" : "string"
  }, {
    "name" : "descriptions",
    "type" : {
      "type" : "array",
      "items" : {
        "type" : "record",
        "name" : "descriptions",
        "fields" : [ {
          "name" : "language",
          "type" : "string"
        }, {
          "name" : "description",
          "type" : "string"
        } ]
      }
    }
  } ]
}

two documents in mongo:
{
    "_id" : ObjectId("5b07db234fad446628118dde"),
    "code" : "A1234",
    "authority" : "MyAuthority",
    "descriptions" : [
        {
            "language" : "EN",
            "description" : "Nifi rocks!"
        }
    ]
}

{
    "_id" : ObjectId("5b07db374fad446628118e10"),
    "code" : "A1234",
    "authority" : "AnotherAuthority",
    "descriptions" : [
        {
            "language" : "EN",
            "description" : "Nifi still rocks!"
        }
    ]
}



​


Now I try to query MongoDB using a value from an attribute but it never
matches.
The attribute 'authority' is set via UpdateAttribute and contains value
"MyAuthority".


​
​
How can I query my document using attribute?


Thomas
​

Reply via email to