Home Search

DriveWorks Pro 22
TableFilterByList

Send Feedback

TableFilterByList

Filters the table on the supplied list of values.

Syntax

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.

Example

RuleResultMeaning
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.

Example Data

This is the Customers table that will be filtered to match the filter list.

FirstNameSecondNameCompanyCityCountry
JeffBeachStromann Roofing LLCColumbusUSA
ThomasJacksonKing LLCSan FranciscoUSA
SamJonesCork & SonsCardiffUnited Kingdom
JulietteDoboisMarquardt PourosLyonFrance
IsabellaWemBayer WelchVelbertGermany
MartinBiddissHowell West LtdLondonUnited Kingdom
FreddieMilletonHill LtdTorontoCanada
PatrickDishmanHarber and DietrichCharlotteUSA
IvettOaksCartman GroupDumfriesUnited Kingdom
TobeHellyarSchneider ManzBerlinGermany