Skip to main content

Open Source Ticket Data Model

The Open Source Ticket data model is a record that documents the interactions and progress made on a single or group of open source findings. It extends the Ticket data model.

The following table details the default attributes of the Open Source Ticket data model:

Attribute NameAttribute TypeRelationship TypeRequired
ageInDaysCalculated (Number)N/ANo
assignedReference (User)BELONGS_TONo
attachmentsAttachmentsN/ANo
baseRiskScoreCalculated (Number)N/ANo
buidTextN/ANo
categoriesText (Multivalued)N/ANo
commentsCommentsN/ANo
complianceStatusCalculated (Single Choice)N/ANo
connectorCategoriesText (Multivalued)N/ANo
connectorNamesText (Multivalued)N/ANo
createdByTextN/ANo
dataIntegrationTitlesText (Multivalued)N/ANo
dataModelNameCalculated (Text)N/ANo
dateClosedCalculated (Date Time)N/ANo
dateCreatedDate TimeN/ANo
daysToFixCalculated (Number)N/ANo
delegatesReference (User)DELEGATED_TONo
descriptionTextN/ANo
displayNameCalculated (Text)N/AYes
dueDateCalculated (Date Time)N/ANo
externalUidsTextN/ANo
findingsReference (Open source finding)HASNo
flowStateTextN/ANo
lastUpdatedDate TimeN/ANo
nameTextN/ANo
previousFindingsReference (Open source finding)PREVIOUS_HASNo
progressNumberN/ANo
recommendationTextN/ANo
riskFactorOffsetCalculated (Number)N/ANo
riskFactorsRisk FactorsN/ANo
riskRatingCalculated (Single Choice)N/ANo
riskScoreCalculated (Number)N/ANo
riskScoringModelRisk Scoring ModelN/ANo
slaCalculated (Number)N/ANo
slaDefinitionSLAN/ANo
slaDefinitionNameTextN/ANo
slaLevelCalculated (Text)N/ANo
sourceFirstFoundDate TimeN/ANo
sourceLastFoundDate TimeN/ANo
sourcesReference (Base model)SOURCED_FROMNo
sourcesIconsSource data models iconsN/ANo
sourceUidsText (Multivalued)N/ANo
sprintReference (Sprint Model)BELONGS_TONo
statusStatusN/ANo
statusCategoryCalculated (Single Choice)N/ANo
summaryTextN/ANo
uidTextN/AYes
updatedByTextN/ANo
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.