All Collections
Data & operations
Functions Overview
ARRAY_FIND
AT_INDEX
BEGINNING_OF_DAY
BEGINNING_OF_HOUR
BEGINNING_OF_MONTH
BEGINNING_OF_QUARTER
BEGINNING_OF_WEEK
BEGINNING_OF_YEAR
BETWEEN
CONCAT
CONTAINS
CONTAINS_ALL
CONTAINS_EXACTLY
DATE
DAY
DAY_OF_WEEK
DAY_OF_YEAR
END_OF_DAY
END_OF_HOUR
END_OF_MONTH
END_OF_QUARTER
END_OF_WEEK
END_OF_YEAR
EXP
FLATTEN
GREATEST
HOUR
IF
IF_NULL
IF_MATCH
IF_ZERO
IN
IS_NULL
IS_NOT_NULL
LEAST
LEFT
LENGTH
LN
LOG
MATCH
MOD
MONTH
NOT
NOT_CONTAINS
NOT_MATCH
NOW
POWER
QUARTER
RIGHT
ROUND
ROUNDDOWN
ROUNDUP
SHA1
SHA256
TIMELINE_DURATION
TIMELINE_FIRST_END_AT
TIMELINE_FIRST_START_AT
TIMELINE_LAST_END_AT
TIMELINE_LAST_START_AT
TO_FLOAT
TO_INT
TO_STR
WEEK
YEAR
YEAR_MONTH
YEAR_MONTH_DAY
YEAR_WEEK
YEAR_QUARTER
Activity Events Dataset Overview
Activity Events > Action
Activity Events > Author
Activity Events > Created at
Activity Events > Duration
Activity Events > ID (source)
Activity Events > ID (system)
Activity Events > Project
Activity Events > Source App
Activity Events > Target User
Activity Events > Updated at
Activity Events > Value at
Activity Events > Workflow Status
Issues & Pull Requests Dataset Overview
Issues and PRs > Approvals
Issues and PRs > Assignees
Issues and PRs > Assigned at
Issues and PRs > Author
Issues and PRs > Base ref | Branch
Issues and PRs > Base ref | Repository
Issues and PRs > Body
Issues and PRs > Build status
Issues and PRs > Created at
Issues and PRs > Closed at
Issues and PRs > Due on
Issues and PRs > First comment after review requested at
Issues and PRs > First comment at
Issues and PRs > First commit at
Issues and PRs > First review created at
Issues and PRs > First review submitted at
Issues and PRs > Head ref | Branch
Issues and PRs > Head ref | Repository
Issues and PRs > ID (system)
Issues and PRs > ID (source)
Issues and PRs > Key
Issues and PRs > Labels
Issues and PRs > Last assigned at
Issues and PRs > Last comment at
Issues and PRs > Last commit at
Issues and PRs > Last commit before first review
Issues and PRs > Review approved at
Issues and PRs > Last review created at
Issues and PRs > Last review submitted at
Issues and PRs > Lines added
Issues and PRs > Lines changed
Issues and PRs > Lines deleted
Issues and PRs > Mergeability
Issues and PRs > Merged at
Issues and PRs > Merged by
Issues and PRs > Metatags
Issues and PRs > Past reviewers
Issues and PRs > Project
Issues and PRs > Recommended action
Issues and PRs > Recommended actors
Issues and PRs > Requested reviewers
Issues and PRs > Required approvals
Issues and PRs > Required approvals remaining
Issues and PRs > Review state
Issues and PRs > Resolution state
Issues and PRs > Resolved Issue IDs (System)
Issues and PRs > Resolved Issue first closed at
Issues and PRs > Resolved Issue first created at
Issues and PRs > Resolved Issue last assigned at
Issues and PRs > Resolved Issue last created at
Issues and PRs > Resolving PR IDs (System)
Issues and PRs > Resolving PR first closed at
Issues and PRs > Resolving PR first merged at
Issues and PRs > Review last approved at
Issues and PRs > Resolving PR last closed at
Issues and PRs > Resolving PR last created at
Issues and PRs > Resolving PR last merged at
Issues and PRs > Review last rejected at
Issues and PRs > Review last requested at
Issues and PRs > Resolved Issue last closed at
Issues and PRs > Review rejected at
Issues and PRs > Review requested at
Issues and PRs > Source App
Issues and PRs > State
Issues and PRs > Story points
Issues and PRs > Sub-Type
Issues and PRs > Suggested Mergers
Issues and PRs > Time estimate
Issues and PRs > Time spent
Issues and PRs > Title
Issues and PRs > Type
Issues and PRs > Updated at
Issues and PRs > URL
Issues and PRs > Workflow Status
Issues and PRs > Workflow Timeline
Issues and PRs > Resolved Issue Labels
Issues and PRs > Resolving PR label name
Issues and PRs > Resolving PR first created At
Issues and PRs > Resolved Issue first assigned at
Issues and PRs > Owners
Issues and PRs > Past Assignees
Issues and PRs > Resolved Issue Sub-Types
Issues and PRs > Resolved Issue Metatags
Issues and PRs > Past Workflow Statuses
Issues and PRs > Resolving PR Authors
Issues and PRs > Resolving PR Assignees
Issues and PRs > Resolved Issue Authors
Issues and PRs > Resolved Issue Assignees
Comments dataset
Comments Dataset Overview
Comments > Author
Comments > Body
Comments > Created at
Comments > Updated at
Comments > URL
Comments > Project
Comments > ID (system)
Comments > ID (source)
Comments > Source App