Forum

Jennifer Häfner
Moderator
    Has successfully completed the online course Intermediate (200)
    Has successfully completed the online course Advanced (300)
    Has successfully completed the online course Basics (100)
    Has successfully completed the online course Advanced (310)
    Has successfully completed the online course Advanced (320)
    Has successfully completed the Intermediate Certification
    Has successfully completed the Advanced Certification
3 years, 1 month ago #34108
Up
1
Down
::

Hi,

if you have a simple SQL statement, like SELECT * FROM Table WHERE name = :autofieldValue:, you do not need a dynamic WHERE statement. In your connector call, just define one input parameter for the autofield value. Then, in the Process Designer, open the input mapping of the connector call and connect the input parameter to the autofield. The same applies for global variables.

If your use case and SQL statement is more complex, please explain it in more detail (you can also add screenshots), so we can find a solution for your problem.