-fieldName:'' for multivalued field

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

-fieldName:'' for multivalued field

oradb1usa
I have a schema this in my schema.xml

<field name="MEDIA" type="text" indexed="true" stored="true" multiValued="true" default=""/>

and I would like to query the documents where MEDIA is not equal to the default value. We are trying to optimize the query MEDIA:* since it is really slow. We would like to get all the documents where MEDIA is not null. So, we thought that -MEDIA:'' will work but it doesn't. I am still getting documents where MEDIA is the default value. For example:

"response":{"numFound":4,"start":0,"docs":[
      {
        "MEDIA":["1||5fbc299118ea6a63234ca9f3"]},
      {
        "MEDIA":["1||5f064502850a3d36157f2d67",
          "2||5f0645067d833c0b1a3b84a5",
          "3||5f06450a89867865a45435d5",
          "4||5f0645116bf73a70260ec06a",
          "5||5f064515b747a27e8a344e55",
          "6||5f0645193632d4209b5fc768",
          "7||5f0645205feb502e0a46ee23",
          "8||5f064524a07b0c7ecc60a138",
          "9||5f0645289b474230e3562e0f",
          "10||5f06452dd092b10dbe3edf93",
          "11||5f064531dae8a502a64a6e2d",
          "12||5f064534d1d70b1c331325bd",
          "13||5f064538ad645314c81f9aba",
          "14||5f06453bdc3efe570009dec4",
          "15||5f06453fe51d312926157a54",
          "16||5f064543e085b15df1464c24",
          "17||5f06454769720415f22cfa85",
          "18||5f06454b9eadcc440448ba54",
          "19||5f0645513b9db34063796de0",
          "20||5f0645556e26eb598b78b2b5",
          "21||5f06455a13411065bc0f4cd6",
          "22||5f06455e756328057a476348",
          "23||5f06456241009a3eb4356676",
          "24||5f0645671e4a0470a4557bc1",
          "25||5f06456f792b3b5067581615",
          "26||5f0645762aa72e10c471cab5",
          "27||5f064579e085b15df1464c28",
          "28||5f06457d41a6d14c006f8f13",
          "29||5f064583e9d7594f645931fe",
          "30||5f06458735d8475687658cd8",
          "31||5f06458a1e4a0470a4557bc4",
          "32||5f06458ee5e848155f0bfcf0",
          "33||5f06459167b0807cbd12ccd3"]},
      {
        "MEDIA":[""]},
      {
        "MEDIA":[""]}]
  }}

I would like to get the first two documents without doing MEDIA:* for optimization.

Thanks.