Versions Compared

Old Version 9

changes.mady.by.user Former user

Saved on

compared with

New Version 10

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

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)
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
casesensitiveIf set to false then the search by this field is case insensitive, otherwise it is case sensitive.true, false

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