SELECT queries, for example, in order to use the results in process conditions.CONNECTION_NAME parameter, which corresponds to the connection name, and the QUERY parameter, which corresponds to the query to execute.
CMDx_, where x corresponds to the command number (e.g. CMD1_).
SELECT, INSERT, UPDATE, DELETE, SCALAR, and PROCEDURE.
CONNECTION_NAME parameter with CMDx_. It is not possible to use a global connection and a local connection (e.g. CONNECTION_NAME and CMD2_CONNECTION_NAME).
TRANSACTION parameter with CMDx_. It is not possible to use a global transaction and a local transaction (e.g. TRANSACTION and CMD2_TRANSACTION). It's necessary to define a global connection to be able to define a global transaction.
ExecSqlLogLevel parameter in the web.config file to 0 to deactivate logs, 1 for error logs, 2 for information logs, or 3 for debug logs; the default value is 0.CONNECTION_NAMEweb.config file.QUERYTYPESELECT (default)INSERTUPDATEDELETESCALARPROCEDURETRANSACTIONY, the application triggers a SQL transaction before the request execution and will perform a commit or rollback based on the result.
Default: NON_ERRORCATCH, the application will not return errors to WorkflowGen. This allows an error message to be stored in the ERROR_MESSAGE parameter and to continue the execution.
Default: THROWTIMEOUT30FORM_DATAFORM_DATA file containing the XML process definitionFORM_DATA_GRIDVIEWFORM_DATARESULT_CSV_SEPARATOR, (comma)FORM_DATA_GRIDVIEW parameter, the contents of FORM_DATA must contain at least the XML schema.
FORM_DATA , with the definition of the schema.QUERY_PARAM prefix or by using an at sign (@).QUERY_PARAM_MyParam or @MyParam, where MyParam corresponds to the name of the parameter defined in the query.QUERYSELECT * FROM USERS WHERE LASTNAME = @UserLastnameQUERY_PARAM_UserLastName / @UserLastNameDoeERROR_MESSAGECATCH and an exception is thrown during executionRESULT_COMMITcommit was performed on the transaction
Possible values:Y or NSELECT queryRESULT_ROWx_fieldNamefieldName column for row x
fieldname with your column name (e.g. LASTNAME) and x with the row number (e.g. 2).RESULT_ROW_fieldNamefieldName column for the first row returnedRESULT_JSONJSON formatRESULT_JSON_FILEJSON format stored in a .json fileRESULT_XMLXML formatRESULT_XML_FILEXML format stored in an .xml fileRESULT_CSVCSV formatRESULT_CSV_SEPARATOR parameter.RESULT_CSV_FILECSV format stored in a .csv fileRESULT_CSV_SEPARATOR parameter.SCALAR queryRESULTSCALAR type querySELECT queryCONNECTION_NAMEMainDbSourceQUERYSELECT LASTNAME, FIRSTNAME, USERNAME FROM USERSRESULT_JSON{ "TABLE":[ { "LASTNAME":"Administrator", "FIRSTNAME":"WorkflowGen", "USERNAME":"wfgen_admin" }, { "LASTNAME":"Doe", "FIRSTNAME":"John", "USERNAME":"john.doe" } ] }RESULT_JSON_FILEresult.jsonRESULT_CSV"LASTNAME","FIRSTNAME","USERNAME" "Administrator","WorkflowGen","wfgen_admin""Doe","John","john.doe"RESULT_CSV_FILEresult.csvRESULT_ROW_LASTNAMEAdministratorRESULT_ROW1_FIRSTNAMEWorkflowGenRESULT_ROW2_USERNAMEjohn.doeCONNECTION_NAMEMainDbSourceQUERYSELECT LASTNAME as REQUEST_GRID_LASTNAME, FIRSTNAME as REQUEST_GRID_FIRSTNAME, USERNAME as REQUEST_GRID_USERNAME FROM USERSFORM_DATAFORM_DATAFORM_DATA_GRIDVIEWREQUEST_GRIDFORM_DATA data containing the schema of the array, as shown in the example below:INSERT queryCONNECTION_NAMEMainDbSourceQUERYINSERT INTO WFCATEGORY (ID_CATEGORY,NAME,DESCRIPTION) VALUES (@IdCategory, @Name, @Description)QUERY_PARAM_IdCategory1QUERY_PARAM_NameCategoryNameQUERY_PARAM_DescriptionDescription of the categoryCONNECTION_NAMEMainDbSourceTYPEINSERTQUERYINSERT INTO WFCATEGORY (ID_CATEGORY,NAME,DESCRIPTION) VALUES (@IdCategory, @Name, @Description)@IdCategory1@NameCategoryName@DescriptionDescription of the categoryUPDATE queryCONNECTION_NAMEMainDbSourceQUERYUPDATE WFCATEGORY SET NAME = @Name WHERE ID_CATEGORY = @IdCategoryQUERY_PARAM_IdCategory1QUERY_PARAM_NameNewCategoryNameDELETE queryCONNECTION_NAMEMainDbSourceQUERYDELETE FROM WFCATEGORY WHERE ID_CATEGORY = @IdCategoryQUERY_PARAM_IdCategory1CONNECTION_NAMEMainDbSourceTYPEPROCEDUREQUERYINSERT_CATEGORYQUERY_PARAM_ID_CATEGORY1QUERY_PARAM_NAMECategoryNameQUERY_PARAM_DESCRIPTIONDescription of the categoryPROCEDURE query type does not return a value. If you want to return a value, you must use the SELECT type.CONNECTION_NAMEMainDbSourceTYPESELECTQUERYEXEC GET_USER @USERNAME = @UserQUERY_PARAM_Userwfgen_adminSCALAR queryCONNECTION_NAMEMainDbSourceTYPESCALARQUERYSELECT COUNT(*) FROM USERSRESULT2CONNECTION_NAMEMainDbSourceCMD1_TYPEINSERTCMD1_QUERYINSERT INTO WFCATEGORY (ID_CATEGORY,NAME,DESCRIPTION) VALUES (@IdCategory, @Name, @Description)CMD1_QUERY_PARAM_IdCategory1CMD1_QUERY_PARAM_NameCategoryNameCMD1_QUERY_PARAM_DescriptionDescription of the categoryCMD2_QUERYSELECT NAME FROM WFCATEGORY WHERE ID_CATEGORY = @IdCategoryCMD2_RESULT_ROW_NAMECategoryNameCONNECTION_NAMEMainDbSourceCMD1_TYPEINSERTCMD1_QUERYINSERT INTO WFCATEGORY (ID_CATEGORY,NAME,DESCRIPTION) VALUES (1, "Name", "Description")CMD1_TRANSACTIONYCMD1_ON_ERRORCATCHCMD1_COMMITYCMD1_ERROR_MESSAGENULLCMD2_TYPEINSERTCMD2_QUERYINSERT INTO WFCATEGORY (ID_CATEGORY,NAME,DESCRIPTION) VALUES (1, "OtherName", "Other description")CMD2_TRANSACTIONYCMD2_ON_ERRORCATCHCMD2_COMMITNCMD2_ERROR_MESSAGECannot insert duplicate key in object 'dbo.WFCATEGORY'. The duplicate key value is (1).