DriveWorks Pro 15: ListAll [send feedback...]

LISTALL

Lists all the values, pipe 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] )

Retrieves all data cells from the specified column within the selected table, and returns as a list.

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

Examples

Rule

Meaning
LISTALL(Vehicles, 1)The function looks in the Vehicles table, and retrieves all the data in the first column (as specified by the user). In this case, that first column contains car makes, so the list; "Volkswagen|Ford|Renault|Ford|Mazda|Volkswagen|Volkswagen|Ford|Renault" is returned.

Example Outcomes

Table

Column

Outcome

Vehicles1 "Volkswagen|Ford|Renault|Ford|Mazda|Volkswagen|Volkswagen|Ford|Renault"
People2"Dave Sharp|Joe Bloggs|Sandra Shields|Thomas Knight|Isabelle Jones"

Example Data

Vehicles Table

MakeModelColourMileage
VolkswagenGolfBlue40000
FordEscortRed55000
RenaultKangooWhite37000
FordMondeoRed28000
Mazda2Red82000
VolkswagenGolfSilver110000
VolkswagenPoloBlue72000
FordMondeoRed54000
RenaultLagunaBlack46000

People Table

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

DriveWorks Tech Tips Portal

Table Functions

A selection of available functionality when pulling data from a DriveWorks Table onto your form.

View all Tech Tips

DriveWorks Tech Tips Portal is available to DriveWorks Pro customers with an active subscription and support contract.

Tech Tips provide cut down projects that highlight specific functionality for faster and more effective learning.

To access the portal:

  1. Go to https://hub.driveworks.co.uk/tech-tips/
  2. Login with your DriveWorks Pro account credentials, if asked
  3. Click the Visit Tech Tips Portal button for access

The portal provides a search facility, start typing the name of the Tech Tip (as indicated above) to display the Tip you require.

Table of Contents