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 there is no fieldfunction tag / the name of the variable that will hold the field's value.	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.	[[datapath;containing_folder.search_file;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
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

Examples

filteronexpand

Expand

title	filterfieldfunction

title

Code Block

theme	Eclipse
language	xml
title	filterfieldfunction

<fieldlist>
 <field>
		...
 
		<!-- fields -->
		<field>
			<fieldname>PRODUCTS.PRODCODE</fieldname>
			<caption>Code</caption>
		<fieldname>PRICEPLAN_FILTER</fieldname>
	<fieldfunction>PRODUCTS.PRODID</fieldfunction>
	<caption>Price Plan</caption>
	<filter>true</filter>
	<filteravailable>true</filteravailable>
	<fieldtype>string</fieldtype>
	<filtercaseinsensitive>true<<filtercaseinsensitive>false</filtercaseinsensitive>
			<link>page.do?xml=products/product&amp;act=itm&amp;jndi=ejb/CRMUIProduct&amp;fc=loadForm&amp;pv0=((PRODUCTS.PRODID))&amp;pvc=1</link>
		</field>

		<field>
			<fieldname>PRODUCTTYPES.PRODTYPEID</fieldname>
			<caption>Type</caption>
			<filter>true</filter>
			<filterlookupname>dataset;products.loadtypes;prodtypeid;prodtypename</filterlookupname>
		</field>
 
		...
 
</fieldlist>

Image Removed

Expand

<filtercondition>
		PRODUCTS.PRODID IN (
					SELECT PRICEPLANRATES.PRICEPLANRATEPRODID
					FROM  PRICEPLANRATES
					WHERE PRICEPLANRATES.PRICEPLANID IN ('#1') 
					AND PRICEPLANRATES.PRICEPLANRATEDELETED = 0 
		)
	</filtercondition>
	<filteronexpand>true</filteronexpand>			
	<filterlookupname>dataset;priceplan.load;priceplanid;priceplanname</filterlookupname>
</field>

Expand

title	fieldname

Code Block

theme	Eclipse
language	xml
title	filteronexpandfieldname

<fieldlist><field>
 
		...
 
		<!-- fields -->
		<field>
			<fieldname>PRODUCTS.PRODDESC</fieldname>
			<fieldname>CONTACTINFORMATION.CIIDNUM</fieldname>
	<caption>ID No.</caption>
	<summary>true</summary>
	<filter>true</filter>
</field>

Expand

title	caption

Code Block

theme	Eclipse
language	xml
title	caption

<field>
	<fieldname>WAREHOUSE.WRHDESC</fieldname>
	<caption>Description</caption>
		<summary>true</summary>
	<filter>true</filter>
			<filteronexpand>true</filteronexpand>
		</field>

		<field>
			<fieldname>PRICEPLAN</field>

summary

Expand

title	filter

title

Code Block

theme	Eclipse
language	xml
title	filter

<field>
	<fieldname>CREATEDBY_FILTER</fieldname>
			<fieldfunction>PRODUCTS<fieldfunction>CREATEDBY.PRODID<USERID</fieldfunction>
			<caption>Price<caption>Created Plan<By</caption>
			<filter>true</filter>
			<filteravailable>true<<filteronexpand>true</filteravailable>filteronexpand>
			<fieldtype>string</fieldtype>
			<filtercaseinsensitive>false</filtercaseinsensitive>
			<filtercondition>
				PRODUCTS.PRODID IN (
							SELECT PRICEPLANRATES.PRICEPLANRATEPRODID
							FROM  PRICEPLANRATES
							WHERE PRICEPLANRATES.PRICEPLANID IN ('#1') 
							AND PRICEPLANRATES.PRICEPLANRATEDELETED = 0 
				)
			</filtercondition>
			<filteronexpand>true</filteronexpand>			
			<filterlookupname>dataset;priceplan.load;priceplanid;priceplanname</filterlookupname>
		</field>
 
		...
 
</fieldlist>

Image Removed

Expand

<filterlookupname>dataset;users.load;userid;username</filterlookupname>
</field>

Expand

title	summary

Code Block

theme	Eclipse
language	xml
title	summary

<field>
	<fieldname>REPLACEDPRICEPLANNAME</fieldname>
	<fieldfunction>REPLACEDPRICEPLANS.PRICEPLANNAME</fieldfunction>
	<caption>Replaced Price Plan</caption>
	<summary>true</summary>
</field>

Expand

title	filteravailable

Code Block

theme	Eclipse
language	xml
title	filteravailable

