Hi,

I have a problem with searching. I have an Equipment entity which can have n EquipmentInstances. Each EquipmentInstance (call it inst) has a "last visited date" and each Equipment (call it equi) has a "checking period".

I want to find the instances which has the following condition:


What I myself think is to use formula, but I don't know how.

Any help will be appreciated. Thanks inadvance.

Well, could you precise what you want to do, because from what you say, if you need to search, you don't want to use formula, but a query instead (sql, hql, or criteria say).

Hi,

I have two problems, one is calculating the date (to calculate n day after a date) and the other one is that I should follow the foreign keys to find the appropriate Equipment of each EquipmentInstance (which I couldn't do we Criteria).

If you have any other solution (Criteria, HQL, ...) that may help me, I will be grateful.

Thanks again.