Specify Number of Records to Fetch

[msolanog]

Hello, I’m trying to reproduce what the following would do in SQL:

SELECT * from MY_TABLE
LIMIT 10 OFFSET 10

How should I go about doing that? I’m using runInlineQuery from the sdk.

Background: I’m trying to implement infinite scrolling in a custom viz. I see there is an option
to set the limit of records fetched, but it only allows an integer value.

[thomas_brittain]

Hello @msolanog,

That’s pretty clever; like lazy loading. Looking through the documentation on the runInLineQuery, I didn’t see a clean way to select a range. I’m still thinking on it, though.

In the meantime, could the,

• Run SQL Runner Query

Work for your use case? That way you can use the exactly SQL you described above to get the range you need.

Kind regards,
–Thomas