Skip to end of metadata
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 28
Next »
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 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. | [[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 | Formats a number to include a certain number of decimal points. | Any number |
Examples
fieldfunction
<field>
<fieldname>PRICEPLAN_FILTER</fieldname>
<fieldfunction>PRODUCTS.PRODID</fieldfunction>
<caption>Price 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>
</field>
fieldname
<field>
<fieldname>CONTACTINFORMATION.CIIDNUM</fieldname>
<caption>ID No.</caption>
<summary>true</summary>
<filter>true</filter>
</field>
caption
<field>
<fieldname>WAREHOUSE.WRHDESC</fieldname>
<caption>Description</caption>
<summary>true</summary>
<filter>true</filter>
</field>
filter
<field>
<fieldname>CREATEDBY_FILTER</fieldname>
<fieldfunction>CREATEDBY.USERID</fieldfunction>
<caption>Created By</caption>
<filter>true</filter>
<filteronexpand>true</filteronexpand>
<filterlookupname>dataset;users.load;userid;username</filterlookupname>
</field>
summary
<field>
<fieldname>REPLACEDPRICEPLANNAME</fieldname>
<fieldfunction>REPLACEDPRICEPLANS.PRICEPLANNAME</fieldfunction>
<caption>Replaced Price Plan</caption>
<summary>true</summary>
</field>
filteravailable
<field>
<fieldname>CONTACTINFORMATION.CIPASSPORTNUM</fieldname>
<caption>Passport No.</caption>
<available>true</available>
<filteravailable>true</filteravailable>
<filteronexpand>true</filteronexpand>
</field>
available
<field>
<fieldname>CONTACTINFORMATION.PRIVACYLEVELID</fieldname>
<caption>Privacy Level</caption>
<available>true</available>
<filteravailable>true</filteravailable>
<filteronexpand>true</filteronexpand>
</field>
filterlookupname
<field>
<fieldname>NEXTBILLRUNID</fieldname>
<fieldfunction>NEXTNORMALBILLINGRUN.BILLRUNID</fieldfunction>
<caption>Next Billing Run</caption>
<filter>true</filter>
<filterlookupname>dataset;billing.loadnormalbillingruns;billrunid;billrunnum</filterlookupname>
</field>
mouseover
<field>
<fieldname>FINTRANSACTIONS.FINTRXNNUM</fieldname>
<caption>No.</caption>
<summary>true</summary>
<mouseover>true</mouseover>
<filter>true</filter>
<filteravailable>true</filteravailable>
<fieldtype>string</fieldtype>
<filtertextoption>beginwith</filtertextoption>
<filtersearchonchange>true</filtersearchonchange>
</field>
expand
<field>
<fieldname>SUBSCRIPTIONS.SUBNUM</fieldname>
<caption>Subscription</caption>
<expand>true</expand>
</field>
fieldtype
<field>
<fieldname>PRODUCTS.PRODDATECREATED</fieldname>
<caption>Date Created</caption>
<expand>true</expand>
<filter>true</filter>
<fieldtype>date</fieldtype>
<filtertextoption>range</filtertextoption>
<filteronexpand>true</filteronexpand>
</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>ACCOUNTSRECEIVABLE.ACCRECID</fieldname>
<filtertextoption>equal</filtertextoption>
</field>
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&act=itm&jndi=ejb/CRMUISubscription&fc=loadForm&pv0=((SUBSCRIPTIONS.SUBID))&pvc=1</link>
</field>
fixedlookup
<field>
<fieldname>LIFECYCLESTATE_FILTER</fieldname>
<fieldfunction>REWARDOFFERS.LIFECYCLESTATE</fieldfunction>
<caption>Life Cycle State</caption>
<filter>true</filter>
<fixedlookup>ejb/CRMUIRewardOffer.getLifeCycleStateOptions:All</fixedlookup>
</field>
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>
filteronexpand
<field>
<fieldname>JOBS.JOBDESC</fieldname>
<caption>Description</caption>
<summary>true</summary>
<expand>false</expand>
<available>true</available>
<filter>true</filter>
<filteronexpand>true</filteronexpand>
</field>
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>
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>
formatting
<field>
<fieldname>BUYINADVANCEREQUESTS.BUYINADVREQDURATION</fieldname>
<caption>Duration</caption>
<summary>true</summary>
<formatting>0</formatting>
</field>