incorrect syntax near ']' – Smartview external
We have a smartlist defined that runs with no issues in Smartlist and Smartview internal as part of our GP 2015R2 installation. However when we attempt to place a condition on certain fields via Smartview External we get an error: incorrect syntax near ‘]’. The smartlist is built from a sql query using a main view and 3 outer joins to the same 2nd view as we have 3 different salesperson name fields. The error seems to occur when we try and enter a condition on one of the salesperson name fields i.e. like or begins with. Has anyone else ever experienced this issue?
If you would like to submit an answer or comment, please sign in to the eOne portal.