Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

    Cascading Lookup Breaks with SQL Request on Special Characters

    Summary
    When trying to use cascading looks up on SQL query controls on Nintex Forms, cascading lookup will break if the data in the column that the lookup returns has the following special characters: " - , &&, comma, # "

    Solution
    Create a calculated value that pulls the value of the first SQL Query control.
    1. Name the calculated control and add a formula.
    2. The formula will be "parselookup<name of first SQL Query control>".
    3. Configure the second SQL query to filter off the calculated value control and not the first SQL Query control.