|
|
| (47 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| − | ==Overview==
| + | this page can be deleted now. |
| − | | |
| − | The J. River Media Core database engine supports Excel-style functions for use in view schemes, searches, displayed columns, and tag editing.
| |
| − | | |
| − | An expression is a mixture of text, fields, and functions.
| |
| − | | |
| − | Examples:
| |
| − | This is simple text
| |
| − | This is an artist: [Artist]
| |
| − | The song [Name] is rated [Rating] stars
| |
| − | The file is FormatBoolean(IsMissing(), missing from, on) your machine
| |
| − | | |
| − | ====Fields====
| |
| − | | |
| − | Any text between brackets [] will be replaced with the corresponding field. As an example, [Artist] would be replaced by Bob Dylan for any Bob Dylan tracks. If the text between brackets doesn't match any known fields, it will be left alone. After the field name, a comma can be placed followed by a 0 or 1 for whether the field should get formatted. So, [Duration] and [Duration, 1] will give "4:02" while [Duration, 0] will give "242".
| |
| − | | |
| − | ==Functions==
| |
| − | | |
| − | A function allows special operations to be performed. A list of functions follows:
| |
| − | | |
| − | {| border="1"
| |
| − | ! scope="col" style="background: red; color: white" | Function
| |
| − | ! scope="col" style="background: red; color: white" | Description
| |
| − | ! scope="col" style="background: red; color: white" | Examples
| |
| − | |-
| |
| − | ! scope="row" | A Work In Progress
| |
| − | | Cell 2 || Cell 3
| |
| − | |-
| |
| − | ! scope="row" | ==test==
| |
| − | | Cell B
| |
| − | | Cell C
| |
| − | |}
| |
Latest revision as of 13:37, 7 October 2010
this page can be deleted now.
