How to filter by offset and limit?

[lz1998]

I don't want to find by page, because the input param is offset and limit.

[billy1624]

Hey @lz1998,

You can do it with Paginator

• https://docs.rs/sea-orm/0.4.0/sea_orm/struct.Paginator.html

But I think we should have included limit & offset in our select API.

[lz1998]

What should I do if the input is offset=3 and count=4?

[lz1998]

This works, but it's not convenient.

    let mut q = Entity::find();
    sea_orm::QueryTrait::query(&mut q).offset(0).limit(1);
    q.all(conn).await

[lz1998]

I have created a Pull Request to add offset and limit.

#351

[billy1624]

Thanks!! @lz1998 will check the PR later tonight

[lz1998]

Thanks!! @lz1998 will check the PR later tonight

Sorry, I pushed with a wrong email and username. Could you please run the workflow to check it again?