Sugar ORM as in request to take boolean

Question

I can not pull data with a query for a boolean value. I do the request as follows:

List<DB> listPhrase = DB.find(Database.class, "history = ?", "true");

I tried it like this:

 List<DB> listPhrase = DB.find(DB.class, "history = ?", String.valueOf(true));

The data in the database are entered as follows:

 pDB.add(new DB(1, "rrrr", tab_list_I[0], "qqqq", "wwww", "eeee", false, false, false));

tse tse 3,473 6 25 · Accepted Answer · 2017-01-21T19:49:04

Try

 List<DB> listPhrase = DB.find(Database.class, "history = ?", "1");

The problem may be that in SQLite there is no type boolean, instead an integer is used with the values 0 and 1 .

1 answer 1