Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Question]: Filter expression can't include row_id in HTTP API. How can I paginate search results? #1896

Open
PorYoung opened this issue Sep 20, 2024 · 1 comment
Labels
feature request New feature or request

Comments

@PorYoung
Copy link

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?

@JinHai-CN JinHai-CN added the feature request New feature or request label Sep 22, 2024
@yangzq50
Copy link
Contributor

{
  "output": ["_row_id"],
  "filter": "_row_id < 10"
{

You can use

{
  "output": ["_row_id"],
  "filter": "row_id() < 10"
{

JinHai-CN added a commit that referenced this issue Sep 24, 2024
### What problem does this PR solve?

1. Fix limit and offset in Python API and HTTP API
2. Add an example to demonstrate how to use limit and offset in Python
API.

Issue link:#1903 #1896

### Type of change

- [x] Bug Fix (non-breaking change which fixes an issue)

---------

Signed-off-by: Jin Hai <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature request New feature or request
Projects
None yet
Development

No branches or pull requests

3 participants