CAP Project - SQL query response limitation 1000 records

[RoryA]

Within our CAP project we have defined entities that we have created services for. To extract more than 1000 records we have defined the annotation which works well for a service.

service CatalogService @(path: '/srv') {

@cds.query.limit.max: 1500
entity AnaToBeDraftInterBill as projection on lng.TOBEDRAFT_INTERBILL9;

However, we have a function defined inside the CAP project that has SQL that directly reads our entity in the HANA Db and this query is getting restricted by 1000 entries. How can we overcome this restriction? It seems odd to me as within the HANA DB Explorer I can perform the same SQL statement in the console and return all the records.

 SELECT`project_number`.from`project_numbers`
  .where`sales_office = ${office}`.orderBy`project_number asc`

We are searching for any unassigned numbers (project number in this case) that does not exist in 2 different tables, hence needing to extract all existing project numbers already assigned.

Thanks

[gregorw]

Any specific reason why you would need to change the limitation?

[RoryA]

See original post for reason.