Home Search

DriveWorks Pro 22
TableFilterAll

Send Feedback

TableFilterAll

Eliminates non-matching values from the table.

Syntax

TableFilterAll([Table or Table Name], [Condition], [Ignore Whitespace])

Where:

Table or Table Name is the Table to filter.

Condition is the name of a table containing conditions. The table should not have a header row. Each row should have 2 columns where the first is the column index number to check and the second column is the condition to filter on.

Ignore Whitespace (optional) is True to ignore leading/trailing whitespace characters in text strings in the condition, otherwise False.

Examples

RuleMeaning
TableFilterAll(DwLookupCustomers,DWLookupFilterList, True)Will return an array filtered to display all values from the Customers table that match the conditions given in the table FilterList. Will ignore any leading or trailing whitespace in the given condition table.

Example Data

Customers Table

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance
Dynamo DynamicsIndianaUnited States
Eagle SizzlersMaineUnited States
Everso LuckyVermontUnited States
Forty SomethingsIllinoisUnited States

FilterList Table

1B*
3G*

Available Operators

This is the list of operators that are available to apply to the Condition argument.

Name of OperatorOperatorExample Condition Argument
Less then<"<900"
Less then or Equal to<="<=900"
Greater then>">900"
Greater then or Equal to>=">=900"
Not Equals<>"<>=900"
Equals= (No Symbol Required)"900"
Like"*""*Single*"
Not Like"<>*""<>*Single*"

Example Outcome

CustomerNameCityCountry
Boston BullsHanoverGermany

DriveWorks will return the table above as an array, which will look like:

Table returned as an Array
{"CustomerName","City","Country";"Boston Bulls","Hanover","Germany"}