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
Second, add the row below to the end of the Custom SQL filter in the SQL Spreads Designer:
OR @Country_Code = '-1'