[Modeling-users] right-hand side of IN operator must be constant

[Mario R. <ma...@ru...>]

Hello!

I am attempting to use the tempting IN operator, however, it doesn't 
like me doing that ;)
The field I am using it on is a nothing-special string attribute:

GeneralAdaptorException: Couldn't evaluate expression SELECT  COUNT(*)  
FROM SomeTable t0 WHERE ((t0.CREATEDATE > '2003-11-22 09:29:15.65' AND 
t0.ACTION IN (one, two, three, four)) AND t0.USERNAME = 'john'). 
Reason: _sqlite.DatabaseError:right-hand side of IN operator must be 
constant

The qualifier that I pass to fetchCount() is:

createdate>"2003-11-22 10:44:53.25" AND action IN 
["one","two","three","four"] AND username=="john"

Am I misusing this, or is this a problem with the IN operator?

Cheers, mario