GreenDao, querying for a list of strings

Question

Within my application I have an Entity / table that has a Name field (among several other fields). I want a list of Strings of all the unique names found in that table.

Right now the only thing I can think of is to load all the results into a list of entity objects, iterate over them, and store the names in a Set, and then convert this Set into a List.

It seems inefficient though. Does GreenDao support a feature like this natively or must all queries return Entity objects?

score 1 · Accepted Answer · edited May 23 '17 at 12:33

1

It doesn't support it natively. You'll have to use the rawQuery approach and pass either a DISTINCT or GROUP BY sql query.

Usage of rawQuery for this scenario has been answered here

edited May 23 '17 at 12:33

Community

1
1

answered Nov 19 '16 at 23:35

thudbutt

1,481
1
19
32

How exactly? What does the code look like for using the rawquery approach? – KaliMa Nov 20 '16 at 02:21
@KaliMa: I added a link to another SO post which contains an example. – thudbutt Nov 20 '16 at 10:04

GreenDao, querying for a list of strings

1 Answers1