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 = @FilterCriteria" to the end of it. If there is no WHERE clause, then add "WHERE FilterCriteria = @FilterCriteria".

• Related Articles

• 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 Sync Error - "Cannot find column __"

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

• SmartViews - Using Report Parameters

  In addition to the Filter Criteria window found in Reports and Views, Reports also have parameters that can be set up in the Report Layout Editor. One advantage to using parameters over Filter Criteria is that the parameter values can be displayed in ...

• 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 ...

• SmartViews Error “The specified table does not exist [sv_Users]” - On Premise Installations

  SmartViews has an "On Premise" type of installation that allows customers to use a local SQL Server instead of the Azure cloud database.   Depending on the version they are on, they may experience this error after updating to later versions: “The ...