We use query database operator for a PAM process, which is used for fetching certain list of data from MDB.
We observe that the query results around 250 rows in MDB (SQL), however in the query select operator it results only 10 rows.
Let me know if there is any limit set for the operator and if yes, how can the same be increased.
Please assists , this is quite urgent as this is affecting the business.
Found to increase the maximum rows from the property field "Maximum rows to retrieve".
By default the row count is 10. Thanks all.