En

Find Rows#

Find rows according to the filter condition, which can be a SQL query.

Table[Data Table] The data table from which rows are extracted.
Filter

[Text] The query string for extracting rows. The string must be written according to SQL language rules.

For example: "column1 >= 230 AND column2 = 'b'".

Result as TableWhen selected, the result will be returned as a data table.
Include Columns

[Text/List] The name of the column, or a list of column names, to include in the resulting table.

For example: @("Column1";"Column2").

Exclude Columns

[Text/List] The name of the column, or a list of column names, to exclude from the resulting table.

For example: @("Column1";"Column2").

Result[List/Data Table] Returns a list of selected rows.
Error Handling Level

Select the error handling level. Possible values:

  • "Default" - by default;
  • "Ignore" - errors are ignored;
  • "Handle" - errors are handled.

If "Default" is selected, the value from the "Start" block of this diagram will be used.

Message Level

Select the message level that blocks will output during operation. Possible values:

  • "Default" - by default;
  • "Release" - output is disabled;
  • "Debug" - outputs main information;
  • "Detailed" - outputs detailed information.

If "Default" is selected, the value from the "Start" block of this diagram will be used.

Error Text[Text] Returns detailed information about the error in case of incorrect execution of the block's work.