Smartlist Designer – query truncates

Smartlist Designer for Dynamics GP, a nice addition, has a wee bit of a problem!

There seems to be a limit on the length of the query that can be built when you link one or more tables. So, if you select two tables, link them, mark all fields to be included in the output and then look at the SQL Query at the bottom of the window…the SQL query truncates at a certain number of characters.

By removing sufficient fields from the selection, you will eventually get a complete query. I haven’t bothered to count the max number of characters allowed because I just couldn’t be bothered, and I don’t know if this is a bug or ‘by design’!! But if your new smartlist won’t run correctly – maybe its truncated.