Update Query from Input Data Tool

Question

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

Robin_McIntosh · Answer

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.

listale · Answer

Thanks @DataNath good idea, unfortunately does not work either

DataNath · Answer

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