BPM to do the validation is actually pretty simple. Add a new condition widget in the BPM, and choose the condition for “Number of rows in the designed query”.
Then design your query… you would link the ttLaborDtl table to the JobHead, and create the relations
THEN you add the criteria to specify that only records that are LESS THAN the frozen will be returned…
Something special about this WIDGET… it gives you a record count… so now we just need to tweak this. BECAUSE, if we find one, it is good, if it returns nothing (because it is on/after the frozen value).
All that is left is to add an Exception message to stop the transaction:
