Tree Filters - Adding a “Show All” item
When working with Tree/Database import filters, you sometimes would like to have a ”Show All” item that will "disable" the filter and load the rows for all items in the filter:
The technique to add the Show all filter item includes two steps;
- First, add the following code to the top of your Tree/Database import filter definition: SELECT '-1' as Code, 'Show all countries' as Text UNION ALL
- Second, add the row below to the end of the Custom SQL filter in the SQL Spreads Designer: OR @Country_Code = '-1'