Formula list input pane
The formula list designer takes structural data information and transforms it into a standard list. That is, a list of elements that have unique names, captions, and a number of attributes.
Valid data sources are XML, Lists of values, and the content of CSV files.
The Formula field and Type field are common to all formula lists. Other fields of the list designer depend on the type of data source selected.
XML
Valid XML sources are:
- Table XML
- Tuple XML
- Table XML
- Table XML contains <Table> with multiple <Row> nodes. Each row contains multiple <Property> nodes.
- Tuple XML
- A typical source of Tuple XML is the INITSLICERS function.
To create a formula list from an XML source you:
- Specify XML as the type.
- Specify a formula to connect to the source.
- Specify the attribute to use as element captions.
An attribute is created for each property in the XML. If Object Properties dialog of the object in which the list is displayed. Or, you can turn off automatic mapping and map attributes manually.
is selected, all attributes are available in theFor example, if your XML contains the properties AddressLine1, City, and PostalCode, attributes with those names are created automatically. If you want only the PostalCode attribute to be available, turn off automatic mapping and specify PostalCode in the Source field. In the Name field, specify a name for the attribute: for example Post Code, or Zip.
XML
- CSV
- If you have a variable which holds the content of a CSV file, you can create a formula list from that content.
- List
- You can use a list of values as the source of a formula list. It
is important to note that 'List' does not refer to, for example, a server list
or relational list. It refers instead to a list of values such as that returned
by a GETPROPERTIES or a GETPROPERTYVALUES function. See these topics:
- GETPROPERTIES
- GETPROPERTYVALUES function.