CNTCURFIELD

Used in a JUSTDOIT to count occurrence of a condition (i.e. rgstatus="NOSHOW") in the cursor (and write it to the cursor).

Reporting Area(s):

General

Required Parameters:

Field in cursor on which to group (i.e. "nmid")

Optional Parameters:

Condition in cursor to count (i.e. "rgstatus=[Completed]")

Example(s):

JUSTDOIT('select *,CNTCURFIELD("nmid") as IDCOU,0 as marker from (cursor5) into cursor(cursor5)') returns in the IDCOU field in the cursor, the number of records for each individual.

JUSTDOIT('select *,CNTCURFIELD("nmid","rgstatus=[Completed]") as IDCOMPLETE,0 as marker from (cursor5) into cursor(cursor5)') returns in the IDCOMPLETE field in the cursor, the number of completed registrations for each individual.

Notes:

This function can only be used in a JUSTDOIT.