Custom View - Automate_Studio_Manager - Latest

Automate Studio Manager Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio Manager
Version
Latest
Language
English
Product name
Automate Studio Manager
Title
Automate Studio Manager Guide
Copyright
2024
First publish date
2018
Last updated
2024-07-22
Published on
2024-07-22T13:20:59.472887

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