I am trying to get all the records from the index the issue i am having is that i cannot get all the reocrds using Scroll
filters.Add(new TermsQuery
{
Field = new Field("MERCHANTNO"),
Terms = nameList,
});
filterClause.Add(new DateRangeQuery
{
Boost = 1.1,
Field = new Field("TRANSACTIONDATE"),
GreaterThanOrEqualTo = "05",
LessThan = "2019",
Format = "yyyy||MM",
TimeZone = "+01:00"
});
var SearchRequest = new SearchRequest<Acquirer>("acquiringdata")
{
Size = 10,
Scroll="10s",
Query = new BoolQuery
{
Must = filters,
Filter = filterClause
}
};
var searchResponse = await _elasticClient.SearchAsync<Acquirer>(SearchRequest);
This is what i am getting in json Query i want to get all the records using scroll its not working I am newbie to Elasticsearch any help would be appreciated
"from": 0,
"query": {
"bool": {
"filter": [
{
"range": {
"TRANSACTIONDATE": {
"format": "yyyy||MM",
"gte": "05",
"lt": "2019",
"time_zone": "+01:00",
"boost": 1.1
}
}
}
],
"must": [
{
"terms": {
"MERCHANTNO": [
"962425411201011",
"962215992201005"
]
}
}
]
}
},
"size": 10
}