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: dataset;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
casesensitive	If set to false then the search by this field is case insensitive, otherwise it is case sensitive.	true, false

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>
 
...