greenrobot/greenDAO — Issue #23: NOT IN Where Condition
Author: chrisjenx
Created: 2012-02-14 09:46:29+00:00
State: open

Would it be possible to add a NOT IN where condition.

I use this sometimes for excluding already read rows etc..

At the moment I am doing:

mRandomFoodQuery.where(new WhereCondition.PropertyCondition(FoodDao.Properties.Id,
" NOT IN " + mSb.toString()));

"mSb.toString()" is the generated (1,2,3,4) string generated for the query.

Of course this works fine, but I guess im loosing performance of generating the query all the time instead of having a cached one which I can replace Where values.

Cheers,
Chris