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;
  1. 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

  2. Second, add the row below to the end of the Custom SQL filter in the SQL Spreads Designer: OR @Country_Code = '-1'

Feedback and Knowledge Base