Table Apm_Sprints

Entity

Stores the definition, schedule, and metrics for each Agile sprint (iteration) within a project or team (social group). A sprint is a fixed timebox used to deliver a defined set of backlog items (Cases) toward a sprint goal. It supports sprint planning, execution tracking, and historical reporting. Entity: Apm_Sprints (Introduced in version 26.1.4.32)

Summary

Name	Type	Description
Activated_At	`datetime`	Timestamp when the sprint was activated.
End_Date	`date`	End date of the sprint’s timebox.
Goal	`nvarchar(500)`	Short description of the main objectives or focus for the sprint.
Name	`nvarchar(100)`	Human-readable sprint name, e.g. “Sprint 14”
Project_Id	`uniqueidentifier`	Project to which this sprint belongs.
Row_Version	`timestamp`
Social_Group_Id	`uniqueidentifier`	Team (social group) responsible for the sprint. NULL if the sprint applies to the entire project without team distinction
Sprint_Id	`uniqueidentifier` `PK`
Start_Date	`date`	Start date of the sprint’s timebox.
State	`char(3)` Allowed: `PLN`, `ACT`, `CMP`, `CNC`, Readonly	Current sprint status: Planned, Active, Completed, Cancelled.

Columns

Activated_At

Timestamp when the sprint was activated.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	8
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	datetime (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Activated_At - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no
GreaterThanOrLessThan	None	no	no

End_Date

End date of the sprint’s timebox.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	6
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	date
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

End_Date - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no
GreaterThanOrLessThan	None	no	no

Goal

Short description of the main objectives or focus for the sprint.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	500
Order	4
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(500) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Goal - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no
Like	None	no	no

Name

Human-readable sprint name, e.g. “Sprint 14”

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	100
Order	3
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(100)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Name - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no
Like	None	no	no

Project_Id

Project to which this sprint belongs.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	1
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Apm_Projects
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Project_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Row_Version

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	9
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	timestamp
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Social_Group_Id

Team (social group) responsible for the sprint. NULL if the sprint applies to the entire project without team distinction

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Cmm_Social_Groups
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Social_Group_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	yes	no

Sprint_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	NewGuid
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	0
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	yes (order: 1)
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Sprint_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Start_Date

Start date of the sprint’s timebox.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	5
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	date
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Start_Date - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no
GreaterThanOrLessThan	None	no	no

State

Current sprint status: Planned, Active, Completed, Cancelled.

Property	Value
Allowed Values	`PLN`, `ACT`, `CMP`, `CNC`
Auto Complete	no
Data Filter	no
Default Value	PLN
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	3
Order	7
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	yes
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	char(3)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

State - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no

Table of Contents