Versions Compared

Old Version 11

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
nameblue

Field Item

A field item indicates a field in the table or tables that have been used in the search file.

...

NameDescriptionValue
field The field name.Any existing field name of a table that exists in database (table.fieldname)
labelThe name that will appear next to the criterion box and/or on top of the results column.A glossary key
aliasThe field aliasAny string
expressionA specific value.VALUE
datatypeThe type of the field.ftxString, ftxInteger, ftxFloatftxBigDecimal, ftxDateTime, ftxMemo
fieldlenThe field length of field name.Any number
lookupShows a dropdown drop-down list in the search criteria.

A reference to a search page element and to the id - value fields

(example: dataset;products<directory_name>.loadtypes<filename>;prodtypeid;prodtypename)<entity_id>;<entity_search_vaue>

searchcriteriaDefines if the field should be included in the search criteria or not.1, 0
visibleDefines if the field should be included or not in the results.1, 0
executableIndicates if the field will be included in the query.1, 0
indexorderThe order number of the field to be displayed.Any number
casesensitiveIf set to false then the search by this field is case insensitive, otherwise it is case sensitive.true, false

...

displaytypeUsed when a manually created drop-down list is needed.

combobox[;option_value;option_key]+

Examples

Expand
titleField ItemSearch Products Example
Code Block
themeEclipse
languagexml
titleField 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>

Image Added

Expand
titleSearch Accounts Example
Code Block
themeEclipse
languagexml
titleField 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>

Image Added