- SQL CONDITION HANDLER*
Generates a SQL WHERE-clause condition string based on the selected extraction type (summary, material, part details, or contact). Use this worker to dynamically route or filter downstream SQL queries according to the CAE data category being extracted.
When to use¶
Classification: process.
Tagged: condition, extraction, filter, routing, sql, transformations, where_clause.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Type Of Extraction | Type of Extraction | string | summary | Selects the category of data to extract; choose ‘summary’ for top-level run summaries, ‘material’ for material property records, ‘part_details’ for part-level metadata, or ‘contact’ for contact-interface data — drives the SQL condition emitted downstream. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| sql_condition_output_1 | sql_condition_output_1 | bulk | Bulk output carrying the generated SQL condition string (or structured filter object) corresponding to the chosen extraction type, ready to be consumed by a downstream SQL query or dataset-transform worker. |
Disciplines¶
- data.dataset.transform
- data.io.sql
Auto-generated from transformation schema. Worker id: sql_condition. Schema hash: b0aed6ed97dd. Hand-curated docs in workerexamples/ override this page when present.