8000 search records with _exists_ doesn't return records with empty but existing field · Issue #25 · oipwg/oip · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

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

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

Jump to bottom
Open
daviortega opened this issue Nov 22, 2020 · 4 comments
Open

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

daviortega opened this issue Nov 22, 2020 · 4 comments
Assignees
@bitspill @DevonJames
Labels
bug Something isn't working

Comments

@daviortega
Copy link
Member

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 daviortega added the bug Something isn't working label Nov 22, 2020
@bitspill
Copy link
Member

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

@daviortega
Copy link
Member Author

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

@bitspill
Copy link
Member

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

@daviortega
Copy link
Member Author

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
Assignees

@bitspill bitspill

@DevonJames DevonJames

Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@daviortega @bitspill @DevonJames
0