[JAMES-3390] Email/Query support combination of filters with the FilterOperator (AND, OR, NOT)

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Done
• Fix Version/s: 3.6.0
• Component/s: JMAP
• Assignee: Antoine Duprat
• Reporter: Benoit Tellier
• Created: 29/Sep/20 05:55
• Updated: 02/Oct/20 08:54
• Resolved: 02/Oct/20 08:54

Description

1. 1. 1. WHY
         As an user i want to be able to build complex query using the FilterOperators (AND, OR, NOT)

[[ "Email/query",{
  "accountId": "ue150411c",
  "filter":  {
      "operator": "OR",
      "conditions": [
      { "inMailbox":  "mailbox1"}, {"inMailbox":  "mailbox2"}   
]
}
}, "0" ]]

###HOW

• in the request accept the filter with an 'operator' field and distinguish it from the simple Condition.
  This should be handled in the Json reads. And build a tree which have nodes being FilterOperator and leaf being FilterConditions.
• translate those elastic search query

1. 1. 1. Definition of Done

• write an integration test demonstrating the support of one level of Operator (like in the previous example)
• write an integration test demonstrating the support of an arbitrary level of nesting Operators.
• run those tests against the distributed version of james.