Custom View
This SQL View is created individually for each solution. It provides information for all data items in the solution - including the solution fields.
In this view, a column is created for each user-defined solution field.
The name of the view is created dynamically. For example: RPT_SoLib1_EVO_RIS_LIB. Here SoLib1 is SolutionName, EVO is first 3 letters of customer account name, RIS is first 3 letters of app name, and LIB is first 3 letters of library name.
Back to Reporting SQL Views.
Field Name | DB Type | Type | Nullable | Description |
---|---|---|---|---|
AppId | uniqueidentifier | Guid | 0 | ID of App to which Data file belongs. |
DataFileID | uniqueidentifier | Guid | 0 | ID of the data file. |
State | smallint | Int16 | 0 | State of data file. Enabled = 0, Disabled =1, Deleted = 2 |
ScriptVersion | smallint | Int16 | 0 | Version of solution to which the data file belongs. |
LibraryId | uniqueidentifier | Guid | 0 | ID of library to which the solution belongs. |
Comments | nvarchar | String | 0 | Comments added while completing a task. |
Description | nvarchar | String | 0 | Description added to the Excel document (data file) when submitting it from Studio. |
RunReason | nvarchar | String | 0 | Reason for run. |
ReviewerId | uniqueidentifier | Guid | 0 | ID of the user who reviewed the data file. |
RunnerId | uniqueidentifier | Guid | 0 | ID or user selected as the Runner for the data file |
SapSystemId | nvarchar | String | 0 | SAP system ID. |
SapConnectionName | nvarchar | String | 0 | SAP connection name. |
SapClient | nvarchar | String | 0 | SAP client. |
SystemPost | bit | Boolean | 0 | Indicates if system post is enabled. |
Version | smallint | Int16 | 0 | version of data file |
CreatedBy | uniqueidentifier | Guid | 0 | Id of the user who created the data file |
CreatedDate | datetime | DateTime | 0 | Date on which data file was created |
ModifiedBy | uniqueidentifier | Guid | 0 | Id of the user who modified the data file |
ModifiedDate | datetime | DateTime | 0 | Date on which data file was last modified |
Status | smallint | Int16 | 0 | status of data file Review = 0, ReadyToRun = 1, Rejected = 2, Completed = 3, ErrorFromSAPWhilePosting = 4, ErrorsWhilePosting = 5, Error = 6, WinshuttleServerError = 7, Cancelled = 8, DataPostingRunning = 10, DataPostingSuccess = 11, DataPostingWithErrors = 12, DataPostingFailed = 13, DataPostingAborted = 14, Draft =15 |
Title | nvarchar | String | 0 | title of data file |
SolutionId | uniqueidentifier | Guid | 0 | Id solution to which data file belong |
TenantId | uniqueidentifier | Guid | 0 | tenant id |
PropPromotionValues | nvarchar | String | 0 | Solution Fields data in json format. |
TotalRows | int | Int32 | 0 | Total number of rows posted |
ErrorRows | int | Int32 | 0 | number of error rows after posting |
AttachmentXml | nvarchar | String | 0 | XML describing all attachments in a data file |
SolutionName | nvarchar | String | 0 | Name of the solution to which data file belong |
FileId | uniqueidentifier | Guid | 0 | This is internal field refer to the document data/file storage of this document. Not valid for Form’s document. |
CreatedByDisplayName | nvarchar | String | 0 | display name of the user who created the data file |
ModifiedByDisplayName | nvarchar | String | 0 | display name of the user who last modified the data file |
SupportingDocs | nvarchar | String | 0 | comma-separated list of supporting documents |
<<Solution Fields>> | depends on field type in the form | Depends on field type in the form | 1 | A column will be created in this view for each user defined solution field |