Hi!
I created a rule that uses Appointment BO. In the rule there is a condition:
...WHERE Appointments.EndTime<=ThisAppointments.EndTime...THEN
It checks All previous Appointments, EXCEPT that are in the next dates.
So the whole rule works perfect, but only while I am adding a new Appointment item. But how to make rule work so actions could be executed while conditions are held in any time. In example below if I add appointments in order form rule works while am doing that but if AFTER THAT I change(add) a Payment.Amount so that conditions of a rule are held -- rule doesnt work.
I changed WHERE with WHILE rule is not accepted. Also I have selected "Supports While semantics" and "Use rule in dynamic re-calculation on form".
The whole rule:
If ThisAppointments.Value1<=SUM Payment.Amount WHERE (Payment.Order=Appointments.Order)-SUM ThatAppointments.Value1 WHERE ((Appointments.EndTime<=ThisAppointments.EndTime) AND ThisAppointments.Order=Appointments.Order) Then Appointments.Status='Smt'
Will be thankful for any help.