Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

    Design SQL Request Form Control that Returns Multiple Fields

    Status: Pending Clean Up

    When Adding a SQL Request Control to a form only one field (column) will be returned. A potential work around is to add multiple SQL of controls.
    1) Create the first SQL request control of display format text to query the primary key column of the desired record.
    2) Create a Form variable of type string named after the primary column and connect it to the value returned by the first SQL action via a formula > = Named Controls <name of SQL control>
    3) All proceeding SQL Request Controls should contain a select statement with the desired field and also include a where clause to include the primaryKeyField = <primaryKeyVariable>
    • Was this article helpful?