I have built a workflow in FME2015 in which I use SQLExecutor to run a query. I want to use the result of the query to UPDATE a column of table in my database. I am having difficulties in passing the results into the table using a postgis writer with a writer mode in UPDATE. I attach a screenshot of my workflow:
The column I want to update is called: nettype. And I need to update it based on the key: fr_gid. If I understand correctly I need to use the fme_where attribute but I am not sure in what way.