Skip to content


SmartList not displaying correct field value

mrknight23 asked 8 years ago
I have a SmartList that is built from a SQL View that works correctly in SQL but when I run it in SmartList Builder three columns return "1" instead of the correct value.  The fields are Vendor Name, Payment Terms ID and Payment Priority from the vendor master.  They return the correct values in SQL.  I have not applied any masking within SmartList Builder.

Any ideas?

Thank you,
Melanie Knight
Best Answer
Jared answered 8 years ago
Just wanted to update this post to have the correct answer.  

The SmartList was set as a summary SmartList and was displaying the count for those particular columns.  In the SmartList Builder setup go to options and uncheck the Summary SmartList box.

If you would like to submit an answer or comment, please sign in to the eOne portal.