Waste flow properties changed unwillingly into product flow properties

Question

Dear All,

An outflow with waste properties has been changed to a product flow with an unappropriate connexion and I cannot change back the flow properties into a waste.

Can anyone help on this ?

Thank you;

Jean-Michel Hébert

Answer 1

First, that's a pretty weird thing to happen, and I would have a bigger concern about making sure there weren't other similar changes. I'll provide a solution here that has no guarantee to fix anything other than making the existing flow into a waste flow. I can't guarantee connections will be fixed or anything. Backup your database first!

Find the flow that needs to be changed to the waste flow and get the UUID to reduce the chance of unintended changes to other flows

Open the SQL tool window. Tools -> Developer tools -> SQL

update tbl_flows
set flow_type='WASTE_FLOW'
where ref_id = 'youruuid-here-0000-0000-000000000000'

The result window should let you know that 1 row was updated. You may need to close and re-open the database to see the change.

Comments

Thank you both we indeed fixed the problem using the SQL tool.