Skip to end of metadata
-
Created by Former user, last modified by Former user on Dec 15, 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 30
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 | 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>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>