Use normal and nested fields in same Painless script query?

I have a mapping like this:

{
  printings: { 
    type: "nested",
    properties: {
      prop1: {type: "number"}
    }  
  },
  prop2: {type: "number"}
}

I then want to build a Painless query like this:

"script": {
          "lang": "painless",
          "inline": "doc['prop1'] > (3 * doc['printings.prop2'])"
        }

However testing this in Sense doesn't work. If I replace the nested prop2 with a simple number then it does work. Is there a way to access both root and nested props in a single scripted query? I'm using ES v5.4

2 Likes

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.