Skip to end of banner
Go to start of banner

Fields

Skip to end of metadata
  • Created by Former user, last modified by Former user on Dec 16, 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 32 Next »

This tag is used to define a field on the page. A field can be a filter, a summary field, or both.

Attributes

NameDescriptionValues
fieldfunctionThe value that the field will take.Valid SQL field or statement
fieldnameThe 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
captionThe 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
filterDefines if the field is a filter field or nottrue or false
summaryDefines if the field is a summary field or not.true or false
filteravailableDefines if the field is available to be added/removed from the filters in the preferences section.true or false
availableDefines if the summary field is available to be added/removed from the summary fields in the preferences section.true or false
filterlookupnameDefines the search file that will be used to search for available values for the field.[[dataset;search_page;search_field;display_field]]
mouseoverDefines if the field will appear when you hover the mouse over the field that links to the data entry page.true or false
expandDefines if the field will appear when the expand button is clicked.true or false
fieldtypeDefines the data type of the field.integer, string, date,  label, float, datetime, sharednote
filtercaseinsensitiveDefines if the field is case insensitive or not.true or false
filtertextoptionDefines 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=checkedbeginwith, endwith, equal, range, ge, le, like, contains, checkbox, checkboxonoff
linkTurns 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;*****]]
fixedlookupUsed to retrieve the value options for the field and put them in a drop down list.'[[class.method]]' : '(All,N/A)' *****
filterconditionFilters the results of the filter.Valid SQL statement
filteronexpandDefines if the filter field will appear when the expand button is clicked.true or false
dateonlyDefines if the field will be of date type only and ignore the time.true or false
labelThe name that will appear on the field's link.Any
formattingThe 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
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
fieldname
<field>
	<fieldname>TRN_RENTALS.RENTALNOTES</fieldname>
	<caption>key_notes</caption>
	<summary>true</summary>
	<filteravailable>true</filteravailable>
</field>
 caption
caption
<field>
	<fieldname>RENTAL_TYPE</fieldname>
	<fieldfunction>TRN_RENTALTYPES.RENTTYPENAME</fieldfunction>
	<caption>key_rental_type</caption>
	<summary>true</summary>
</field>
 filter
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
summary
<field>
	<fieldname>RENTAL_TYPE</fieldname>
	<fieldfunction>TRN_RENTALTYPES.RENTTYPENAME</fieldfunction>
	<caption>key_rental_type</caption>
	<summary>true</summary>
</field>
 filteravailable
filteravailable
<field>
	<fieldname>TRN_RENTALS.RENTALNOTES</fieldname>
	<caption>key_notes</caption>
	<available>true</available>
	<filteravailable>true</filteravailable>
	<mousover>true</mousover>
</field>
 available
available
<field>
	<fieldname>TRN_RENTALS.RENTALNOTES</fieldname>
	<caption>key_notes</caption>
	<available>true</available>
	<filteravailable>true</filteravailable>
	<mousover>true</mousover>
</field>
 filterlookupname
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
mouseover
<field>
	<fieldname>TRN_RENTALS.RENTALNOTES</fieldname>
	<caption>key_notes</caption>
	<available>true</available>
	<filteravailable>true</filteravailable>
	<mousover>true</mousover>
</field>
 expand
expand
<field>
	<fieldname>UPDATEDBYUNITOUUNAME</fieldname>
	<fieldfunction>UPDATEDBYUNIT.OUUNAME</fieldfunction>
	<caption>key_updated_by_unit</caption>
	<expand>true</expand>
</field>
 fieldtype
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
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&amp;act=itm&amp;bh=bind&amp;fc=loadForm&amp;jndi=ejb/CRMUIContactInformation&amp;pv0=((CONTACTINFORMATION.CIID))&amp;pvc=1</link>
</field>
 filtertextoption
filtertextoption
<field>
	<fieldname>TRN_RENTITEMS.RENTALID</fieldname>
	<filtertextoption>equal</filtertextoption>
</field>
 link
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&amp;act=itm&amp;jndi=ejb/CUSTOMCRMUIRental&amp;fc=loadForm&amp;pv0=((TRN_RENTALS.RENTALID))&amp;pvc=1</link>
</field>
 fixedlookup
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
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
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
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
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
formatting
<field>
	<fieldname>BALANCE</fieldname>
	<caption>key_balance</caption>
	<formatting>2</formatting>
	<summary>true</summary>
</field>
  • No labels