Continuing my list of suggestions for improving Workflow, I have another one for you to vote for.
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.
You can vote for this suggestion here.
Read original post MS Connect Suggestion: Allow SQL Views to be Included in Workflow Conditions at azurecurve|Ramblings of a Dynamics GP Consultant