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. Example of Get Rows by Values Block


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.