Direct JSON Query similar to Model::query

[derekperkins]

I have a complex query (see below) that works using cURL, but I don't know how to form the syntax so that the datasource can interpret it.

{
  "query": {
    "has_child": {
      "type": "workspaces_posts_tags",
      "query" : {
        "filtered": {
          "query": { "match_all": {}},
          "filter" : {
            "and": [
              {"term": {"workspace_id": 2}},
              {"term": {"post_id": 4}}
            ]
          }
        }
      }
    }
  }
}

I tried setting $query to this in the beforeFind in a custom find method, but it didn't like it. It also didn't give any meaningful errors.

$query = [
    'conditions' => [
        'has_child' => [
            'type' => 'workspaces_posts_tags',
            'query' => [
                'filtered' => [
                    'query' => [
                        'match_all' => []
                    ],
                    "filter" => [
                        'and' => [
                            'term' => [
                                'workspace_id' => 2
                            ],
                            'term' => [
                                'post_id' => 4
                            ]
                        ]
                    ]
                ]
            ]
        ]
    ]
];

My thoughts are that it might be nice to have a method available where I could pass in a JSON formatted query and use that as the query. Is there a way to do that? If not, do you know how I should format the query properly for this plugin?

[CriztianiX]

You can use my fork. I have implemented this functionality.

Example:

$query = [
'size' => 1,
'query' => [
'match_all' => []
]
];

    debug($this->ClientContact->query($query));