Counting Matching Lines in a List

Doug Easterbrook doug at artsman.com
Mon Nov 19 09:27:49 EST 2018


calculate count as ilist.$totc(iList.ColContaining1=1)

or

do ilist.$search($ref.ColContaining1=1,ktrue,kfalse,ktrue,ktrue)
calculate count as ilist.$totc(#lsel)




Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On Nov 19, 2018, at 5:35 AM, Andrew McVeigh <omnis at surfway.com.au> wrote:
> 
> Simple question, what is the best way to count all of the matches in a list.
> I have a field that has either 0, 1 or 2 in it in the list and I want to count how many lines have 1 in that field
> 
> Andrew McVeigh
> Surfway Real Solutions
> Phone 02 44412679 Mobile 0418428016
> www.surfway.com.au
> www.berrarabeach.com.au
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 




More information about the omnisdev-en mailing list