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
**********************************************************************

Reply via email to