# Get all the Records from the Scroll not working

**URL:** <https://discuss.elastic.co/t/get-all-the-records-from-the-scroll-not-working/242650>\
**Category:** Elasticsearch\
**Created:** [July 26, 2020, 11:50am UTC](https://discuss.elastic.co/t/get-all-the-records-from-the-scroll-not-working/242650 "2020-07-26T11:50:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Asad\_Iftikhar94](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/asad_iftikhar94/32/72801_2.png) [@Asad\_Iftikhar94](https://discuss.elastic.co/u/Asad_Iftikhar94)\
**Post date:** [July 26, 2020, 11:50am UTC](https://discuss.elastic.co/t/get-all-the-records-from-the-scroll-not-working/242650/1 "2020-07-26T11:50:25Z")

</div>

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

```auto
   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

```auto
 "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
}

```

---

<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:** [August 23, 2020, 11:50am UTC](https://discuss.elastic.co/t/get-all-the-records-from-the-scroll-not-working/242650/2 "2020-08-23T11:50:27Z")

</div>

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