Skip to end of metadata
-
Created by Former user, last modified by Former user on Dec 22, 2016
Go to start of metadata
This tag is used to define a field on the page. A field can be a filter, a summary field, or both.
Attributes
| Name | Description | Values |
|---|
| fieldfunction | The value that the field will take. | Valid SQL field or statement |
| fieldname | The value that the field will take if fieldfunction tag is not defined. / The name of the variable that will hold the field's value if fieldfunction tag is defined. | Valid SQL field / Any |
| caption | The name that will appear on the label next to the filter box if it's a filter field and/or on the top of the column if it's a summary field. | Any |
| filter | Defines if the field is a filter field or not | true or false |
| summary | Defines if the field is a summary field or not. | true or false |
| filteravailable | Defines if the field is available to be added/removed from the filters in the preferences section. | true or false |
| available | Defines if the summary field is available to be added/removed from the summary fields in the preferences section. | true or false |
| filterlookupname | Defines the search file that will be used to search for available values for the field. | [[dataset;search_page;search_field;display_field]] |
| mouseover | Defines if the field will appear when you hover the mouse over the field that links to the data entry page. | true or false |
| expand | Defines if the field will appear when the expand button is clicked. | true or false |
| fieldtype | Defines the data type of the field. | integer, string, date, label, float, datetime, sharednote |
| filtercaseinsensitive | Defines if the field is case insensitive or not. | true or false |
| filtertextoption | Defines if the filter field must begin with a value, end with a value, be equal to value, between two values, like a value, contain a value, show a checkbox and filter with value 1 when is checked or show a checkbox and filter by 0=unchecked, 1=checked | beginwith, endwith, equal, range, ge, le, like, contains, checkbox, checkboxonoff |
| link | Turns the field into a link. If it has no prefix it opens in the current browser window. If it has the newwindow prefix it opens in a new window. If it has the drilldown prefix it opens a drilldown xml under the selected row. If it has the drilldownwithparentparams it passes all the filters of the parent xml to the drilldown. | [[prefix:path;*****]] |
| fixedlookup | Used to retrieve the value options for the field and put them in a drop down list. | '[[class.method]]' : '(All,N/A)' ***** |
| filtercondition | Filters the results of the filter. | Valid SQL statement |
| filteronexpand | Defines if the filter field will appear when the expand button is clicked. | true or false |
| dateonly | Defines if the field will be of date type only and ignore the time. | true or false |
| label | The name that will appear on the field's link. | Any |
| formatting | The field formatting setting. | For fieldtype double - the number of digits For fieldtype string - "glossary" to translate the field's value For fieldtype date - "persian" to convert to Persian date (Jalali), "msec" to convert the date to milliseconds |
Examples
fieldfunction
<field>
<fieldname>NAME</fieldname>
<fieldfunction>
CASE
WHEN CONTACTINFORMATION.CITYPE = 'COMPANY'
THEN CONTACTINFORMATION.CICOMPANYNAME
WHEN CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE = 1
THEN CONTACTINFORMATION.CIFIRSTNAME SQL_+ ' ' SQL_+ CONTACTINFORMATION.CILASTNAME
WHEN CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE = 2
THEN CONTACTINFORMATION.CILASTNAME SQL_+ ' ' SQL_+ CONTACTINFORMATION.CIFIRSTNAME
WHEN CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE = 3
THEN CONTACTINFORMATION.CIFIRSTNAME SQL_+ ' ' SQL_+
COALESCE (CONTACTINFORMATION.CIMIDDLENAME SQL_+ ' ','') SQL_+ '' SQL_+ CONTACTINFORMATION.CILASTNAME
WHEN CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE = 4
THEN CONTACTINFORMATION.CILASTNAME SQL_+ ' ' SQL_+
COALESCE (CONTACTINFORMATION.CIMIDDLENAME SQL_+ ' ','') SQL_+ '' SQL_+ CONTACTINFORMATION.CIFIRSTNAME
END
</fieldfunction>
<caption>key_name</caption>
<filter>true</filter>
<filtercaseinsensitive>true</filtercaseinsensitive>
<filtertextoption>contains</filtertextoption>
</field>
fieldname
<field>
<fieldname>TRN_RENTALS.RENTALNOTES</fieldname>
<caption>key_notes</caption>
<summary>true</summary>
<filteravailable>true</filteravailable>
</field>
caption
<field>
<fieldname>RENTAL_TYPE</fieldname>
<fieldfunction>TRN_RENTALTYPES.RENTTYPENAME</fieldfunction>
<caption>key_rental_type</caption>
<summary>true</summary>
</field>
filter
<field>
<fieldname>RENTAL_TYPE_FILTER</fieldname>
<fieldfunction>TRN_RENTALTYPES.RENTTYPENAME</fieldfunction>
<caption>key_rental_type</caption>
<filter>true</filter>
<filterlookupname>dataset;rentals.loadtypes;renttypeid;renttypename</filterlookupname>
</field>
summary
<field>
<fieldname>RENTAL_TYPE</fieldname>
<fieldfunction>TRN_RENTALTYPES.RENTTYPENAME</fieldfunction>
<caption>key_rental_type</caption>
<summary>true</summary>
</field>
filteravailable
<field>
<fieldname>TRN_RENTALS.RENTALNOTES</fieldname>
<caption>key_notes</caption>
<available>true</available>
<filteravailable>true</filteravailable>
<mousover>true</mousover>
</field>
available
<field>
<fieldname>TRN_RENTALS.RENTALNOTES</fieldname>
<caption>key_notes</caption>
<available>true</available>
<filteravailable>true</filteravailable>
<mousover>true</mousover>
</field>
filterlookupname
<field>
<fieldname>CREATEDBY_FILTER</fieldname>
<fieldfunction>CREATEDBY.USERID</fieldfunction>
<caption>key_created_by_user</caption>
<filter>true</filter>
<filteronexpand>true</filteronexpand>
<filterlookupname>dataset;users.load;userid;username:name</filterlookupname>
</field>
mouseover
<field>
<fieldname>TRN_RENTALS.RENTALNOTES</fieldname>
<caption>key_notes</caption>
<available>true</available>
<filteravailable>true</filteravailable>
<mouseover>true</mouseover>
</field>
expand
<field>
<fieldname>UPDATEDBYUNITOUUNAME</fieldname>
<fieldfunction>UPDATEDBYUNIT.OUUNAME</fieldfunction>
<caption>key_updated_by_unit</caption>
<expand>true</expand>
</field>
fieldtype
<field>
<fieldname>TRN_RENTALS.RENTALEFFECTIVEDATE</fieldname>
<caption>key_effective_date</caption>
<expand>true</expand>
<filter>true</filter>
<fieldtype>date</fieldtype>
<filtertextoption>range</filtertextoption>
<filteronexpand>true</filteronexpand>
<dateonly>true</dateonly>
</field>
filtercaseinsensitive
<field>
<fieldname>NAME</fieldname>
<fieldfunction>
CASE
WHEN CONTACTINFORMATION.CIISCOMPANY = 1
THEN CONTACTINFORMATION.CICOMPANYNAME
WHEN CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE = 1
THEN CONTACTINFORMATION.CIFIRSTNAME || ' ' || CONTACTINFORMATION.CILASTNAME
WHEN CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE = 2
THEN CONTACTINFORMATION.CILASTNAME|| ' ' || CONTACTINFORMATION.CIFIRSTNAME
WHEN CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE = 3
THEN CONTACTINFORMATION.CIFIRSTNAME || ' ' ||
COALESCE (CONTACTINFORMATION.CIMIDDLENAME || ' ','') || '' || CONTACTINFORMATION.CILASTNAME
WHEN CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE = 4
THEN CONTACTINFORMATION.CILASTNAME|| ' ' ||
COALESCE (CONTACTINFORMATION.CIMIDDLENAME || ' ','') || '' || CONTACTINFORMATION.CIFIRSTNAME
END
</fieldfunction>
<caption>Name</caption>
<summary>true</summary>
<mouseover>true</mouseover>
<filter>true</filter>
<filteravailable>true</filteravailable>
<filtercaseinsensitive>true</filtercaseinsensitive>
<filtertextoption>contains</filtertextoption>
<link>page.do?xml=contactinfo/contactInformation&act=itm&bh=bind&fc=loadForm&jndi=ejb/CRMUIContactInformation&pv0=((CONTACTINFORMATION.CIID))&pvc=1</link>
</field>
filtertextoption
<field>
<fieldname>TRN_RENTITEMS.RENTALID</fieldname>
<filtertextoption>equal</filtertextoption>
</field>
link
<field>
<fieldname>TRN_RENTALS.RENTALNUM</fieldname>
<caption>key_number</caption>
<summary>true</summary>
<filter>true</filter>
<fieldtype>string</fieldtype>
<filtertextoption>equals</filtertextoption>
<link>page.do?xml=rentals/rental&act=itm&jndi=ejb/CUSTOMCRMUIRental&fc=loadForm&pv0=((TRN_RENTALS.RENTALID))&pvc=1</link>
</field>
fixedlookup
<field>
<fieldname>STATE_FILTER</fieldname>
<fieldfunction>TRN_RENTALS.RENTALSTATE</fieldfunction>
<caption>key_state</caption>
<summary>false</summary>
<filter>true</filter>
<filtertextoption>equal</filtertextoption>
<fixedlookup>ejb/CUSTOMCRMUIRental.getStateOptions:key_all</fixedlookup>
</field>
filtercondition
<field>
<fieldname>CONTACT_INFO_PHONE_FILTER</fieldname>
<fieldfunction>CONTACTINFORMATION.CIID</fieldfunction>
<caption>key_phone_number</caption>
<filter>true</filter>
<filtercondition>
CONTACTINFORMATION.CIID IN (
SELECT CONTACTINFOPHONES.CIID FROM CONTACTINFOPHONES
WHERE CONTACTINFOPHONES.CIPHONEID IN ('#1')
AND CONTACTINFOPHONES.CIPHONEDELETED = 0
)
</filtercondition>
<filterlookupname>dataset;contactinfo.loadphones;ciphoneid;ciphonenum</filterlookupname>
</field>
filteronexpand
<field>
<fieldname>TRN_RENTALS.RENTALEFFECTIVEDATE</fieldname>
<caption>key_effective_date</caption>
<expand>true</expand>
<filter>true</filter>
<fieldtype>date</fieldtype>
<filtertextoption>range</filtertextoption>
<filteronexpand>true</filteronexpand>
<dateonly>true</dateonly>
</field>
dateonly
<field>
<fieldname>TRN_RENTALS.RENTALEFFECTIVEDATE</fieldname>
<caption>key_effective_date</caption>
<expand>true</expand>
<filter>true</filter>
<fieldtype>date</fieldtype>
<filtertextoption>range</filtertextoption>
<filteronexpand>true</filteronexpand>
<dateonly>true</dateonly>
</field>
label
<field>
<fieldname>ITEMS</fieldname>
<fieldfunction>''</fieldfunction>
<caption>key_items</caption>
<summary>true</summary>
<fieldtype>label</fieldtype>
<label>key_items</label>
<link>drilldown:rentals/items;hidefilters~true~TRN_RENTITEMS.RENTALID~((TRN_RENTALS.RENTALID))</link>
</field>
formatting
<field>
<fieldname>BALANCE</fieldname>
<caption>key_balance</caption>
<formatting>2</formatting>
<summary>true</summary>
</field>