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 (Pending) 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 syncing ...SmartViews Sync Error - "Cannot find column __"
If this error is ever encountered, update SmartViews as this was corrected in v452.1800SmartViews - 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 ...SmartViews - Error “The specified table does not exist [sv_Users]” - Azure Cloud Database
Depending on the version of SmartViews a customer is on, they may experience this error after updating to later versions: “The specified table does not exist [sv_Users]” The following steps should be tried in order to solve the issue. Try logging in ...