• After 15+ years, we've made a big change: Android Forums is now Early Bird Club. Learn more here.

Apps How to implement "NOT IN" SQL-select in activeRecord

vovs

Newbie
Have some question:

In my app I use (ActiveRecord)org.kroz.activerecord

And need a SQL-select that contains "NOT IN" condition,
but I do not know how to implement:
Something this

Code:
"SELECT * FROM table_name WHERE id NOT IN (5, 6, 8)"

Here is JavaDoc for method find()

Code:
find(type, distinct, whereClause, whereArgs, groupBy, having, orderBy, limit)
    Return all instances of an entity that match the given criteria.
    Parameters:
    <T> Any ActiveRecordBase class.
    type The class of the entities to return.
    distinct
    whereClause The condition to match (Don't include "where").
    whereArgs The arguments to replace "?" with.
    groupBy
    having
    orderBy
    limit
    Returns:
    A generic list of all matching entities.

Thanks!
 
Back
Top Bottom