No Data Returned When Using a JOIN in SmartList Designer

If we create a JOIN using two tables where one or the other ( or both ) have a large number fields, such as the Sales Transaction Work table, the SQL statement that is created exceeds the limit on the number of characters that can be used for a query in SmartList Designer.

 

                        

We will need to change the fields we select – select only the minimum fields necessary to report your data:

   

This way, the query string will fall under the cut off threshold.

I hope this helps you get started with JOINS in SmartList Designer!

 

Dean M