Page Comparison

...

Expand

title	fieldfunction

Code Block

theme	Eclipse
language	xml
title	fieldfunction

<field>
	<fieldname>PRICEPLAN_FILTER<<fieldname>NAME</fieldname>
	<fieldfunction>PRODUCTS.PRODID</fieldfunction><fieldfunction> 
	<caption>PriceCASE Plan</caption>
	<filter>true</filter>
	<filteravailable>true</filteravailable>
	<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>		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>

Expand

title	fieldname

Code Block

theme	Eclipse
language	xml
title	fieldname

<field>
	<fieldname>CONTACTINFORMATION<fieldname>TRN_RENTALS.CIIDNUM<RENTALNOTES</fieldname>
	<caption>ID No.<<caption>key_notes</caption>
	<summary>true</summary>
	<filter>true<<filteravailable>true</filter>filteravailable>
</field>

Expand

title	caption

Code Block

theme	Eclipse
language	xml
title	caption

<field>
	<fieldname>RENTAL_TYPE</fieldname>
	<fieldname>WAREHOUSE<fieldfunction>TRN_RENTALTYPES.WRHDESC<RENTTYPENAME</fieldname>fieldfunction>
	<caption>Description<<caption>key_rental_type</caption>
	<summary>true</summary>
	<filter>true</filter>
</field>

Expand

title	filter

Code Block

theme	Eclipse
language	xml
title	filter

<field>
	<fieldname>CREATEDBY<fieldname>RENTAL_TYPE_FILTER</fieldname>
	<fieldfunction>CREATEDBY<fieldfunction>TRN_RENTALTYPES.USERID<RENTTYPENAME</fieldfunction>
	<caption>Created By<<caption>key_rental_type</caption>
	<filter>true</filter>
	<filteronexpand>true</filteronexpand>
	<filterlookupname>dataset;usersrentals.loadloadtypes;useridrenttypeid;username<renttypename</filterlookupname>
</field>

Expand

title	summary

Code Block

theme	Eclipse
language	xml
title	summary

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

Expand

title	filteravailable

Code Block

theme	Eclipse
language	xml
title	filteravailable

<field>
	<fieldname>CONTACTINFORMATION<fieldname>TRN_RENTALS.CIPASSPORTNUM<RENTALNOTES</fieldname>
	<caption>Passport No.<<caption>key_notes</caption>			
	<available>true</available>
	<filteravailable>true</filteravailable>
	<filteronexpand>true<<mousover>true</filteronexpand>mousover>
</field>

Expand

title	available

Code Block

theme	Eclipse
language	xml
title	available

<field>
	<fieldname>CONTACTINFORMATION<fieldname>TRN_RENTALS.PRIVACYLEVELID<RENTALNOTES</fieldname>
	<caption>Privacy Level<<caption>key_notes</caption>			
	<available>true</available>
	<filteravailable>true</filteravailable>
	<filteronexpand>true<<mousover>true</filteronexpand>mousover>
</field>

Expand

title	filterlookupname

Code Block

theme	Eclipse
language	xml
title	filterlookupname

<field>			
	<fieldname>NEXTBILLRUNID<<fieldname>CREATEDBY_FILTER</fieldname>
	<fieldfunction>NEXTNORMALBILLINGRUN<fieldfunction>CREATEDBY.BILLRUNID<USERID</fieldfunction>
	<caption>Next Billing Run<<caption>key_created_by_user</caption>
	<filter>true</filter>
	<filteronexpand>true</filteronexpand>
	<filterlookupname>dataset;billingusers.loadnormalbillingrunsload;billruniduserid;billrunnum<username:name</filterlookupname>
</field>

Expand

title	mouseover

Code Block

theme	Eclipse
language	xml
title	mouseover

<field>
	<fieldname>FINTRANSACTIONS<fieldname>TRN_RENTALS.FINTRXNNUM<RENTALNOTES</fieldname>
	<caption>No.<<caption>key_notes</caption>
	<summary>true<<available>true</summary>available>
	<mouseover>true</mouseover>
	<filter>true</filter>
	<filteravailable>true</filteravailable>
	<fieldtype>string</fieldtype>
	<filtertextoption>beginwith</filtertextoption>
	<filtersearchonchange>true</filtersearchonchange>
<mousover>true</mousover>
</field>

Expand

title	expand

Code Block

theme	Eclipse
language	xml
title	expand

<field>
	<fieldname>SUBSCRIPTIONS.SUBNUM</fieldname>
	<caption>Subscription<<fieldname>UPDATEDBYUNITOUUNAME</fieldname>
	<fieldfunction>UPDATEDBYUNIT.OUUNAME</fieldfunction>
	<caption>key_updated_by_unit</caption>
	<expand>true</expand>
</field>

Expand

title	fieldtype

Code Block

theme	Eclipse
language	xml
title	fieldtype

<field>
	<fieldname>PRODUCTS<fieldname>TRN_RENTALS.PRODDATECREATED<RENTALEFFECTIVEDATE</fieldname>
	<caption>Date Created<<caption>key_effective_date</caption>
	<expand>true</expand>
	<filter>true</filter>
	<fieldtype>date</fieldtype>
	<filtertextoption>range</filtertextoption>
	<filteronexpand>true</filteronexpand>
	<dateonly>true</dateonly>
