Versions Compared

Old Version 7

changes.mady.by.user Vasilis Kleanthous (Unlicensed)

Saved on

compared with

New Version 8

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)
expression Specific Value VALUEA specific value.VALUE
datatype The The type of the field. ftxString, ftxInteger, ftxFloat, ftxDateTime, ftxMemo
fieldlen The The length of field name. An integer Any number
lookupShow Shows a dropdown 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 Defines 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

Examples

Expand
titleField Item
Code Block
themeEclipse
languagexml
titleField 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>
 
...