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?