Views:

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.