title: Retrieve Documents using wildcard "like" in Elastic search
body: <p>I have some documents which tittle are :</p>
  
  <pre><code>DocumentTitle: "119053_L048.pdf" , DocumentTitle: "119052_L048.pdf , DocumentTitle: "119029_L048.pdf , DocumentTitle: "119239_L048.pdf , DocumentTitle: "119314_L048-2.pdf" , DocumentTitle: "119310_L048-2.pdf" , DocumentTitle: "Application.pdf , DocumentTitle: "Abstract.pdf , DocumentTitle: "Drawing.pdf
  </code></pre>
  
  <p>and I want to retrive the documents using elasticsearch query which titles are ends with <strong>"_L048.pdf"</strong>. In sql The query is like :</p>
  
  <pre><code>SELECT * FROM documents_table where DocumentTitle like '%_L048.pdf';
  </code></pre>
  
  <p>I have tried the below elastic serach query</p>
  
  <pre><code>URL:http://localhost:9200/document/_search?size=10000
  </code></pre>
  
  <p>Post Data:</p>
  
  <pre><code>{
   "_source":["DocumentSubtype","DocumentTitle","CaseID","ApplicationNumber","OpenToPublic"],
    "size" : 0,        
    "query": {
    "filtered": {
    "query": {
      "query_string": {
         "query": "OpenToPublic:true AND DocumentTitle:*_L048.pdf"
        }
      }
     }
    }
  }
  
  But it returns zero result :
  
  {
      "took": 6,
      "timed_out": false,
      "_shards": {
          "total": 5,
          "successful": 5,
          "failed": 0
      },
      "hits": {
          "total": 0,
          "max_score": null,
          "hits": []
      }
  }
  </code></pre>
  
  <p>Could anyone please help.Thanks in Advance</p>