Hi,
I am using Query database smart service in the Process model to get the data from the external data source which is in DataMart. Due to some access restriction, we were not able access external database. So, we have added the source in the admin console, and we are using it in smart service. I am getting 1000 rows of data, and I am storing it in a Process variable which is of CDT type. I want to fetch all the rows like I have more than 4000 rows of data. But I am able to fetch only 1000 rows. Is there any way to fetch all the rows. This is my current configuration. We need to display the data in an interface grid which will be viewed in Site
Discussion posts and replies are publicly visible
Did you try setting up a record type to work with external data source? What challenges did you face
Editing because I cant reply to this thread any longer, and am getting a warning. srinivaast629400 Please see below my latest reply
As per documentation, the default limit is 1000 rows for a select query when Query Database smart service is used but it can be updated. Check this documentation to get the limit updated as per need
We have some grant restrictions to access the table. We are unable to create a record. We have configured the data source in the admin console and pulling the data through Query database smart service. But it doesn't support select * query in the setup configuration. We need all the data to be queried. Is there any other method ?