Temporary table threshold for IN clauses

[patrick1366356481]

Hi,

A while ago we had an issue with the query builder which would translate certain queries using an IN clause incorrectly when the clause contained more than 200 values. The issue was:
https://support.servoy.com/browse/SVY-7347.

Jan Blok mentioned in a comment that starting from Servoy 7.4.2 it would become possible to configure the threshold. While the actual bug has indeed been fixed I would still like to be able to configure the threshold for performance reasons. However, I cannot find documentation about it on the Servoy wiki. Is documentation available?

Regards,
Patrick

[Gabi Boros]

we updated the wiki with this setting, see https://wiki.servoy.com/display/Serv7/M ... e+Settings , "servoy.selectINValueCountLimit"

[patrick1366356481]

Gabi, in my 7.4.2 installations this isn't exposed in the admin page. Will it work if I add it manually in servoy.properties?

[Gabi Boros]

yes, it will work, the setting is used in 7.4.2 final, just it is not listed in the admin page