How to make a conditional query in a List in JPA?

Question

Java

Good afternoon, please tell me how to make a query to the database.
I get as input a List of parameters id operators .
Now I need to make a request through JPA, I need to select all the records that contain the received id.
now I have a custom request

@Query(value = "FROM Task WHERE (Tasksid = null) AND  Operator = :OperatorIds")
    Set<Task> qualityTaskWIthoutCOmparsionId(@Param("OperatorIds") List<Long>  OperatorIds);

org.postgresql.util.PSQLException
: ERROR: operator does not exist: bigint = bytea
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
How can I build a query correctly?

Answer 1

Operator IN :OperatorIds

Answer 2

As mentioned above, you need to use the following code

@Query(value = "FROM Task WHERE (Tasksid = null) AND Operator IN (:OperatorIds)")
Set<Task> qualityTaskWIthoutCOmparsionId(@Param("OperatorIds") List<Long>  OperatorIds);

And the error
org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = bytea
appears most likely due to the fact that null comes