...
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 numberThe 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
Expand | |||||||||
---|---|---|---|---|---|---|---|---|---|
| |||||||||
|
...