ORMLite Select Distinct Fields
I would like to select a distinct set of this data and use them as actual objects.
ORMLite supports a distinct()
method on the QueryBuilder
that should do what you want. So your code would look something like:
List<Book> results = booksDao.queryBuilder()
.distinct().selectColumns("author").query();
In this case, the resulting Book
objects would only have the author
field set and not the id
field or anything else. If you just wanted the author names instead of objects then you could do:
GenericRawResults<String[]> rawResults =
booksDao.queryRaw("SELECT DISTINCT author FROM books");
for (String[] resultColumns : rawResults) {
String author = resultColumns[0];
...
}