4D v16.3DISTINCT ATTRIBUTE PATHS |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
4D v16.3
DISTINCT ATTRIBUTE PATHS
DISTINCT ATTRIBUTE PATHS
The DISTINCT ATTRIBUTE PATHS command returns the list of distinct paths found in the indexed object field you passed in objectField for the current selection of the table to which this field belongs. In objectField, you must pass an Object type field that is indexed; otherwise, an error is returned. After the call, the size of pathArray is equal to the number of distinct paths found in the selection. Paths to nested object attributes are returned using the standard dot notation, for example "company.address.number". Keep in mind that object attribute names are case-sensitive. The command does not change the current selection or the current record. In pathArray, the list of distinct paths is returned in alphabetical (diacritic) order. Notes:
Your database contains a [Customer]full_Data (indexed) object field with 15 records: If you execute this code: ARRAY TEXT(aTPaths;0) The aTPaths array receives the following elements:
Note: "length" is a virtual property that is automatically available for all array type attributes. It provides the size of the array, i.e. the number of elements, and can be used in queries. For more information, please refer to the Using the .length virtual property paragraph.
See also
|
PROPERTIES
Product: 4D HISTORY
ARTICLE USAGE
4D Language Reference ( 4D v16) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||