Field Item
A field item indicates a field in the table or tables that have been used in the search file.
Attributes
| Name | Description | Value |
|---|---|---|
| field | The field name | Any existing field name of a table that exists in database (table.fieldname) |
| expression | Specific Value | VALUE |
| datatype | The type of the field | ftxString, ftxInteger, ftxFloat, ftxDateTime, ftxMemo |
| fieldlen | The length of field name | An integer number |
| lookup | Show a dropdown list in search criteria | A reference to a search page element and to the id - value fields (example: products;products.loadtypes;prodtypeid;prodtypename) |
| searchcriteria | Defines of the field should be included or not in search criteria | 1 to include the field at search criteria, 0 to not |
| visible | Defines of the field should be included or not in results | 1 to include the field at results, 0 to not |
| executable | Indicates if the field will be included in the query | 1 to include the field in the query, 0 to not |
| indexorder | The order number where the field will be displayed | An integer number |