It is posible to delete the advanced workflow of an application?
I'm not able to delete the advanced workflow design of an application once the button "Click here to create a workflow " is pressed. I need to do this beacuse, the button "save and close" is disabled for all applications with advanced workflows. I pressed "Click here to create a workflow" by mistake and i can't undone it.
I can see Save and Close button as enabled on a Sub-form field in 6.3, thus this seems to be a bug
Along with the new idea, it would be beneficial if we record this defect with RSA.
I'm not aware of any SQL script to fix this. When the issue was discovered, a request was logged with Engineering to provide a workaround/script, but was told it is not as easy as a script. The best option is to push/lean on the Product Team to allow for this functionality.
I have run scripts in our 6.2 environment to remove Advanced Workflow from an application where it was accidentally turned on. I'm not sure if these will work in 6.3, but here is what I did (we do not use Advanced Workflow, so I didn't need to worry about removing it for some applications but not others):
Ran the script below to tell me what application had Advanced Workflow enabled, and get the Level ID:
SELECT * FROM dbo.tblLevelWorkflowProcess
I tried to then delete that Level ID from that table, but got an error about a dependency in another table. I then ran this query to see the dependency and verify it was just the one application:
SELECT * FROM dbo.tblLevelWorkflowProcessTranslation
After verifying just one application was in the query above, I ran this query:
DELETE FROM dbo.tblLevelWorkflowProcessTranslation
WHERE is_default = '1'
I then ran this query:
DELETE FROM dbo.tblLevelWorkflowProcess
WHERE level_id = 'XXX' (change XXX to what is show in the "Level ID" field in the first query)
My application no longer showed Advanced Workflow was enabled.
I tried what you suggested in a vlab and works like a charm. I'm going to test if these changes doesnt affect other functionalities.