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.