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. | [[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
filter
<fieldlist> ... <!-- fields --> <field> <fieldname>PRODUCTS.PRODCODE</fieldname> <caption>Code</caption> <filter>true</filter> <filtercaseinsensitive>true</filtercaseinsensitive> <link>page.do?xml=products/product&act=itm&jndi=ejb/CRMUIProduct&fc=loadForm&pv0=((PRODUCTS.PRODID))&pvc=1</link> </field> <field> <fieldname>PRODUCTTYPES.PRODTYPEID</fieldname> <caption>Type</caption> <filter>true</filter> <filterlookupname>dataset;products.loadtypes;prodtypeid;prodtypename</filterlookupname> </field> ... </fieldlist>
filteronexpand
<fieldlist>
...
<!-- fields -->
<field>
<fieldname>PRODUCTS.PRODDESC</fieldname>
<caption>Description</caption>
<filter>true</filter>
<filteronexpand>true</filteronexpand>
</field>
<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>
...
</fieldlist>
summary
<fieldlist> ... <!-- fields --> <field> <fieldname>PRODUCTS.PRODALTCODE</fieldname> <caption>Alternative Code</caption> <summary>true</summary> </field> <field> <fieldname>CLASSIFICATION</fieldname> <fieldfunction>PRODUCTTYPES.PRODTYPECLASSIFICATION</fieldfunction> <caption>Classification</caption> <summary>true</summary> <fixedlookup>ejb/CRMUIProductType.getClassificationOptions:N/A</fixedlookup> </field> ... </fieldlist>
expand
<fieldlist> ... <!-- fields --> <field> <fieldname>PRODUCTFAMILIES.PRODFAMILYNAME</fieldname> <caption>Family</caption> <expand>true</expand> </field> <field> <fieldname>PRODUCTBRANDS.PRODBRANDNAME</fieldname> <caption>Brand</caption> <expand>true</expand> </field> ... </fieldlist>
mouseover
<fieldlist> ... <!-- 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>
hidefindbutton
<hidefindbutton>true</hidefindbutton>
hidetitlebar
<hidetitlebar>true</hidetitlebar>
message
<message>Contact information related with persons or companies is retrieved and any details such as addresses, emails, and phones are displayed.</message>
multiselect
<multiselect>true</multiselect>
orderbyfields
<orderbyfields>SUBSCRIPTIONS.SUBNUM</orderbyfields>
rowsperpage
<rowsperpage>20</rowsperpage>