<field>
	<fieldname>CONTACTINFORMATION.CIPASSPORTNUM</fieldname>
	<caption>Passport No.</caption>			
	<available>true</available>
	<filteravailable>true</filteravailable>
	<filteronexpand>true</filteronexpand>
</field>

Expand

title	available

Code Block

theme	Eclipse
language	xml
title	available

<field>
	<fieldname>CONTACTINFORMATION.PRIVACYLEVELID</fieldname>
	<caption>Privacy Level</caption>			
	<available>true</available>
	<filteravailable>true</filteravailable>
	<filteronexpand>true</filteronexpand>
</field>

Expand

title	filterlookupname

Code Block

theme	Eclipse
language	xml
title	summary

filterlookupname

<field>		...
 
		<!-- fields -->
		<field><fieldname>NEXTBILLRUNID</fieldname>
			<fieldname>PRODUCTS<fieldfunction>NEXTNORMALBILLINGRUN.PRODALTCODE<BILLRUNID</fieldname>fieldfunction>
			<caption>Alternative Code<<caption>Next Billing Run</caption>
			<summary>true</summary>
		</field>
		<field>
			<fieldname>CLASSIFICATION</fieldname>
			<fieldfunction>PRODUCTTYPES.PRODTYPECLASSIFICATION</fieldfunction>
			<caption>Classification</caption>
			<filter>true</filter>
	<filterlookupname>dataset;billing.loadnormalbillingruns;billrunid;billrunnum</filterlookupname>
</field>

Expand

title	mouseover

Code Block

theme	Eclipse
language	xml
title	mouseover

<field>
	<fieldname>FINTRANSACTIONS.FINTRXNNUM</fieldname>
	<caption>No.</caption>
	<summary>true</summary>
	<mouseover>true</mouseover>
	<filter>true</filter>
	<fixedlookup>ejb/CRMUIProductType.getClassificationOptions:N/A</fixedlookup>
		</field>
 
		...
 
</fieldlist>

Image Removed

<filteravailable>true</filteravailable>
	<fieldtype>string</fieldtype>
	<filtertextoption>beginwith</filtertextoption>
	<filtersearchonchange>true</filtersearchonchange>
</field>

Expand

title	expand

Code Block

theme	Eclipse
language	xml
title	expand

<fieldlist>
 
		...
 
		<!-- fields -->
		<field>
			<fieldname>PRODUCTFAMILIES<fieldname>SUBSCRIPTIONS.PRODFAMILYNAME<SUBNUM</fieldname>
			<caption>Family<<caption>Subscription</caption>
			<expand>true</expand>
		</field>

Expand

title	fieldtype

Code Block

theme	Eclipse
language	xml
title	fieldtype

<field>
			<fieldname>PRODUCTBRANDS<fieldname>PRODUCTS.PRODBRANDNAME<PRODDATECREATED</fieldname>
			<caption>Brand<<caption>Date Created</caption>
			<expand>true</expand>
	<filter>true</filter>
	<<fieldtype>date</field>
 
		...
 fieldtype>
	<filtertextoption>range</filtertextoption>
	<filteronexpand>true</filteronexpand>
</fieldlist>

Image Removed

field>

hidefindbutton

Expand

title	mouseoverfiltercaseinsensitive

title

Code Block

theme	Eclipse
language	xml
title	mouseover

filtercaseinsensitive

<field>
	<fieldname>NAME</fieldname>
	<fieldfunction> 
	CASE 
		WHEN CONTACTINFORMATION.CIISCOMPANY = 1 
		THEN CONTACTINFORMATION.CICOMPANYNAME
	 	WHEN CONTACTINFODEFINITIONS.CIDEFNAMEGENRULE = 1  
		<!-- fields -->
		<field>
			<fieldname>PRODUCTTYPES.PRODTYPENAME</fieldname>
			<caption>Type</caption>
			<summary>true</summary>
			<mouseover>true</mouseover>
		</field>

		<field>
			<fieldname>CLASSIFICATION</fieldname>
			<fieldfunction>PRODUCTTYPES.PRODTYPECLASSIFICATION</fieldfunction>
			<caption>Classification</caption>
			<summary>true</summary>
			<mouseover>true</mouseover>
			<fixedlookup>ejb/CRMUIProductType.getClassificationOptions:N/A</fixedlookup>
		</field>
 
		...
 
</fieldlist>

Image Removed

Expand

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>

Expand

title	filtertextoption

Code Block

theme	Eclipse
language	xml
title	hidefindbutton

<hidefindbutton>true</hidefindbutton>

Image Removed

filtertextoption

