Exception with list parameter

Support
#1

I have method like that :

public boolean isExistCode(List<String> codes) {
        return dataManager.loadValue("select count(g) from Grade g where g.status <> :status and lower(g.gradeCode) in (:codes) ", Integer.class)
            .parameter("status", Constant.INACTIVE).parameter("codes", codes).one() > 0;
    }

How can i pass list parameter for jpql ?

Caused by: io.jmix.data.impl.jpql.JpqlSyntaxException: Errors found for input jpql:[select count(g) from Grade g where g.status <> :status and lower(g.gradeCode) in (:codes)]
CommonErrorNode [<unexpected: [@26,64:64='(',<27>,1:64], resync=lower(g.gradeCode) in (:codes)>]
	at io.jmix.data.impl.jpql.Parser.checkTreeForExceptions(Parser.java:112) ~[jmix-data-1.2.4.jar:na]
	at io.jmix.data.impl.jpql.Parser.parse(Parser.java:40) ~[jmix-data-1.2.4.jar:na]
	at io.jmix.data.impl.jpql.QueryTree.<init>(QueryTree.java:50) ~[jmix-data-1.2.4.jar:na]
#2

Try to remove parentheses around parameter: in :codes

#3

It work with

g.gradeCode in :codes

but when i use

lower(g.gradeCode) in :codes

still error with same exception

#4

Please create an issue at Issues · jmix-framework/jmix · GitHub