Hello all,   I'd like to use the updateRecord processor to create some fields in my JSON. But I'd like to use some conditions to do that. In the recordpath documentation, I can see that there is a "filter" capability, which works like this: /field[filter]/path, but as far as I can see it's not possible to have multiple conditions in this filter. I'd like to do something like:   if (field1 == A or field1 == B) { field2 = C } else if (field1 == D and field1 != E) { field2 = G }     The example is silly but this is to give you the idea. By the way, except using a script, I don't know how to do that, except may be extracting the fields, put it as attribute and play with expression language but this would mean working with single-record flows and I don't want to do that.   Any idea?   Thanks for your suggestions   Stéphane   ... View more

Hello,   I have a piece of JSON on which I want to apply an updateRecord processor using some filter capabilities. My JSON looks like this:     "status": [ { "code": "InProgress", "isCurrentStatus": false, "startDateTime": "2020-03-05T20:45:00Z" }, { "code": "Pending", "isCurrentStatus": true, "startDateTime": "2020-03-05T21:20:00Z" } ],       And my RecordPath expression is the following:       /status[0..-1][./isCurrentStatus = true]/code     This expression doesn't work and I have an error in my logs file stating about incorrect syntax:  Unexpected token ']' at line 1   If I put the following syntax:     /status[0..-1][./isCurrentStatus = "true"]/code     it doesn't give anymore error, but of course the filter doesn't work. So, I have the feeling that recordPath filter doesn't support the use of boolean values.   My Nifi is Nifi 1.9.0 coming with HDF 3.4.   Any idea?   Thanks a lot,   Stéphane   ... View more