Keep up to date with the latest information about Microsfot Dynamics GP through articles from the Perfect Image and azurecurve blog.
MS Connect Suggestion: Allow SQL Views to be Included in Workflow Conditions
March 30th, 2017 by Ian Grieve
Through enabling a Dex.ini switch, an enhanced Workflow Condition Query Editor can be enabled, which allows Dexterity tables to be joined into the workflow. However, there have been a few times recently when being able to join in a SQL View would have been most beneficial. This functionality is available in SmartList Designer where Dex tables can be selected and at the bottom of the list is a node for SQL Views which displays all of the views in the database and allows them to be selected.
I’d like the same functionality made available to Workflow Maintenance to add flexibility to workflow design.