search

chennaione / sugar

Insanely easy way to work with Android Database.
http://satyan.github.com/sugar/
MIT License
2.62k stars 583 forks source link

[REQUEST-FEATURE] Where is OFFSET parameter in SugarRecord::find method #737

Closed kasim1011 closed 7 years ago

kasim1011 commented 7 years ago

Android SQLite database supports OFFSET keyword [1:- here, 2:- here]. There's no OFFSET parameter available in SugarRecord::find method.

Currently is there any way if I want to use OFFSET?

kigen commented 7 years ago

I believe this is currently possible by writing a raw SQL query Example: 

Users.findWithQuery(Users.class, "SELECT * FROM USERS LIMIT ? OFFSET ?","10","0");
kasim1011 commented 7 years ago

@kigen Thanks.