Hello together, I would like to update the value "Table or Query" of a Input Data Tool (from "select *" to "select * from table.signals"),
which is configured for a PostgreSQL Database.
The Connection is saved as a Data Connection called "TSA".
Screenshots from the config:
Any ides why it does not work?
Thanks
Does this need to be dynamic? Or just a one-off change? As you can just open the SQL editor from the Input Data tool:
its just a first test, for the final version it needs to by dynamic...
Sorry @listale just made a quick edit whilst you were replying. In your second screenshot where you've highlighted the expression in 'Replace a specific string', I believe you need to trim this down to the 'select *' part (everything after |||).
Thanks @DataNath good idea, unfortunately does not work either
Your default text is not a valid SQL. Just remove "aka:TSA|||".
Also, be sure to add a Browser tool after the Data Input tool and then check the Browser tool in the Interface Designer to display results, otherwise it will appear as if no results.