| application/octetstream: download |
Displays a link to download the binary data of the column. You can use the first option to specify the filename, or use the second option as the name of a column which contains the filename. If you use the second option, you need to set the first option to the empty string. |
| application/octetstream: hex |
Displays hexadecimal representation of data. Optional first parameter specifies how often space will be added (defaults to 2 nibbles). |
| image/jpeg: inline |
Displays a clickable thumbnail. The options are the maximum width and height in pixels. The original aspect ratio is preserved. |
| image/jpeg: link |
Displays a link to download this image. |
| image/png: inline |
Displays a clickable thumbnail. The options are the maximum width and height in pixels. The original aspect ratio is preserved. |
| text/plain: append |
Appends text to a string. The only option is the text to be appended (enclosed in single quotes, default empty string). |
| text/plain: dateformat |
Displays a TIME, TIMESTAMP, DATETIME or numeric unix timestamp column as formatted date. The first option is the offset (in hours) which will be added to the timestamp (Default: 0). Use second option to specify a different date/time format string. Third option determines whether you want to see local date or UTC one (use "local" or "utc" strings) for that. According to that, date format has different value - for "local" see the documentation for PHP's strftime() function and for "utc" it is done using gmdate() function. |
| text/plain: external |
LINUX ONLY: Launches an external application and feeds it the column data via standard input. Returns the standard output of the application. The default is Tidy, to pretty-print HTML code. For security reasons, you have to manually edit the file libraries/transformations/text_plain__external.inc.php and list the tools you want to make available. The first option is then the number of the program you want to use and the second option is the parameters for the program. The third option, if set to 1, will convert the output using htmlspecialchars() (Default 1). The fourth option, if set to 1, will prevent wrapping and ensure that the output appears all on one line (Default 1). |
| text/plain: formatted |
Displays the contents of the column as-is, without running it through htmlspecialchars(). That is, the column is assumed to contain valid HTML. |
| text/plain: imagelink |
Displays an image and a link; the column contains the filename. The first option is a URL prefix like "http://www.example.com/". The second and third options are the width and the height in pixels. |
| text/plain: link |
Displays a link; the column contains the filename. The first option is a URL prefix like "http://www.example.com/". The second option is a title for the link. |
| text/plain: longToIpv4 |
Converts an (IPv4) Internet network address into a string in Internet standard dotted format. |
| text/plain: sql |
Formats text as SQL query with syntax highlighting. |
| text/plain: substr |
Displays a part of a string. The first option is the number of characters to skip from the beginning of the string (Default 0). The second option is the number of characters to return (Default: until end of string). The third option is the string to append and/or prepend when truncation occurs (Default: "..."). |
