Ticket Data Model
The Ticket data model is a record that documents the interactions and progress made on a single or group of findings. It extends the Entity model data model.
The following table details the default attributes of the Ticket data model:
| Attribute Name | Attribute Type | Relationship Type | Required |
|---|---|---|---|
ageInDays | Number | N/A | No |
assigned | Reference (User) | BELONGS_TO | No |
attachments | Attachments | N/A | No |
baseRiskScore | Number | N/A | No |
buid | Text | N/A | No |
categories | Text (Multivalued) | N/A | No |
comments | Comments | N/A | No |
complianceStatus | Single Choice | N/A | No |
connectorCategories | Text (Multivalued) | N/A | No |
connectorNames | Text (Multivalued) | N/A | No |
createdBy | Text | N/A | No |
dataIntegrationTitles | Text (Multivalued) | N/A | No |
dataModelName | Calculated (Text) | N/A | No |
dateClosed | Date Time | N/A | No |
dateCreated | Date Time | N/A | No |
delegates | Reference (User) | DELEGATED_TO | No |
description | Text | N/A | No |
displayName | Text | N/A | Yes |
dueDate | Date Time | N/A | No |
externalUids | Text | N/A | No |
findings | Reference (Finding) | HAS | No |
flowState | Text | N/A | No |
lastUpdated | Date Time | N/A | No |
name | Text | N/A | No |
previousFindings | Reference (Finding) | PREVIOUS_HAS | No |
progress | Number | N/A | No |
recommendation | Text | N/A | No |
remediationCampaigns | Reference (Remediation campaign) | HAS | No |
riskFactorOffset | Number | N/A | No |
riskRating | Single Choice | N/A | No |
riskScore | Number | N/A | No |
riskScoringModel | Risk Scoring Model | N/A | No |
sla | Number | N/A | No |
slaDefinition | SLA | N/A | No |
slaDefinitionName | Text | N/A | No |
slaLevel | Text | N/A | No |
sourceFirstFound | Date Time | N/A | No |
sourceLastFound | Date Time | N/A | No |
sources | Reference (Base model) | SOURCED_FROM | No |
sourcesIcons | Source data models icons | N/A | No |
sourceUids | Text (Multivalued) | N/A | No |
sprint | Reference (Sprint Model) | BELONGS_TO | No |
status | Status | N/A | No |
statusCategory | Single Choice | N/A | No |
summary | Text | N/A | No |
uid | Text | N/A | Yes |
updatedBy | Text | N/A | No |
FOOTNOTES
- The attribute names are used in Brinqa Query Language (BQL) queries and Brinqa Condition Language (BCL) predicates.
- In the Type column, Calculated means that the value of the attribute is computed by executing a script. The text in the parentheses after Calculated denotes the type of the outcome.
- In the Type column, Reference means that two data models are related. The name in the parentheses after Reference indicates the other data model.
- The Relationship Type column only applies to the Reference type attributes. You can use the relationship type keyword in BQL queries.