WF_CONFIG_SETTINGS

Contains information about configuration settings for the AgilePoint NX Portal.

Columns

Column Name Definition

ID
Function:
The unique ID for the configuration setting.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
Yes
Foreign Key:
No

COMPONENT_NAME
Function:
The name of the AgilePoint NX component associated with the setting.
Values:
  • Portal
  • PageBuilder
  • TaskListWebPart
  • ProcessDesigner
  • AgilePointServer
  • DataEntity
  • ModernWorkCenter
  • AppBuilder
  • EnterpriseManager
  • FormDesigner
  • MobileSettings
  • Microsoft365AppSettings
Data Type:
varchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CONFIG_GROUP
Function:
The configuration group name associated with the setting.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CONFIG_KEY
Function:
The configuration unique key name for the setting.
Data Type:
varchar
Size:
128
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CONFIG_TYPE
Function:
The data type of the configuration for the setting.
Values:
  • Bool - Holds the true or false value.
  • String - Holds the changes in the string value.
  • Integer - Stores a value in number format.
Data Type:
nvarchar
Size:
128
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CONFIG_VALUE
Function:
The configuration values for the setting.
Data Type:
ntext
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CREATED_BY
Function:
The user who created the setting.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

CREATED_DATE
Function:
The date the setting was created.
Data Type:
datetime
Size:
Null
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_MODIFIED_BY
Function:
The user who last updated, or modified, the setting.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_MODIFIED_DATE
Function:
The date the setting was last modified.
Data Type:
datetime
Size:
Null
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

USER_NAME
Function:
The name of the user for whom the configuration setting applies.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

Relationships

Table Name Relationship
NoneNot applicable