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	The name that will appear next to the criterion box and/or on top of the results column.	A glossary key
alias	The field alias	Any string
expression	A specific value.	VALUE
datatype	The type of the field.	ftxString, ftxInteger, ftxBigDecimal, ftxDateTime, ftxMemo
fieldlen	The field length.	Any number
lookup	Shows a drop-down list in the search criteria.	A reference to a search page element and to the id - value fields dataset;<directory_name>.<filename>;<entity_id>;<entity_search_vaue>
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	Used when a manually created drop-down list is needed.	combobox[;option_value;option_key]+

Examples

Search Products Example

Field Item

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

Search Accounts Example

Field Item

<fields>
	<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.LIFECYCLESTATE</field>
			<label>key_life_cycle_state</label>
			<expression>VALUE</expression>
			<datatype>ftXString</datatype>
			<fieldlen>10</fieldlen>
			<searchcriteria>1</searchcriteria>
			<visible>1</visible>
			<executable>1</executable>
			<displaytype>combobox;;;ACTIVE;key_active;SUSPENDED;key_suspended;TERMINATED;key_terminated</displaytype>
			<indexorder>50</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>
...
<fields>