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
v480.1000 (2025.01.09) Change to framework 4.8 Remove 32 bit requirement Update DevExpress to v23.2Change to framework 4.8 v462.2001 (8/9/2024) Fixed memory limitations and leaks when loading large amounts of data in a View Turned off automatic ...SmartViews Sync Error - "Cannot find column __"
If this error is ever encountered, update SmartViews as this was corrected in v452.1800SmartViews - User Guide
Prerequisites: Windows Server 2012R2-2022 Windows 8-11 SQL Server 2012R2-SQL 2019 SQL Server 2017 minimum Cumulative Update (CU) is 31 (14.0.3456.2) Visual 7x- .NET 4.6.2 if outgoing ports are blocked at the organization’s firewall, the following ...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 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 ...