DriveWorks Solo 18: ListAll [send feedback...]

ListAll

Lists all the values, pipe-bar separated, in the specified column of the specified table (the values in the first row are treated as header values and are excluded)

Syntax

ListAll([Table], [Column], [Sort Ascending] )

Where:

Table is the table from which to retrieve the data.

Column is the number of the column within the table to retrieve the data from.

Sort Ascending (Optional) is TRUE to sort the results in ascending order, FALSE to sort descending.

Examples

Rule

Meaning
ListAll(DWLookupVehicles, 1)The function looks in the Vehicles table, and retrieves all the data in the first column in the original order.

In this case, that first column contains car makes, so the list;

"Volkswagen|Ford|Renault|Ford|Mazda|Volkswagen|Volkswagen|Ford|Renault" is returned.

ListAll(DWLookupVehicles, 1, TRUE)The function looks in the Vehicles table, and retrieves all the data in the first column in ascending order.

In this case, that first column contains car makes, so the list;

"Ford|Ford|Ford|Mazda|Renault|Renault|Volkswagen|Volkswagen|Volkswagen" is returned.

ListAll(DWLookupVehicles, 1, FALSE)The function looks in the Vehicles table, and retrieves all the data in the first column in descending order.

In this case, that first column contains car makes, so the list;

"Volkswagen|Volkswagen|Volkswagen|Renault|Renault|Mazda|Ford|Ford|Ford" is returned.

ListAll(DWLookupPeople, 3)The function looks in the People table, and retrieves all the data in the third column in the original order.

In this case, that third column contains ages, so the list;

"25|37|42|21|56" is returned.

ListAll(DWLookupPeople, 3, TRUE)The function looks in the People table, and retrieves all the data in the third column in ascending order.

In this case, that third column contains ages, so the list;

"21|25|37|42|56" is returned.

ListAll(DWLookupPeople, 3, FALSE)The function looks in the People table, and retrieves all the data in the third column in descending order.

In this case, that third column contains ages, so the list;

"56|42|37|25|21" is returned.

Example Data

Vehicles Table

MakeModelColorMileage
VolkswagenGolfBlue40000
FordEscortRed55000
RenaultKangooWhite37000
FordMondeoRed28000
Mazda2Red82000
VolkswagenGolfSilver110000
VolkswagenPoloBlue72000
FordMondeoRed54000
RenaultLagunaBlack46000

People Table

Member IDNameAgeGender
42Dave Sharp25Male
44Joe Bloggs37Male
96Sandra Shield42Female
107Thomas Knight21Male
251Isabelle Jones56Female

Table of Contents