Versions Compared

Old Version 13

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.

...

NameDescriptionValue
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 aliasAny string
expressionA specific value.VALUE
datatypeThe type of the field.ftxString, ftxInteger, ftxBigDecimal, 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
displaytype  Used 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.ACCRECPRIMARY<LIFECYCLESTATE</field>
			<label>key_life_cycle_primary<state</label>
			<expression>VALUE</expression>
			<datatype>ftXInteger<<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