How do I load all fields from a database and sort the result after one row with GreenDao?

Question

I want to load all entities from a sqlite database with greendao and sort the result.

I can load all entities with loadAll but this doesn't gives me a guarantee about the sorting of the resulting list.

`AbstractDao.queryBuilder().orderAsc(...).list()` – Selvin Dec 29 '14 at 10:16 — Selvin, Dec 29 '14 at 10:16

mmlooloo · Accepted Answer · 2014-12-29T10:27:22.203

14

Use queryBiulder like below:

List joes = userDao.queryBuilder().where(Properties.FirstName.eq("Joe")).orderAsc(Properties.LastName).list();

for all rows:

List joes = userDao.queryBuilder().orderAsc(Properties.LastName).list();

edited Dec 29 '14 at 10:27

answered Dec 29 '14 at 10:16

mmlooloo

That loads only the row where username is Joe. I want to load all fields of the table. – Janusz Dec 29 '14 at 10:19
This is an example you can change the query to load all. – mmlooloo Dec 29 '14 at 10:20
And how do I do that? – Janusz Dec 29 '14 at 10:21

1 Answers1