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)
label
alias
expression	A specific value.	VALUE
datatype	The type of the field.	ftxString, ftxInteger, ftxBigDecimal, 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
displaytype

Examples

Search Products Example

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>
	<fielditem>
		<field>PRODUCTS.PRODBRANDID</field>
		<label>key_product_brand</label>
		<expression>VALUE</expression>
		<datatype>ftXString</datatype>
		<fieldlen>32</fieldlen>
		<searchcriteria>1</searchcriteria>
		<visible>0</visible>
		<executable>1</executable>
		<lookup>dataset;products.loadbrands;prodbrandid;prodbrandname</lookup>
		<indexorder>50</indexorder>
	</fielditem>
...

Search Accounts Example

Field Item

...
 
	<fielditem>
			<field> 
				(CASE 
					WHEN CONTACTINFORMATION.CITYPE = 'COMPANY' 
					THEN CONTACTINFORMATION.CICOMPANYNAME
					WHEN (SELECT CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE
						FROM CONTACTINFODEFINITIONS WHERE CIDEFACTIVE = 1 AND CIDEFDELETED = 0) = 1 
					THEN CONTACTINFORMATION.CIFIRSTNAME SQL_+ ' ' SQL_+ 
						CONTACTINFORMATION.CILASTNAME 
					WHEN (SELECT CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE
						FROM CONTACTINFODEFINITIONS WHERE CIDEFACTIVE = 1 AND CIDEFDELETED = 0) = 2 
					THEN CONTACTINFORMATION.CILASTNAME SQL_+ ' ' SQL_+ 
						CONTACTINFORMATION.CIFIRSTNAME 
					WHEN (SELECT CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE
						FROM CONTACTINFODEFINITIONS WHERE CIDEFACTIVE = 1 AND CIDEFDELETED = 0) = 3 
					THEN CONTACTINFORMATION.CIFIRSTNAME SQL_+ ' ' SQL_+ 
						COALESCE (CONTACTINFORMATION.CIMIDDLENAME ,'') SQL_+ ' ' SQL_+ 
						CONTACTINFORMATION.CILASTNAME 
					WHEN (SELECT CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE
						FROM CONTACTINFODEFINITIONS WHERE CIDEFACTIVE =1 AND CIDEFDELETED = 0) = 4 
					THEN CONTACTINFORMATION.CILASTNAME SQL_+ ' ' SQL_+ 
						COALESCE (CONTACTINFORMATION.CIMIDDLENAME ,'') SQL_+ ' ' SQL_+ 
						CONTACTINFORMATION.CIFIRSTNAME
				END)
			</field>
			<label>key_name</label>
			<alias>NAME</alias>
			<expression>VALUE</expression>
			<datatype>ftXString</datatype>
			<fieldlen>256</fieldlen>
			<searchcriteria>1</searchcriteria>
			<visible>1</visible>
			<executable>1</executable>
			<casesensitive>false</casesensitive>
			<indexorder>70</indexorder>
		</fielditem>
		<fielditem>
			<field>ACCOUNTSRECEIVABLE.ACCRECPRIMARY</field>
			<label>key_primary</label>
			<expression>VALUE</expression>
			<datatype>ftXInteger</datatype>
			<fieldlen>10</fieldlen>
			<searchcriteria>1</searchcriteria>
			<visible>1</visible>
			<executable>1</executable>
			<displaytype>combobox;0;key_no;1;key_yes</displaytype>
			<indexorder>80</indexorder>
		</fielditem>
...