|DbType||"DbType" is the database type. This input is usually loaded from configuration variables.|
|ConnectionString||"ConnectionString" is the connection string to the database. This input is usually loaded from configuration variables.|
|FileName||"FileName" is the name of the database table on which we would like to run inquire service.|
|Keys||The Keys create the WHERE Clause of the query. The keys are concatenated to form the following pattern:
The AndOr values determine the order in which the keys are run. ANDs are always evaluated before ORs. This is similar to the way a BinaryDecision service works.
This is the container node that contains all the Key nodes. It does not accept any input, but you can Right-Click to add new Keys (Key#0, Key#1, etc.). Each Key below this node is built into the query as a Where Clause.|
|Key||Once EASYProcess builds each Key it will have the following format: [Column] [Operator] [Value]. Whether or not the Value is encased in single quotes is determined by the selected Type.
"Key" is a container node which accepts no input but represents a single Key that can contain information related to a key. Each Key node is indexed.|
|AndOr||"AndOr" is used when we are dealing with more than one key. Valid values are "And" and "Or". If this value is left blank it defaults to "And".
The AndOr values determine the order in which the keys are run. ANDs are always evaluated before ORs.|
|Column||The column to be referenced from the table in the query.|
|Operator||The operator to be used in the Key.|
|Type||This is the data type of the "Value". This determines whether the "Value" is encased in single quotes.|
|Value||the value which we will compare against the "Column" of the this Key.|
|OrderBy||This is the OrderByClause. EASYProcess will add in the words "Order by" before your text, so only the column(s) are required here.|
|Parameters||These are Parameters that are built by EASYProcess with the given input for each Parameter node.
This is the container node that contains all the Parameter nodes. It does not accept any input, but you can Right-Click to add new Parameters (Parameter#0, Parameter#1, etc.). Each Parameter below this node can be used in our query.|
|Parameter||"Parameter" is a container node which accepts no input but represents a single Parameter that can contain Name, Value and DataType of the Parameter. Each Parameter node is indexed.|
|Name||"Name" is the name we would like to assign to the parameter.|
|Value||"Value" is the value we would like to assign to the parameter.|
|DataType||This is the data type of the "Value". This determines whether the "Value" is encased in single quotes.|
|ParametersXml||"ParametersXml" is where we can pass parameters in XML format instead of through the EASYProcess-built parameters. This must have the following format:
|Results||The Results create the SELECT Clause of the query. These are concatenated in the following format:
SELECT [Result1],[Result2], ...
This is the container node that contains all the Result nodes. It does not accept any input, but you can Right-Click to add new Results (Result#0, Result#1, etc.). Each Result below this node is built into the query as select column.|
|Result||The Result is a single expression in the select clause. If the "Expr" node is left blank, the Result will only be the entered "Column". If the "Expr" is not blank, once EASYProcess builds each result it will have the following format:
[Expr] AS [Column]
"Results" is a container node which accepts no input but represents a single Result that can contain a column in itself. Each Result node is indexed.|
|Column||"Column" is the name of the column that we would like to include in the select statement.|
|Expr||The "Expression" is used when using SQL functions such as ROUND, CONCAT, TRIM, and etc. Here are some examples of Expressions:
CASE WHEN [Column]=1 THEN 'True' ELSE 'False' END|
|GroupByClause||This GroupByClause is placed after the WhereClause (created by the Keys). The entire value typed in the GroupByClause node is placed after the WhereClause. EASYProcess does not add add the "group by", so the developer must type "group by" for it to be part of this clause.|
|CommandTimeout||"CommandTimeout" is the timeout for query in milliseconds. After this time the service cancels execution of the query and throws an error.|