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)
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.
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. |
Vehicles Table
| Make | Model | Color | Mileage |
|---|---|---|---|
| Volkswagen | Golf | Blue | 40000 |
| Ford | Escort | Red | 55000 |
| Renault | Kangoo | White | 37000 |
| Ford | Mondeo | Red | 28000 |
| Mazda | 2 | Red | 82000 |
| Volkswagen | Golf | Silver | 110000 |
| Volkswagen | Polo | Blue | 72000 |
| Ford | Mondeo | Red | 54000 |
| Renault | Laguna | Black | 46000 |
People Table
| Member ID | Name | Age | Gender |
|---|---|---|---|
| 42 | Dave Sharp | 25 | Male |
| 44 | Joe Bloggs | 37 | Male |
| 96 | Sandra Shield | 42 | Female |
| 107 | Thomas Knight | 21 | Male |
| 251 | Isabelle Jones | 56 | Female |
DriveWorks Tech Tips Portal |
Table Functions A selection of available functionality when pulling data from a DriveWorks Table onto your form. |
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:
The portal provides a search facility, start typing the name of the Tech Tip (as indicated above) to display the Tip you require. |