# Elasticsearch query retrieve fetch expecting result in top 25 results
**URL:** https://discuss.elastic.co/t/elasticsearch-query-retrieve-fetch-expecting-result-in-top-25-results/63474
**Category:** Elasticsearch
**Created:** [October 20, 2016, 7:16am UTC](https://discuss.elastic.co/t/elasticsearch-query-retrieve-fetch-expecting-result-in-top-25-results/63474 "2016-10-20T07:16:47Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@banu](https://discuss.elastic.co/u/banu)
#### Post date: [October 20, 2016, 7:16am UTC](https://discuss.elastic.co/t/elasticsearch-query-retrieve-fetch-expecting-result-in-top-25-results/63474/1 "2016-10-20T07:16:47Z")
I have 200K records and trying to fetch records based on certain match criteria ex: company\_name: "test" If i give size:250 expecting record is not available in search results. size:500 the expecting document is fetched and displayed. How to get the document in top 25 results ?
Query : {"explain":true,"size":250,"query":{"query\_string":{"query":" ( (NAME:"BANK AMERICA")^50 OR (ceoNames.fullCEOName:(BANK AMERICA))^30 OR (NAME\_PAIR:"BANK AMERICA")^30 OR (NORMAL\_NAME:(BANK AMERICA) AND CITY:"" ) ^40 OR (NORMAL\_NAME:(BANK AMERICA))^30 OR (tradeStyles.acronym:"BS")^5 OR (NORMAL\_NAME\_SOUNDEX:"BANK AMERICA")^5 OR (address.streetName:"" AND CITY:"")^30 OR (ZIP:"")^6 OR (address.streetName:"")^6 OR (address.streetNumber:"" AND address.streetName:"")^15 OR (telephones.telephone:"")^50 OR (mailAddresses.postbox:"")^6 ) "}},"sort":[{"\_score":{"order":"desc"}},{"statusIndicator":{"order":"asc"}}],"aggs":{"NAME":{"filter":{"term":{"NAME":"ATLS"}}}}}
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [October 22, 2016, 5:23am UTC](https://discuss.elastic.co/t/elasticsearch-query-retrieve-fetch-expecting-result-in-top-25-results/63474/2 "2016-10-22T05:23:51Z")
Why not use a filter then?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 5, 2017, 10:10pm UTC](https://discuss.elastic.co/t/elasticsearch-query-retrieve-fetch-expecting-result-in-top-25-results/63474/3 "2017-07-05T22:10:22Z")