Skip to content
This repository has been archived by the owner on Aug 2, 2022. It is now read-only.

Whether or not support sort filter operation by sql? #1147

Open
smallAttr opened this issue Nov 22, 2021 · 0 comments
Open

Whether or not support sort filter operation by sql? #1147

smallAttr opened this issue Nov 22, 2021 · 0 comments

Comments

@smallAttr
Copy link

smallAttr commented Nov 22, 2021

for example:

  1. put data to es index:
    PUT /my_index/blogpost/2 { "title": "Investment secrets", "body": "What they don't tell you ...", "tags": [ "shares", "equities" ], "comments": [ { "name": "Mary Brown", "comment": "Lies, lies, lies", "age": 42, "stars": 1, "date": "2014-10-18" }, { "name": "John Smith", "comment": "You're making it up!", "age": 28, "stars": 2, "date": "2014-10-16" } ] }
  2. dsl expression
    GET /_search { "query": { "nested": { "path": "comments", "filter": { "range": { "comments.date": { "gte": "2014-10-01", "lt": "2014-11-01" } } } } }, "sort": { "comments.stars": { "order": "asc", "mode": "min", "nested_filter": { "range": { "comments.date": { "gte": "2014-10-01", "lt": "2014-11-01" } } } } } }

I want to know whether or not to support sort filer operation by sql?
up to now, can not find any relevant information?

@smallAttr smallAttr changed the title Whether or not support sort filter operation? Whether or not support sort filter operation by sql? Nov 22, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant