# How do I run a query for searching a text which is in a blob datatype

**URL:** <https://discuss.elastic.co/t/how-do-i-run-a-query-for-searching-a-text-which-is-in-a-blob-datatype/78195>\
**Category:** Elasticsearch\
**Created:** [March 11, 2017, 5:36am UTC](https://discuss.elastic.co/t/how-do-i-run-a-query-for-searching-a-text-which-is-in-a-blob-datatype/78195 "2017-03-11T05:36:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mangesh](https://avatars.discourse-cdn.com/v4/letter/m/d78d45/32.png) [@mangesh](https://discuss.elastic.co/u/mangesh)\
**Post date:** [March 11, 2017, 5:36am UTC](https://discuss.elastic.co/t/how-do-i-run-a-query-for-searching-a-text-which-is-in-a-blob-datatype/78195/1 "2017-03-11T05:36:34Z")

</div>

here is data which i posted to elasticsearch:

{  
"took": 112,  
"timed\_out": false,  
"\_shards": {  
"total": 5,  
"successful": 5,  
"failed": 0  
},  
"hits": {  
"total": 1,  
"max\_score": 0.6931472,  
"hits": [  
{  
"\_index": "profiles",  
"\_type": "resume",  
"\_id": "2013",  
"\_score": 0.6931472,  
"\_source": {  
"filetype": "doc",  
"firstname": "akash",  
"filecontent": "PK\u0003\u0004\u0014\u0000\u0006\u0000\b\u0000\u0000\u0000!\u00002oWf\u0001\u0000\u0000¥\u0005\u0000\u0000\u0013\u0000\b\u0002[Content\_Types].xml ¢\u0004\u0002( \u0000\u0002\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000"  
}  
]  
}

and I want to find the some text content from "filecontent" field.  
how to create query for this :  
I tried this one but wont work:

{"query": {  
"bool": {  
"must": [  
{  
"match": {  
"filecontent": "Documentation"  
}  
}  
],  
"must\_not": [],  
"should": []  
}  
},"from": 0,  
"size": 10  
}

---

<div class="post-metadata">

**Author:** ![eperry](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/eperry/32/551_2.png) [@eperry](https://discuss.elastic.co/u/eperry)\
**Post date:** [March 12, 2017, 4:31pm UTC](https://discuss.elastic.co/t/how-do-i-run-a-query-for-searching-a-text-which-is-in-a-blob-datatype/78195/2 "2017-03-12T16:31:25Z")

</div>

I maybe mis-understanding your question but

Your filecontent field does not contain any words "Documentation:. So not sure what your expecting to find

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 9, 2017, 4:31pm UTC](https://discuss.elastic.co/t/how-do-i-run-a-query-for-searching-a-text-which-is-in-a-blob-datatype/78195/3 "2017-04-09T16:31:27Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.