LISTCRM

Returns all or specified log records from the CRM table.

Reporting Area(s)

Names, Registrations

Required Parameters

1. Name ID (i.e. nmid,rgid,pyid)

Optional Parameters

2. Fields from CRM table to return (i.e. "crmtype", DTOC(crmdate) )
3. Condition to return CRM records (i.e. "crmtype='E' ")
4. Delimiter to place between CRM records (i.e. CHR(13) carriage return [default],CHR(9) tab)

Example(s)

LISTCRM(nmid) returns all individual's CRM log records.

LISTCRM(nmid,"crtype+CHR(9) + DTOC(crmdate)+CHR(9)+crmsubject") returns type, date, and subject of all individual's CRM log records.

LISTCRM(nmid,"",crmtype='E' ") returns all individual's Email Log records.

Related Functions

CRMRPT