The Dynamic Input tool with a DCM connection using the "Modify SQL Query", the "Replace a specific string" seems to be targeting the "Connection ID" attribute instead of the "Query" and the "Update a Where Clause" seems to be impacted as it does not show any WHERE clauses to update.
- Alteryx Designer
- 2022.1
- Dynamic Input tool
- Data Connection Manager DCM
Steps to Replicate
-
Add a Dynamic Input tool
-
In the Dynamic Input tool configuration > click Edit
-
Check on “Use Data Connection Manager (DCM)
-
Set up a Connection
-
Select Data sources > choose a supported DCM type of connection such as SQL Server ODBC
-
From the Connection Manager > select your saved SQL Server DCM connection
-
For the Credentials Connections > select Connect
-
Either in the Visual Query Builder or the SQL Editor > build your query with a where clause
-
For Modify SQL Query > click Add > select “Replace a Specific String” - the “Text To Replace” shows a "Connection ID" attribute instead of the "Query."
-
For the Modify SQL Query > click Add > select “SQL: Update WHERE Clause” - the WHERE clause does not show and is blank
The "Replace a specific string" seems to be targeting the "Connection ID" attribute instead of "Query" and the "Update a Where Clause" seems to be impacted as it does not show any WHERE clauses to update.
Defect GCSE-747
Status: Open
Defect GCSE-747 is targeted to be fixed in a future release.
Workaround A
- Not use Data Connection Manager DCM for the data source