Hi @Dommicentl
You are correct. I think the JDBC assertion you are currently using may be the best bet.
We have the limit of hardcoded in our JDBC queries to the OTK database. I would not recommended making any changes to those but rather implement your own solution if you need to avoid using offsets for the total results.
Regards,
Joe