Select
MySQL Plugin – Select Action
Summary (SEO Meta Description):
The Select Action of the MySQL Plugin allows workflows to query records from a MySQL database.
It supports table selection, column filtering, ordering, and schema mapping for flexible data retrieval.
Overview
The Select Action retrieves data from a specified MySQL table.
You can configure columns, conditions, ordering, and pagination (limit & offset).
This action is ideal for workflows that need dynamic queries, data lookups, or analytics.
Typical Use Cases:
- Query customer or patient records from a database
- Fetch filtered lists for reporting or dashboards
- Paginate large datasets with limit and offset
- Retrieve workflow-specific input data stored in MySQL
⚙️ Configuration
| Field | Description | Type / Options |
|---|---|---|
| Label | Custom name for the action | String |
| Select connection | Choose or create a MySQL database connection | Dropdown |
| Table name | Select the target table | Dropdown |
| Columns | Define columns to retrieve | String (multiple allowed) |
| Condition | WHERE clause condition for filtering | String |
| Order | ORDER BY clause | String |
| Limit | Number of rows to return | Number (default = 0 = no limit) |
| Offset | Starting row position for pagination | Number (default = 0) |
| Inputs | Manual mapping of input fields (optional) | Name + Type |
| Schema (Inputs) | Select or map input schema | Schema selector |
| Outputs | Define output fields (manual mapping optional) | Name + Type |
| Schema (Outputs) | Select or map output schema | Schema selector |
FAQ
Q: Can I select all columns with this action?
A: Yes, if no columns are specified, it defaults to SELECT *.
Q: How can I apply filters dynamically?
A: Use the Condition field to specify WHERE clauses, e.g., status = 'active'.
Q: Does it support pagination?
A: Yes, use Limit and Offset for paging through results.
Keywords: WeHub MySQL Plugin, MySQL Select Action, Database Query Workflow, SQL Data Retrieval, MySQL Automation