</field>

Expand

title	filtercaseinsensitive

Code Block

theme	Eclipse
language	xml
title	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>

Expand

title	filtertextoption

Code Block

theme	Eclipse
language	xml
title	filtertextoption

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

Expand

title	link

Code Block

theme	Eclipse
language	xml
title	link

<field>
	<fieldname>SUBSCRIPTIONS<fieldname>TRN_RENTALS.SUBNUM<RENTALNUM</fieldname>
	<caption>No.<<caption>key_number</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=subscriptionsrentals/subscriptionrental&amp;act=itm&amp;jndi=ejb/CRMUISubscriptionCUSTOMCRMUIRental&amp;fc=loadForm&amp;pv0=((SUBSCRIPTIONSTRN_RENTALS.SUBIDRENTALID))&amp;pvc=1</link>
</field>

Expand

title	fixedlookup

Code Block

theme	Eclipse
language	xml
title	fixedlookup

<field>
	<fieldname>LIFECYCLESTATE<fieldname>STATE_FILTER</fieldname>
	<fieldfunction>REWARDOFFERS<fieldfunction>TRN_RENTALS.LIFECYCLESTATE<RENTALSTATE</fieldfunction>
	<caption>Life Cycle State</caption><caption>key_state</caption>
	<summary>false</summary>
	<filter>true</filter>
	<filtertextoption>equal</filtertextoption>
	<fixedlookup>ejb/CRMUIRewardOfferCUSTOMCRMUIRental.getLifeCycleStateOptionsgetStateOptions:All<key_all</fixedlookup>
</field>

Expand

title	filtercondition

Code Block

theme	Eclipse
language	xml
title	filtercondition

<field>
	<fieldname>COMMUNITY<<fieldname>CONTACT_INFO_PHONE_FILTER</fieldname>
	<fieldfunction>''<<fieldfunction>CONTACTINFORMATION.CIID</fieldfunction>
	<caption>Community<<caption>key_phone_number</caption>
	<filter>true</filter>
	<filteravailable>true</filteravailable>
	<filtercaseinsensitive>true</filtercaseinsensitive>
	<filtercondition>
		OUUNITS.OUGID<filtercondition> 
	CONTACTINFORMATION.CIID IN (
			(SELECT OUUNITSCONTACTINFOPHONES.OUUID 
				CIID FROM OUGROUPSCONTACTINFOPHONES

				INNER JOIN OUCOMMUNITIES OUC ON OUC.OUCID = OUGROUPS.OUCID 
					AND OUC.OUCDELETED = 0
					AND OUC.OUCIDWHERE CONTACTINFOPHONES.CIPHONEID IN ('#1') 
				WHEREAND OUUNITSCONTACTINFOPHONES.OUUDELETEDCIPHONEDELETED = 0
	)
	</filtercondition>
	<filterlookupname>dataset;networkmanagementcontactinfo.loadcommunitiesloadphones;oucid;oucname:oucnum:oucdesc<ciphoneid;ciphonenum</filterlookupname>
</field>

Expand

title	filteronexpand

Code Block

theme	Eclipse
language	xml
title	filteronexpand

<field>
	<fieldname>JOBS<fieldname>TRN_RENTALS.JOBDESC<RENTALEFFECTIVEDATE</fieldname>
	<caption>Description<<caption>key_effective_date</caption>
	<summary>true<<expand>true</summary>expand>
	<expand>false<<filter>true</expand>filter>
	<available>true<<fieldtype>date</available>fieldtype>
	<filter>true<<filtertextoption>range</filter>filtertextoption>
	<filteronexpand>true</filteronexpand>
	<dateonly>true</dateonly>
</field>

Expand

title	dateonly

Code Block

theme	Eclipse
language	xml
title	dateonly

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

Expand

title	label

Code Block

theme	Eclipse
language	xml
title	label

<field>
	<fieldname>ADDRESSES<<fieldname>ITEMS</fieldname>
	<fieldfunction>''</fieldfunction>
	<caption>Addresses<<caption>key_items</caption>
	<summary>true</summary>
	<fieldtype>label</fieldtype>
	<label>Addresses<<label>key_items</label>
	<link>drilldown:contactinforentals/contactInfoActiveAddressesitems;hidefilters~true~CONTACTINFOADDRESSEShidefilters~true~TRN_RENTITEMS.CIID~RENTALID~((CONTACTINFORMATIONTRN_RENTALS.CIIDRENTALID))</link>
</field>

Expand

title	formatting

Code Block

theme	Eclipse
language	xml
title	formatting

<field>
	<fieldname>BUYINADVANCEREQUESTS.BUYINADVREQDURATION<<fieldname>BALANCE</fieldname>
	<caption>Duration<<caption>key_balance</caption>
	<summary>true<<formatting>2</summary>formatting>
	<formatting>0<<summary>true</formatting>summary>
</field>

...

Versions Compared

Old Version 31

New Version 32

Key