nested queries in Elasticsearch

Question

I have json data as follows

{
  "_index": "project",
  "_type": "ts_order_snapshot",
  "_id": "1",
  "_version": 1,
  "exists": true,
  "_source": {
    "order_id": "100000001",
    "order_data": "Order Data:{\"entity_id\":\"1\",\"state\":\"canceled\"}"
  }
}

Now I would like to get the list of all the order ids having state as canceled. Any suggestions?

drewr · Accepted Answer · 2012-05-21 17:04:34Z

1

order_data is a serialized, json-encoded string, not a structured json map. If you promoted it to actual json, you could construct a query like ?q=order_data.state:canceled&fields=order_id.

edited May 21, 2012 at 17:04

answered May 21, 2012 at 15:15

drewr

1,7961 gold badge16 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Vipul Over a year ago

I am very new to JSON also. Could you please elaborate on this. How to transform this serialized JSON encoded string to actual JSON.

Vipul Over a year ago

is this a fine encoding?

{"_index":"project","_type":"ts_order_snapshot","_id":"1","_version":55,"exists":true, "_source" : {"order_id":"100000001","order_data":{"entity_id":"1","state":"canceled"}}}

And could you suggest me a query to get the results.

drewr Over a year ago

Yes, that's what you want. See the query example in my first response.

Collectives™ on Stack Overflow

nested queries in Elasticsearch

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related