Table Apm_Case_Developments
Entity
Entity: Projects.Agile.CaseDevelopments
Case Development. Entity: Apm_Case_Developments (Introduced in version 24.1.3.81)
Summary
Name |
Type |
Description |
Assigned_To_User_Id |
uniqueidentifier |
When the development incurred re-assignment, specifies the new user, to which the case is assigned. |
Case_Development_Id |
uniqueidentifier PK |
Case Development |
Case_Id |
uniqueidentifier |
The case of the case development |
Creation_Time_Utc |
datetime Readonly |
The exact date and time (in UTC) when the development was created |
Creation_User_Id |
uniqueidentifier Readonly |
The user, who created the development. |
Description |
nvarchar(max) |
Detailed description of the development. |
Development_Type |
nvarchar(3) Allowed: EDT , ASN , STA , ASH , STH , Readonly |
Type of the development - Edit, Assignment, Resolve, etc. |
New_System_State |
nvarchar(1) Allowed: 1 , 2 , 3 , 4 , 5 , 6 , 7 |
When the development incurred changing the state of the case, contains the new state. |
Row_Version |
timestamp |
|
Columns
Assigned_To_User_Id
When the development incurred re-assignment, specifies the new user, to which the case is assigned.
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 |
3 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Sec_Users |
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 |
Assigned_To_User_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
no |
Case_Development_Id
Case Development
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 |
Case_Development_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Case_Id
The case of the case development
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_Cases |
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 |
Case_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Creation_Time_Utc
The exact date and time (in UTC) when the development was created
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
CurrentDateTimeUtc |
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 |
yes |
RTF |
no |
Sortable |
yes |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
datetime |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Creation_Time_Utc - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
GreaterThanOrLessThan |
None |
no |
no |
Creation_User_Id
The user, who created the development.
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 |
7 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
yes |
Referenced Table |
Sec_Users |
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 |
Creation_User_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Description
Detailed description of the development.
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 |
2147483647 |
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 |
nvarchar(max) (Allows NULL) |
UI Memo Editor |
yes |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Description - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Like |
None |
no |
no |
Development_Type
Type of the development - Edit, Assignment, Resolve, etc.
Property |
Value |
Allowed Values |
EDT , ASN , STA , ASH , STH |
Auto Complete |
no |
Data Filter |
no |
Default Value |
EDT |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
3 |
Order |
2 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
yes |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
nvarchar(3) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Development_Type - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
New_System_State
When the development incurred changing the state of the case, contains the new state.
Property |
Value |
Allowed Values |
1 , 2 , 3 , 4 , 5 , 6 , 7 |
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 |
4 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
nvarchar(1) (Allows NULL) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
New_System_State - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
yes |
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 |
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 |
timestamp |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
no |