QBSelect isin limit
Posted: Thu Jun 14, 2018 3:53 pm
In servoy 7.4.9 I see that the array given for isin in a QBSelect is limited at 200 values. When the length of the array is bigger, an error occurs: QueryFunction cannot be cast.
rgansevles wrote:The number of values is not limited to 200, with many in-values Servoy will generate a different query but will still work.
The exception you see does not occur on the latest Servoy.
Rob
joe26 wrote:I've used sub queries successfully in the past.
var q = databaseManager.createSelect(xxx)
q.result.add(q.column.name_column)
var r = databaseManager.createSelect(xxx)
q.result.add(q.column.other_column)
q.where.add(q.column.name_column.isin(q)
At least that's from memory... q should only return one row.
ionelioras wrote:So this behavior was present in previous versions of Servoy, like 7.4.9?