infinity
infinity copied to clipboard
[Question]: Filter expression can't include row_id in HTTP API. How can I paginate search results?
Fix filter expression can't include row_id #1334
Request Parameters:
{
"output": ["_row_id"],
"filter": "_row_id < 10"
{
Error Message:
{"error_code":3069, "error_message":"Invalid expression: _row_id < 10"}
In addition to utilizing 'limit' in SQL DQL, are there alternative ways available for paginating search result within an HTTP search request?
{ "output": ["_row_id"], "filter": "_row_id < 10" {
You can use
{
"output": ["_row_id"],
"filter": "row_id() < 10"
{