Filters the table on the supplied list of values.
TableFilterByList([Table],[Column Index],[Filter List],[Include])
Where:
Table is the table to filter.
Column Index is the index of the column on which to search, starting at 1 for the first column.
Filter List is a Pipebar(|) delimited list of text.
Include is TRUE to include all results matched in the filter, FALSE will exclude results matched in the filter.
| Rule | Result | Meaning |
|---|---|---|
| TableFilterByList(DwLookupCustomers,5,"USA|United Kingdom",TRUE) | {"FirstName","SecondName","Company","City","Country";"Jeff","Beach","Stromann Roofing LLC","Columbus","USA";"Thomas","Jackson","King LLC","San Francisco",""USA";"Sam","Jones","Cork & Sons","Cardiff","United Kingdom";"Martin","Biddiss","Howell West Ltd","London","United Kingdom";"Patrick","Dishman","Harber and Dietrich","Charlotte","USA";"Ivett","Oaks","Cartman Group","Dumfries","United Kingdom"} | The returned array is a new table containing only results that match with the items specified in the filter list for the specified column. |
This is the Customers table that will be filtered to match the filter list.
| FirstName | SecondName | Company | City | Country |
|---|---|---|---|---|
| Jeff | Beach | Stromann Roofing LLC | Columbus | USA |
| Thomas | Jackson | King LLC | San Francisco | USA |
| Sam | Jones | Cork & Sons | Cardiff | United Kingdom |
| Juliette | Dobois | Marquardt Pouros | Lyon | France |
| Isabella | Wem | Bayer Welch | Velbert | Germany |
| Martin | Biddiss | Howell West Ltd | London | United Kingdom |
| Freddie | Milleton | Hill Ltd | Toronto | Canada |
| Patrick | Dishman | Harber and Dietrich | Charlotte | USA |
| Ivett | Oaks | Cartman Group | Dumfries | United Kingdom |
| Tobe | Hellyar | Schneider Manz | Berlin | Germany |