How can get top of records by GreenDAO?

Question

I wanna to get top some records from my table, but GreenDAO doesn't provide it. Like this:

SELECT TOP 1 * FROM table_name

In LINQ you can get top of records with Take(), is there any solution for GreenDAO?

Could every one offer a suggestion?

Markus Junginger · Accepted Answer · 2012-10-24T15:57:55.623

17

You can specify a limit using standard QueryBuilder:

List<YourEntity> entities = yourDao.queryBuilder().limit(1).list();

edited Oct 24 '12 at 15:57

answered Oct 21 '12 at 08:59

Markus Junginger

Unfortunately When I run it, doesn't work and show error. please write a complete example(when I want to get a row from a table) – Omid Nazifi Oct 23 '12 at 05:38
Thanks @greenrobot, you was right. I did test it and it worked correctly. – Omid Nazifi Oct 27 '12 at 05:02
sorry for found it too late, please expain what is "limit(1)" , many thanks – kemdo Feb 26 '15 at 08:46
limit(n) - select top n records from table – niveuseverto Oct 13 '15 at 14:43
@niveuseverto top n records mean, first added or last added? – Thamilan S Jul 26 '17 at 10:14
@Mani depends on order clause – niveuseverto Jul 27 '17 at 17:51

score 0 · Answer 2 · answered Oct 16 '20 at 08:16

0

 var mcc: SearchDao
      
 val list: List<Search?> =mcc.queryBuilder().orderDesc(SearchDao.Properties.Time).limit(8).list()

answered Oct 16 '20 at 08:16

Armin Haghighi

2 Answers2