Has anyone had issue with the upgrade of workflow from 6.9-6.12 for assigning external data and variables?
Our issue is using 'quotes' within the SQL queries.
Version 6.9, we had the following:
Assign data (arithmetics): GVmyVariable = "'" + GVmyVariable + "'" --> Result should be GVmyVariable with quotes
Assign from external source:
the select clause was like: Select MyColumnName from DatabaseName where myField = GVmyVariable (without quotes, because they are set in the previous step)
Version 6.12: This was not working anymore. (in fact, the workflow engine seems to add on his own quotes)
Workaround: Removing the first arithmetic operation GVmyVariable = "'" + GVmyVariable + "'" and set the quotes within the SQL query:
Select MyColumnName from DatabaseName where myField = 'GVmyVariable'
Very annoying issue, specially for active documents within the workflow.