<field>
	<fieldname>ACCOUNTSRECEIVABLE.ACCRECID</fieldname>
	<filtertextoption>equal</filtertextoption>
</field>

Expand

title	hidetitlebarlink

Code Block

theme	Eclipse
language	xml
title	hidetitlebar

<hidetitlebar>true</hidetitlebar>

Image Removed

link

<field>
	<fieldname>SUBSCRIPTIONS.SUBNUM</fieldname>
	<caption>No.</caption>
	<summary>true</summary>
	<mouseover>true</mouseover>
	<expand>false</expand>
	<filter>true</filter>
	<fieldtype>string</fieldtype>
	<filtercaseinsensitive>false</filtercaseinsensitive>
	<filtertextoption>equals</filtertextoption>
	<link>page.do?xml=subscriptions/subscription&amp;act=itm&amp;jndi=ejb/CRMUISubscription&amp;fc=loadForm&amp;pv0=((SUBSCRIPTIONS.SUBID))&amp;pvc=1</link>
</field>

Expand

title	messagefixedlookup

Code Block

theme	Eclipse
language	xml
title	messagefixedlookup

<message>Contact information related with persons or companies is retrieved and any details such as addresses, emails, and phones are displayed.</message>

Image Removed

<field>
	<fieldname>LIFECYCLESTATE_FILTER</fieldname>
	<fieldfunction>REWARDOFFERS.LIFECYCLESTATE</fieldfunction>
	<caption>Life Cycle State</caption>
	<filter>true</filter>
	<fixedlookup>ejb/CRMUIRewardOffer.getLifeCycleStateOptions:All</fixedlookup>
</field>

orderbyfields

Expand

title	multiselectfiltercondition

title

Code Block

theme	Eclipse
language	xml
title	multiselect

<multiselect>true</multiselect>

Image Removed

Expand

filtercondition

<field>
	<fieldname>COMMUNITY</fieldname>
	<fieldfunction>''</fieldfunction>
	<caption>Community</caption>
	<filter>true</filter>
	<filteravailable>true</filteravailable>
	<filtercaseinsensitive>true</filtercaseinsensitive>
	<filtercondition>
		OUUNITS.OUGID IN 
			(SELECT OUUNITS.OUUID 
				FROM OUGROUPS 
				INNER JOIN OUCOMMUNITIES OUC ON OUC.OUCID = OUGROUPS.OUCID 
					AND OUC.OUCDELETED = 0
					AND OUC.OUCID IN ('#1')
				WHERE OUUNITS.OUUDELETED = 0)
	</filtercondition>
	<filterlookupname>dataset;networkmanagement.loadcommunities;oucid;oucname:oucnum:oucdesc</filterlookupname>
</field>

Expand

title	filteronexpand

Code Block

theme	Eclipse
language	xml
title	orderbyfieldsfilteronexpand

<field>
	<fieldname>JOBS.JOBDESC</fieldname>
	<caption>Description</caption>
	<summary>true</summary>
	<expand>false</expand>
	<available>true</available>
	<filter>true</filter>
 <orderbyfields>SUBSCRIPTIONS.SUBNUM</orderbyfields>

Image Removed

	<filteronexpand>true</filteronexpand>
</field>

Expand

title	rowsperpagedateonly

Code Block

theme	Eclipse
language	xml
title	rowsperpage

 <rowsperpage>20</rowsperpage>

Image Removed

dateonly

<field>
	<fieldname>CURRENTBILLINGTERMS.BTAGREEMENTDATE</fieldname>
	<caption>Agreement date</caption>
	<summary>false</summary>
	<available>true</available>
	<filter>true</filter>
	<filteravailable>true</filteravailable>
	<fieldtype>date</fieldtype>
	<filtertextoption>range</filtertextoption>
	<filteronexpand>true</filteronexpand>
	<dateonly>true</dateonly>
</field>

Expand

title	groupslabel

<groups>Group 1;Group 2</groups>

Code Block

theme	Eclipse
language	xml
title	groups

label

<field>
	<fieldname>ADDRESSES</fieldname>
	<fieldfunction>''</fieldfunction>
	<caption>Addresses</caption>
	<summary>true</summary>
	<fieldtype>label</fieldtype>
	<label>Addresses</label>
	<link>drilldown:contactinfo/contactInfoActiveAddresses;hidefilters~true~CONTACTINFOADDRESSES.CIID~((CONTACTINFORMATION.CIID))</link>
</field>

Versions Compared

Old Version 20

New Version 21

Key

Examples

Page Comparison

Versions Compared

Old Version 20

New Version 21

Key

Examples