Versions Compared

Old Version 6

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.

...

 VALUE
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.expression Specific ValueA glossary key
aliasThe field aliasAny string
expressionA specific value.VALUE
datatype The The type of the field. ftxString, ftxInteger, ftxFloatftxBigDecimal, ftxDateTime, ftxMemo
fieldlen The length of field name An integer The field length.Any number
lookupShow Shows a dropdown drop-down 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 of

dataset;<directory_name>.<filename>;<entity_id>;<entity_search_vaue>

searchcriteriaDefines if the field should be included or not in the search criteria  1 to include the field at search criteria or not.1, 0 to not
visible  Defines of Defines if the field should be included or not in the results. 1 to include the field at results, 0 to not
executable Indicates if the field will be included in the query. 1 to include the field in the query, 0 to not
indexorder The The order number where of the field will to be displayed. An integer numberAny 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
titleSearch 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