How to set max limit on data source

[Amitra Bhunia]

Hi All,

I want to set a limit on a JDBC data source so that it will load only that many records from database. I know I can use the specific query in data source and add limit in the query (i.e. SELECT * FROM Customers
LIMIT 3). But I am searching for any OOB servicenow feature (like a field where I can set the number ) that can achieve limiting the number of fetched record through the datasource.

Thanks & Regards,

Amitra Bhunia

[Maik Skoddow · Accepted solution]

Hi @Amitra Bhunia 

unfortunately there is not such an option for a data source and in my opinion this would also be the wrong place. A data source is just providing the content, however your data sour consumers are responsible for restricting the number of fetched records.

Maik

[Amitra Bhunia]

Hi Maik,

What are you referring as data source consumer? A view on table in database? or as I mentioned in the question setting a limit in query?

Thanks & Regards,

Amitra