How to find a SOLR entry that has a field with no value?

Asked Jun 14 '17 at 16:53

Active Jun 14 '17 at 16:53

Viewed 129 times

I have a local SOLR server with some entries that have a field "debaTest": "" while some entries don't have this field at all.

Is there a way in Solr to filter out the entries that have this field? the value for the field will always be null or empty.

Please note: Something in the lines of q=-debaTest:[* TO *] or -debaTest:* won't work for my requirement as this returns the entries that don't have these fields at all and I want the entries that have this field but without a value.

asked Jun 14 '17 at 16:53

DGT

`q=debaTest:""`. Have you tried this? – Binoy Dalal Jun 15 '17 at 05:11
Yes. This does not work as well. – DGT Jun 15 '17 at 18:18
There was a typo there, I meant `q=-dbatest:""`. Is that what you tried? – Binoy Dalal Jun 15 '17 at 18:21
My guess is since it shows up in a query like `q=-debaTest:*` it thinks the field does not exist at all. If that's true i would say that's a flawed way of looking at thinks. I would be happy if someone says this assumption is wrong and we can indeed lookup the field :) – DGT Jun 15 '17 at 18:22
`q=-dbatest:""` doesn't work as well – DGT Jun 15 '17 at 18:23
Here's another so post that could help you. https://stackoverflow.com/q/4238609/1822643 – Binoy Dalal Jun 15 '17 at 18:27
Didn't help. Same outcome. I have tried these before. – DGT Jun 15 '17 at 20:38

How to find a SOLR entry that has a field with no value?

0 Answers0