subquery not returning result

[hboumedane]

Hello,
I want your help about a subquery that i'm trying to run inside my code but it's not returning the result (empty ) but if a run this subquery directly i got the correct result.

 List<Event> listEvents = _eventCrud.query(new OSQLSynchQuery<>("select * from Event where @rid in (select events from tabe where uuid = ?)"), tableID);

table and event are two models link together through oneToMany relation ?

[barjo]

Sorry, I am not sure I understand. What do you mean by: "If I run this subquery directly I got the correct result".

[hboumedane]

directly mean inside server console or through the web browser