OQL Issues returning only 1000 records

0
My OQL query returns only 1000 records." "JOIN is not working." "Getting Unknown attribute error." "The dataset works in Studio Pro but fails in runtime?
asked
2 answers
4

Possible Causes

  • Dataset/Grid configuration limits the number of records.
  • Pagination is enabled in the widget.
  • Runtime memory or timeout restrictions.
  • OQL execution is being performed through a Data Set that has a fetch limit.


answered
2

erify whether:

  • The Data Grid has paging enabled.
  • The consuming widget has a page size of 1000.
  • You're using an Export Mapping or Retrieve operation that limits records.

Solution

Add explicit paging if needed:





SQL

1

SELECT *

2

FROM MyModule.Customer

3

LIMIT 5000

4

OFFSET 0

answered