# How can I fetch in between documents using Java API?
**URL:** https://discuss.elastic.co/t/how-can-i-fetch-in-between-documents-using-java-api/111245
**Category:** Elasticsearch
**Created:** [December 12, 2017, 6:43am UTC](https://discuss.elastic.co/t/how-can-i-fetch-in-between-documents-using-java-api/111245 "2017-12-12T06:43:12Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@PinkiMondal](https://discuss.elastic.co/u/PinkiMondal)
#### Post date: [December 12, 2017, 6:43am UTC](https://discuss.elastic.co/t/how-can-i-fetch-in-between-documents-using-java-api/111245/1 "2017-12-12T06:43:12Z")
I want to fetch documents from 200 to 300 using search query of JAVA API implementation but unable to find any option
How to do this?
Thanks
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [December 12, 2017, 6:44am UTC](https://discuss.elastic.co/t/how-can-i-fetch-in-between-documents-using-java-api/111245/2 "2017-12-12T06:44:00Z")
How are you defining what 200 and 300 are?
---
### Author:  [@PinkiMondal](https://discuss.elastic.co/u/PinkiMondal)
#### Post date: [December 12, 2017, 6:45am UTC](https://discuss.elastic.co/t/how-can-i-fetch-in-between-documents-using-java-api/111245/3 "2017-12-12T06:45:12Z")
document number 200 to 300
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [December 12, 2017, 6:50am UTC](https://discuss.elastic.co/t/how-can-i-fetch-in-between-documents-using-java-api/111245/4 "2017-12-12T06:50:03Z")
Is that a field in the document?
---
### Author:  [@PinkiMondal](https://discuss.elastic.co/u/PinkiMondal)
#### Post date: [December 12, 2017, 6:50am UTC](https://discuss.elastic.co/t/how-can-i-fetch-in-between-documents-using-java-api/111245/5 "2017-12-12T06:50:50Z")
No i want number of records starting from 200 to 300
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [December 12, 2017, 6:51am UTC](https://discuss.elastic.co/t/how-can-i-fetch-in-between-documents-using-java-api/111245/6 "2017-12-12T06:51:38Z")
I get that, but documents don't have numbers in Elasticsearch.
So how are you defining what that range is?
---
### Author:  [@PinkiMondal](https://discuss.elastic.co/u/PinkiMondal)
#### Post date: [December 12, 2017, 6:54am UTC](https://discuss.elastic.co/t/how-can-i-fetch-in-between-documents-using-java-api/111245/7 "2017-12-12T06:54:10Z")
I am not defining anything I just want to get latest records from 200 to 300 as this option is available in curl query like
GET /\_search?size=5&from=5
or
```auto
{
"query": {
"bool": {
"must": [
{
"term": {
"some key": "some value"
}
}
]
}
},
"from": 10,
"size": 20
}
```
I want to do this using Java API
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [December 12, 2017, 7:46am UTC](https://discuss.elastic.co/t/how-can-i-fetch-in-between-documents-using-java-api/111245/8 "2017-12-12T07:46:33Z")
Please format your code using `` icon as explained in [this guide](https://discuss.elastic.co/t/about-the-elasticsearch-category/21). It will make your post more readable.
Or use markdown style like:
````
```
CODE
```
````
Use the `from` and `size` parameters of the `SearchSourceBuilder` object.
See [https://www.elastic.co/guide/en/elasticsearch/client/java-rest/current/java-rest-high-search.html#\_using\_the\_searchsourcebuilder](https://www.elastic.co/guide/en/elasticsearch/client/java-rest/current/java-rest-high-search.html#_using_the_searchsourcebuilder)
---
### Author:  [@PinkiMondal](https://discuss.elastic.co/u/PinkiMondal)
#### Post date: [December 13, 2017, 5:08am UTC](https://discuss.elastic.co/t/how-can-i-fetch-in-between-documents-using-java-api/111245/9 "2017-12-13T05:08:40Z")
Thank You 🙂 @dadoonet
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 10, 2018, 5:09am UTC](https://discuss.elastic.co/t/how-can-i-fetch-in-between-documents-using-java-api/111245/10 "2018-01-10T05:09:00Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.