Here is the condition definition:
Here is the result of model.soql (which I believe reflects the query that is actually executing?):
SELECT HasCompleteAppointment\_\_c, HasScheduledAppointments\_\_c, Patient\_\_c, Patient\_\_r.Name, (SELECT Signature\_Name\_\_c,Signature\_Date\_\_c,Signature\_Text\_\_c,SignatureData\_\_c,Id FROM Signatures\_\_r WHERE ((Signature\_Type\_\_c = 'MD Medical Chart')) LIMIT 10), Id FROM Patient\_Case\_\_c WHERE (HasCompleteAppointment\_\_c \> 0.0) AND(HasScheduledAppointments\_\_c = 0.0) AND(Id not in ( SELECT Patient\_Case\_\_c FROM Signature\_\_c **WHERE (((Signature\_Type\_\_c = 'MD Medical Chart')))** ) ) LIMIT 21
Notice that only the first subquery condition is executing. Any idea how to make all four conditions execute?