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	A specific value.	VALUE
datatype	The type of the field.	ftxString, ftxInteger, ftxFloat, ftxDateTime, ftxMemo
fieldlen	The length of field name.	Any number
lookup	Shows a dropdown list in the search criteria.	A reference to a search page element and to the id - value fields (example: products;products.loadtypes;prodtypeid;prodtypename)
searchcriteria	Defines if the field should be included in the search criteria or not.	1, 0
visible	Defines if the field should be included or not in the results.	1, 0
executable	Indicates if the field will be included in the query.	1, 0
indexorder	The order number of the field to be displayed.	Any number

Example

Field Item

Field Item

...
 
	<fielditem>
		<field>PRODUCTS.PRODID</field>
		<expression>VALUE</expression>
		<datatype>ftXString</datatype>
		<fieldlen>32</fieldlen>
		<searchcriteria>0</searchcriteria>
		<visible>0</visible>
		<executable>1</executable>
		<indexorder>1</indexorder>
	</fielditem>

	<fielditem>
		<field>PRODUCTS.PRODCODE</field>
		<label>Product Code</label>
		<expression>VALUE</expression>
		<datatype>ftXString</datatype>
		<fieldlen>32</fieldlen>
		<searchcriteria>1</searchcriteria>
		<visible>1</visible>
		<executable>1</executable>
		<indexorder>2</indexorder>
	</fielditem>
 
...