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]

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?

[Shaphil]

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

#351

Seems like your PR was merged, but I can't seem to get it to work. I currently have a similar solution as @lz1998,

let mut user_pages = User::find();
    sea_orm::QueryTrait::query(&mut user_pages)
        .offset(offset as u64)
        .limit(page_size as u64);

would be really nice to see an example of this chained with find(), like this maybe? (I tried this first and it doesn't work)

let mut user_pages = User::find()
        .order_by_asc(entity::user::Column::Id)
        .offset(offset as i64)
        .limit(page_size as i64)
        .paginate(&app_state.db, page_size as u64);