Function PropertyTenantsList
Gets a object of data about Tenants for a Property
PropertyTenantsList([PROPCODE],[CONCODE],[GETMETHOD],[SEPARATOR1],[SEPARATOR2],[EXPRESSION],[EXCLUDEBLANKS])Parameters
| # | Type | Passing | Default | Name | Description/Comments | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | string | required | n/a | PROPCODE | The property code to get Tenant data for | ||||||||||||
| 2 | string | optional | Blank | CONCODE | The Tenancy/Contract code to get Tenant data for | ||||||||||||
| 3 | integer | optional | 1 | GETMETHOD | Method to use to get data
| ||||||||||||
| 4 | string | optional | Depends on GETMETHOD | SEPARATOR1 | Separator normal e.g. ", " | ||||||||||||
| 5 | string | optional | Depends on GETMETHOD | SEPARATOR2 | Separator last e.g. " and " | ||||||||||||
| 6 | string | optional | blank | EXPRESSION | Data expression. Must be in format CLIENT. for fields required. e.g. alltrim(CLIENT.FNAME)+' '+alltrim(CLIENT.SNAME) | ||||||||||||
| 7 | boolean | optional | false | EXCLUDEBLANKS | Exclude blank values |
Returns
The string required
Examples
Will get the property/contract tenants specified fisrt and last name together, separated with comma except the last one with and. Leave out blank names.
[[PropertyTenantsList(PROPCODE,CONCODE,2,", ","and ","alltrim(CLIENT.FNAME)+' '+alltrim(CLIENT.SNAME)",.T.)]]
