I am not able to query in elastic search with out properties.<fieldname>

Question

This is the query that is used for searching :

{ "query": {
  "term": {"properties.subscriptionid": "test"
  }
    }
   } 

Result :

  
        "hits": [
            {
                "_id": "ILojbHQB1164tHwpvfoc",
                "_source": {
                    "properties": {
                        "subscriptionid": "test",
                    }

If i use :

{ "query": {
    "term": {"subscriptionid": "test"
    }
      }
     } 

I am not getting any result.

Index mappings :

  "mappings": {
       "properties": {
         "subscriptionid": {
            "type": "keyword"
         },
         "resources":{
            "type": "nested",
}
}

*Removed not necessary to decrease the code area

Answer 1

As @Val pointed out, there is some mismatch in the index mapping that you have posted in the question. Refer terms query, to get a detailed insight on it.

Adding a working example with index data, mapping(same as mentioned in the question) and search query.

Index Mapping:

{
  "mappings": {
    "properties": {
      "resources": {
        "type": "nested" 
      },
      "subscriptionid": {
        "type": "keyword" 
      }
    }
  }
}

Index Data:

{
  "subscriptionid": "test",
  "resources": [
    {
      "title": "elasticsearch"
    }
  ]
}

{
   "subscriptionid": "test"
}

Search Query:

{
  "query": {
    "term": {
      "subscriptionid": "test"
    }
  }
}

Search Result:

"hits": [
      {
        "_index": "stof",
        "_type": "_doc",
        "_id": "1",
        "_score": 0.2876821,
        "_source": {
          "subscriptionid": "test"
        }
      }
    ]

Search Query for nested type with term query:

{
  "query": {
    "nested": {
      "path": "resources",
      "query": {
        "bool": {
          "must": [
            { "term": { "resources.title": "elasticsearch" } }
          ]
        }
      }
    }
  }
}

Search Result for nested mapping:

"hits": [
      {
        "_index": "stof",
        "_type": "_doc",
        "_id": "2",
        "_score": 0.2876821,
        "_source": {
          "subscriptionid": "test",
          "resources": [
            {
              "title": "elasticsearch"
            }
          ]
        }
      }
    ]