Versions Compared

Old Version 8

changes.mady.by.user Former user

Saved on

compared with

New Version 9

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)
expressionA specific value.VALUE
datatypeThe type of the field.ftxString, ftxInteger, ftxFloat, ftxDateTime, ftxMemo
fieldlenThe length of field name.Any number
lookupShows 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)

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

...

Example

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