Update Query from Input Data Tool

[listale]

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

[DataNath]

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:

If it needs to by dynamic with your text input, where you've ticked 'Replace a specific string' - trim this down so it's only the 'select *' part (i.e. everything after |||).

[listale]

its just a first test, for the final version it needs to by dynamic...

[DataNath]

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 |||).

[listale]

Thanks @DataNath good idea, unfortunately does not work either

[Robin_McIntosh]

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.