Get Rows by Values
This block is an iterator. Learn more about iterators.
Get rows in a database matching specified column values.
If you are unsure how to use Databases, we have a tutorial that goes over them here.
What does it do?
The Get Rows by Values block accepts 5 values to filter database rows by, each row must match all values provided in the specified columns for it to be returned.
Inputs
Database Required
Provide the name of the database to use for this block.
The database must exist on the current bot.
Example: my_database
Column Required
Provide the name of a column in the selected database.
Make sure that the column exists in the selected database.
Example: my_column
Value Required
Provide a value to look up in the selected database/column.
Example: Example value!
Column 2
Provide the name of a column in the selected database.
Make sure that the column exists in the selected database.
Example: my_column
Value 2
Provide a value to look up in the selected database/column.
Example: Example value!
Column 3
Provide the name of a column in the selected database.
Make sure that the column exists in the selected database.
Example: my_column
Value 3
Provide a value to look up in the selected database/column.
Example: Example value!
Column 4
Provide the name of a column in the selected database.
Make sure that the column exists in the selected database.
Example: my_column
Value 4
Provide a value to look up in the selected database/column.
Example: Example value!
Column 5
Provide the name of a column in the selected database.
Make sure that the column exists in the selected database.
Example: my_column
Value 5
Provide a value to look up in the selected database/column.
Example: Example value!
Sort By
Provide the name of the column to sort the results by.
Example: example_column
Sort Order
Provide the order to sort the results by.
Ascending will sort results (1, 2, 3). Descending will sort results (3, 2, 1).
Example: Ascending
Outputs
This block does not have any outputs.