jeudi 11 juin 2015

sqlite active android BETWEEN option

I am using sqlite in my application with activeAndroid lib .

i want to get all the rows from a table, where the value of a certain column(long type) is within a range i specified.

in SQL it can be achieved by :

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;

my current method is :

List<Report> reports = new Select()
        .from(Report.class)
        .execute();

which brings all of the rows in the table

Aucun commentaire:

Enregistrer un commentaire