New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

search records with _exists_ doesn't return records with empty but existing field #25

Open

daviortega opened this issue Nov 22, 2020 · 4 comments

Assignees

Labels

Member

daviortega commented Nov 22, 2020

The search:
https://api.oip.io/oip/o5/record/search?limit=12&page=1&q=_exists_:record.details.tmpl_7C6B7370

Does not return records like this one:
https://api.oip.io/oip/o5/record/get/ce5f4406fd867c5eff635c1b9dc43c8753940da16e31b91ddbc9ccbab68d69e2

But it should.

daviortega assigned bitspill and DevonJames

daviortega added the bug label

Member

bitspill commented Nov 22, 2020

The exists query returns fields with non-null values

https://www.elastic.co/guide/en/elasticsearch/reference/6.8/query-dsl-query-string-query.html#_field_names

Member Author

daviortega commented Nov 22, 2020

right, so why it isn't showing up? Is the response changing null to {}?

Member

bitspill commented Nov 22, 2020

[] and {} are both also considered non-existent/null for the purposes of ES queries

Member Author

daviortega commented Nov 22, 2020

any suggestion on how to find all records that has a specific template even if it is empty? (null for ES)?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment