search screen based on ADP shows only 25 records instead of all the records in the underlying BO.

Summary:

I have a search screen with multiple columns we can query the data by. None of these search columns are required (ideally, they should be). This is a master data maintenance screen where users can query/update and create these records.

I have created an ADP based on the endpoint and calling an action chain which assigns the criteria based on the search parameters and then sets the filter criteria in the requestTransformOptions. Once the rest call is successful, I'm assigning the output to my ADP on which my table is based on.

So even if I did not enter anything in the search criteria it is returning only 25 rows. I think it is based on how "limit" value is setup, but I do not know how to increase that to say 500 in VB.