Pagination tutorial not working with api express

[Michael Droll]

I'm using the tutorial for pagination here ( https://devcenter.appery.io/tutorials... ) as a reference for API express.

everything is working exept limit is not included in the query.

but it is showing up in the mapping editor.

I am assuming that "skip" is not the proper syntax for sql. Is this correct, and what should I have for pagination to work?

the database is on hostbuddy, FYI.

here is what the local storage shows (just in case). they are working as expected and skip does increase with every next button click.

Thank you for the help,
Michael

[Serhii Kulibaba]

Hello Michael,

This tutorial works only for Appery.io DB. Please use parameters offset and limit: https://devcenter.appery.io/documenta...

[Michael Droll]

That worked like a charm. thank you.