Skip to end of metadata
-
Created by Former user, last modified by Former user on Oct 10, 2016
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 15
Next »
A field item indicates a field in the table or tables that have been used in the search file.
Attributes
Name | Description | Value |
---|
field | The field name. | Any existing field name of a table that exists in database (table.fieldname) |
label | | |
alias | | |
expression | A specific value. | VALUE |
datatype | The type of the field. | ftxString, ftxInteger, ftxBigDecimal, ftxDateTime, ftxMemo |
fieldlen | The length of field name. | Any number |
lookup | Shows a dropdown list in the search criteria. | A reference to a search page element and to the id - value fields (example: dataset;products.loadtypes;prodtypeid;prodtypename) |
searchcriteria | Defines if the field should be included in the search criteria or not. | 1, 0 |
visible | Defines if the field should be included or not in the results. | 1, 0 |
executable | Indicates if the field will be included in the query. | 1, 0 |
indexorder | The order number of the field to be displayed. | Any number |
casesensitive | If set to false then the search by this field is case insensitive, otherwise it is case sensitive. | true, false |
displaytype | | |
Examples
Search Products Example
...
<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>
...
Search Accounts Example
...
<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</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>
...