Error when use parameters in custom queries using node.js LIMIT and OFFSET clause

[Alexander_Paladines]

Thanks, I will investigate it, but looks a bit complicate it for me.
My workaround was to change the way in how I use the relational fields and directly paste in a new column the value, maybe with with time the DB growth a bit more. But now I can use native Paged Records inside wappler wihout the need to use custom query to solve this:

Join Results of 2 Data Collections

Hi, Is possible to apply condition in the JOIN Transformation?, I mean, if apply a WHERE condition in query of Collection 2 it doesn’t affect the generate table in UI because the condition only apply to the query of one collection and not to the entire JOIN with both collections.