Since you encountering more records than expected, do all records in the table “Approval” have False assigned assigned to the field “approved”?
Try this in your method: ALL RECORDS([Approvals]) $count_all := Records in selection([Approvals]) QUERY([Approvals];[Approvals]approved=False) $count_query := Records in selection([Approvals]) Are the two counts equal? > On Jul 3, 2018, at 12:48 PM, Noah via 4D_Tech <4d_tech@lists.4d.com> wrote: > > … Stepping through the code I > could see that where we were supposed to be looping over the records in the > current selection, we were instead dealing with the whole selection. > > QUERY([Approvals];[Approvals]approved=False) ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************