Need help with Custom Query Pagination

[UKRiggers]

Thanks for your efforts so far Brian. Great progress. Hopefully others can contribute.

[UKRiggers]

Interesting approach and sounds logical. I’ll have a go at that later tomorrow. Cheers

[sitestreet]

That is an excellent idea. I keep overlooking views but when I use them I wonder why I don’t use them more often!

[bpj]

May be obvious, but if you’re new to views, I’d recommend prefixing the name with something like ‘view_’ to differentiate them easily in lists.

[JonL]

Or you can go berserk and build a custom module.

Paged custom query

Anyway I already moved on making the structure match what App Connect expects and using knex for my queries. exports.anytable = async function(options) { // connection option is required. In my cased it's fixed to 'db' const connection = this.parseRequired('db', 'string', 'dbconnector.paged: connection is required.'); // read table name from options const table = this.parseRequired(options.table, 'string', 'table is required.'); // get the database connection const db = …