Option Formats

Some data fields that you export from an event or a collection give you a choice to pick a desired output format. The syntax for these fields is:

+++= data-field.option

DateTime Formats

When using a time-based field like archivedAt, createdAt, updatedAt, or deletedAt, you must specify a datetime option to output a specific datetime format.

The syntax follows +++= dateTimeField.dateTimeOption, where dateTimeOption can be any of the entries in the following table:

Date Time Option	Output Example
dateTimeLocal	October 15th, 2022 at 11:06 AM
dateTimeLocalTZ	October 15th, 2022 at 11:06 AM PDT
dateTimeUTC	October 15th, 2022 at 6:06 PM UTC
dateLocal	October 15th, 2022
dateLocalTZ	October 15th, 2022 PDT
dateUTC	October 15th, 2022 UTC
shortLocal	10/15/2022
shortLocalTZ	10/15/2022 PDT
shortUTC	10/15/2022 UTC
isoDate	2022-10-15T18:06:55Z
shortLocalTZ	10/15/2022 PDT
shortUTC	10/15/2022 UTC
isoDate	2022-10-15T18:06:55Z
timeLocal	11:06 AM
timeLocalTZ	11:06 AM PDT
timeUTC	11:06 AM UTC

tip

For example, to export a collection's CreatedAt field in your local date time with a timezone, use +++= createdAt.dateTimeLocalTZ.

User Formats

Specific user information can be included using the following options:

User Option	Output Example	Notes
id	70d3d3a6-8c52-4483-8610-e4da9192775c	N/A
firstName	John	N/A
lastName	Doe	N/A
email	jdoe@cogility.com	N/A
role	Threat Analyst	N/A
fullName	John Doe	N/A
fullNameAndEmail	John Doe (jdoe@cogility.com)	N/A
fullNameAndRole	John Doe (Threat Analyst)	N/A
groups	Group One, Group Two	N/A
createdAt.dateTimeOption	DateTime	See Datetime Formats
deletedAt.dateTimeOption	DateTime	See Datetime Formats
updatedAt.dateTimeOption	DateTime	See Datetime Formats
lastLoginAt.dateTimeOption	DateTime	See Datetime Formats

tip

To get the name of a collection's assigned user and their email in two separate lines, use the following:

+++= assignedToUser.fullName +++

+++= assignedToUser.email +++

To loop through all participants and output their full name and last login date in local time (at the time the export was performed):

+++FOR person IN participants +++

+++= $person.fullName +++

+++= $person.lastLoginAt.dateTimeLocal +++

+++END-FOR person+++