Hi,
for a query of all of the lines of a google sheet. I need the Row Limit from the Sheet. I get it from “fetch sheet” but how i get the row Count as result…
i have problem to get the single value instead of the array data.
i expected:
{{query_fetch_sheet.data.sheets[table_sheets.selectedRow.index].gridProperties.rowCount}}
but it is empty.
thx
Franz
@franz what does {{query_fetch_sheet.data.sheets[table_sheets.selectedRow.index].gridProperties}} show in evaluated value?
crazy, today it work with :
{{query_fetch_sheet.data.sheets[table_sheets.selectedRow.index].gridProperties.rowCount}}
But it seems the max size of tables are limited…
@franz it seems you have a lot of data in your sheet. The limit you should pass to the Google Sheet Query is the pageSize of the table you are displaying the sheet records in. So you should add a small value like 20 or {{Table1.pageSize}} with an offset and configure server side pagination
yeah i tried:
Row Offset set to {{(table_content.pageNo - 1) * table_content.pageSize}}
Row Limit set to {{table_content.pageSize}}
the “table_content” is set to server side pagination.
The first 22 Rows will be loaded now. But i can´t open the next page.
the manual says:
but 2 and 3 looks like an description for sql ?? It is trickier than expected.
Are the “Where Conditions” in the google fetch didn´t work with strings? I tried for Example :
Columnname test == testvalue
=> without any result.
@pranav thank you very much.
I didn´t run the “onpagechange” Query Action. Changed that, and now works fine.
Just confusion, that table pagination is not showing the count of rows and the total amount of pages.
