How to get all table names(>1000) in my interface. I have created a Stored procedure to retrieve table names, used it to create expression rule. But in expression rule only getting 1000 tables. Also in interface only 1000 table names are populating. Please help me in retrieving all table names in interface.
Discussion posts and replies are publicly visible
Have you configured any batching or something that is restricting the result?
could you please check in stored procedure. I think SP is returning only 1000 rows.
No
Yes, in expression rule where i am calling the sp i m getting 1000 rows only, but i want all tables from DB to appian, how to do it help me!
When you are calling the SP directly on the cloud Db, are you getting more than 1000 rows?
you have to make changes in your SP then. Connect with your DB team and they will help you in that. They set the max row to 1000 which you have to remove.
In DB when calling the SP there it is showing all tables, but when in expression rule calling that SP i m getting only 1000 tables