I have two entities A and B with many-to-many assoc. A screen uses two lookup fields. The first one offers to select any A entity, while the second should offer only that B, which have relation to selected A. A nested datasourse works well, but I need to use extra where conditions (like current B status etc). I suppose something like that should work, but it doesn’t:
select e from muz$Teacher e where :ds$subjectsDs MEMBER OF e.subjects
because agrument is UUID while mapping uses Entity.
QueryException: Exception Description: The class of the argument for the object comparison is incorrect. Expression: [null] Mapping: [org.eclipse.persistence.mappings.ManyToManyMapping[subjects]] Argument: [7a8e4f1c-a460-1bc7-155e-674022b34e1d]
What is the best way to do this?