Cascading Lookup Breaks with SQL Request on Special Characters

Document created by butlerj Support on Dec 19, 2018
Version 1Show Document
  • View in full screen mode
ISSUE
When using 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:
  • "
  • -
  • ,
  • &&
  • #
  • "
ERROR CODE
RESOLUTION
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.
ADDITIONAL INFORMATION
RELATED LINKS

Attachments

    Outcomes