SmartViews Sync Error - "Cannot find column __"

If this error is ever encountered, update SmartViews as this was corrected in v452.1800

• Related Articles

• SmartViews - Local DB / Cache Reset

  What is it? SmartViews has a feature called "Reset Local DB," or "Cache Reset" as it was called before v462.1100. When you make changes in SmartViews, those changes don't immediately get pushed to the Cloud; instead, they are only made in a local ...

• SmartViews - Release Notes

  v462.2001 (8/9/2024) Fixed memory limitations and leaks when loading large amounts of data in a View Turned off automatic syncing upon opening/closing SmartViews when the DisableSync flag is true v462.2000 (7/22/2024) Fixed tracking of versions used ...

• SmartViews - User Guide

  Prerequisites: Windows Server 2016-2022 Windows 10-11 SQL Server 2012R2-SQL 2019 SQL Server 2017 minimum Cumulative Update (CU) is 31 (14.0.3456.2) Visual 7x-10 .NET 4.6.2 if outgoing ports are blocked at the organization’s firewall, the following ...

• How to disable syncing for a user

  A user may want to disable their ability to sync if they're working on changes that they don't want to go out to everyone just yet. To do this, open up regedit and go to the following path: ...

• SmartViews Error - Missing FilterCriteria token, Add: FilterCriteria = @FilterCriteria

  If you encounter the above error in SmartViews, you need to add the Filter Criteria to the WHERE clause of the query. Open up the Designer and navigate to SQL Designer -> SQL. If the query already contains a WHERE clause, append "AND FilterCriteria = ...