Page History
...
Common Format Options | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Link To URL | Allows you to pass the value of the returned data into a URL link. Use the hashes ## to indicate to Yellowfin where you want the column value to be placed in the URL itself.
For example: Formatting on a column of IP addresses and the URL typed in is: http://www.google.com.au/search?hl=en&q=##This essentially means that every IP address will be placed into it i.e.: | ||||||||||
Reference Code | Converts the text in the cell to the value of an internal lookup table. E.g. AU to Australia. This also allows for custom sorting, colours, and images to be applied.
| ||||||||||
Raw Formatter | Displayed the data as it would have been returned from the database – no additional formatting applied. | ||||||||||
Text | |||||||||||
Text | Displays as plain text. | ||||||||||
| Case Formatter | Define if the value of the field should be converted to display as a specific case.
| ||||||||||
Creates a hyperlink on the text that will open an email client and pre-populate the sent to address. | |||||||||||
| Flag Formatter | If your data contains ISO country codes you can display these as flags of the world instead of text. | ||||||||||
| HTML Formatter | This allows you to format a field that contains HTML tags.
| ||||||||||
| HTML 5 Video Formatter | This allows you to display video from a path stored in the field.
| ||||||||||
URL Hyperlink | Creates a hyperlink on the text and will open web page on click. Assumes the text is a legitimate URL. | ||||||||||
YouTube Formatter | This allows you to display a YouTube video by using the value in the field as the video ID. | ||||||||||
Date | |||||||||||
Date | Displays value as a date – multiple date options exist.
| ||||||||||
Time | Displays value as a time field – multiple date options exist. | ||||||||||
Timestamp | Displayed full date and time value | ||||||||||
Date Part Formatter | Allows you display part of the date, e.g. Month Name, rather than the full date.
| ||||||||||
Numeric | |||||||||||
Numeric | Displays value as a decimal – allows you to set the decimal places to be used. | ||||||||||
Percentage Bar | Converts a percentage value less than or equal to 100 into a bar. | ||||||||||
| Geometry | |||||||||||
| Default Geometry | This uses the default settings for the geometry, as defined by the source database. | ||||||||||
| Geometry |
| ||||||||||
Access
| Styleclass | ||
|---|---|---|
| ||
| Option | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Access Filter | |||||||||||||||||
| Access Level | |||||||||||||||||
| Field Permissions | |||||||||||||||||
| Mandatory Field | |||||||||||||||||
| This allows you to associate a field with access filter records for use within reports. See Access Filters for more information. | |||||||||||||||||
| Access Level | This allows you to define if all users with access to use the view can see the field, or if it should be hidden and restricted to only a sub set of users, and finally if it's secure. Fields can be restricted to an individual user and/or groups of users. This will allow only those nominated permission to write reports with these fields. Users will need to be nominated through the View Security menu. | ||||||||||||||||
| Field Permissions | Field permissions dictate how the field can be used in reports. For example can the field be displayed, grouped or sorted.
| ||||||||||||||||
| Mandatory Field | Displayed when the access level is set to ‘Global’. It is used when creating a report to determine if the field selected is a mandatory or suggested field. | ||||||||||||||||
| Mandatory Filter | Displayed when the access level is set to ‘Global’. It is used when creating a report to determine if the field selected is a mandatory or suggested filter. | Mandatory Filter |
| horizontalrule |
|---|
| Styleclass | ||
|---|---|---|
| ||