cancel
Showing results for 
Search instead for 
Did you mean: 

Cascading Lookup Breaks with SQL Request on Special Characters

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
Labels: (1)
Version history
Revision #:
2 of 2
Last update:
2 weeks ago
Updated by:
 
Contributors