IT Process Automation

 View Only
  • 1.  Query Database Operator-maximum limit

    Posted Sep 16, 2015 03:37 AM

    Dear All,


    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.


    Thank You,


  • 2.  Re: Query Database Operator-maximum limit
    Best Answer

    Posted Sep 16, 2015 03:41 AM


    Found to increase the maximum rows from the property field "Maximum rows to retrieve".


    By default the row count is 10. Thanks all.