...
| 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 is not defined. / the The name of the variable that will hold the field's value if fieldfunction tag is defined. | 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 |
...
| Expand | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| |||||||||
|
excludefromquery