Get all the Records from the Scroll not working

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
}

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