Hi,

I have a class (Trade) and a subclass (Operation). They are mapped in the database. So when I do:

trades = session.createQuery("from Trade").list() -> I get an arraylist of trade records and can access the operations for certain trade through trade instance.

However, when I do:

trades = session.createQuery("from Trade as trade inner join trade.operations as operation with to_char(operation.datetime, 'yyyyMMdd') = to_char(sysdate, 'yyyyMMdd') order by operation.datetime").list(); -> I get an array of objects where each element contains operation and trade instance.

How could I retrieve records as an array of trades (same as first option) with conditions (same as second option)?

Thanks in advance!

just have a try like this

trades = session.createQuery("select trade from Trade as trade inner join trade.operations as operation with to_char(operation.datetime, 'yyyyMMdd') = to_char(sysdate, 'yyyyMMdd') order by operation.datetime").list();

Yeah, I tried that and it worked, thanks! However, when I access to the operations list, I see that I get all the operation by any day, so it doesn't satisfy the condition. Any idea?

哥们，你用的什么数据库？
把with改成where试下
trades = session.createQuery("select trade from Trade as trade inner join trade.operations as operation where to_char(operation.datetime, 'yyyyMMdd') = to_char(sysdate, 'yyyyMMdd') order by operation.datetime").list();

What?

Sorry!
I thought you know Chinese.
You can modify "with" to "where",and try it again.

trades = session.createQuery("select trade from Trade as trade inner join trade.operations as operation where to_char(operation.datetime, 'yyyyMMdd') = to_char(sysdate, 'yyyyMMdd') order by operation.datetime").list();

what database do you use?