Query returns 200 records max

I have…

I’m submitting a…

  • [ ] Regression (a behavior that stopped working in a new release)
  • [ ] Bug report
  • [ ] Performance issue
  • [ x] Documentation issue or request

Current behavior

Running Squidex, I only receive 200 records back from my content query. I read the docs:

limiting-the-number-of-results

And understand that this is explicitly stated, but I was wondering if there is any way to get more records, i.e. not using the TOP keyword in my query.

Expected behavior

I would like to be able to get all of the records that fit the filter provided, as if not using the TOP keyword at all.

Minimal reproduction of the problem

Environment

  • [ ] Self hosted with docker
  • [ x] Self hosted with IIS
  • [ ] Self hosted with other version
  • [ ] Cloud version

Version: [VERSION]
{“version”:“4.3.0.0”}

Browser:

  • [ x] Chrome (desktop)
  • [ ] Chrome (Android)
  • [ ] Chrome (iOS)
  • [ ] Firefox
  • [ ] Safari (desktop)
  • [ ] Safari (iOS)
  • [ ] IE
  • [ ] Edge

Others:

You can configure it: https://github.com/Squidex/squidex/blob/master/backend/src/Squidex/appsettings.json#L266

Aha! Thank you, right now I’m consuming this data. I’ll get our resident Squidex developers to help me configure this for our system. Thank you for your quick response!

1 Like