Question:
How can I use a Global Workflow Variable in a Where-Clause (e.g., in an assigned data activity) in the Workflow Designer correctly?
Solution:
If you are using a numeric database field in the Where-Clause, please use the following syntax of the "SQL command":
Where-Clause:
CustomerID = GV_CustomerID
But if you are using a database text field in the Where-Clause, it is important that the Global Workflow Variable is written into simple quotes, such as the following example:
Where-Clause:
COMPANY = 'GV_Company'
KBA is applicable to both Cloud and On-premise Organizations.