All items count for SQL tables (for paginate)

[smedero]

Hello, I connected a SQL table and when I call the service with the count:true parameter, it does not return the value with the total of the items, but in the request I see the value.

the service only return an object with success and data

Thanks!

[saussam18]

Is there any reason you cannot use data.length? That should be the same value as @odata.count

[smedero]

hi saussam, It's for performance reasons. The database I'm using is a bit large, and it's expensive to retrieve all the items. That's why I use the top and skip parameters to limit the records, and if I could access to count value, that would be great.