`SystemUser.FirstName` `SystemUser.LastName` `Address.Street1` `Address.Street2` `Address.City`, `Address.State` `Address.Zip` `IF SystemUser.Phone <> "" THEN SystemUser.Phone ELSE "No Phone"` `IF SystemUser.Fax <> "" THEN SystemUser.Fax ELSE "No Fax"` `IF SystemUser.Pager <> "" THEN SystemUser.Pager ELSE "No Pager"` `IF SystemUser.Mobile <> "" THEN SystemUser.Mobile ELSE "No Mobile"` `IF SystemUser.Email <> "" THEN SystemUser.Email ELSE "No Email"` |
Ticket `Ticket.Reference`
Status `TicketStatus.Name` Ticket Type `TicketType.Name` Problem Type`ProblemType.Name` Priority `Priority.Name` |
|
|
|
|
|
`STRING(Note.CreateDate)` ` STRING(Note.CreateTime, "HH:MM:SS")` `Note.NoteText` |