How To: Filter Data on SQL Widgets

SQL Widgets has an option to allow widget data to be narrowed down to a specific date period. Enable Chart Filtering option is available at the widget configuration panel.

Check the option to start filtering on your widget contents. Notice on the image below that an error was raised upon enabling chart filtering. To correct this, you need to add the @createdFilter paramater as part of your query:

i.e. Select count(*) from DisplayString where @createdFilter

Note: @createdFilter only uses the field name 'created', so if the table you queried for doesn't have this field, it yields to no result on all other filters except the No Filter.

Save the changes on the widget configuration and you'll see a drop down menu with No Filter selected as default.